MySql5. 7.26 installation

1. download ： Address https://dev.mysql.com/downloads/mysql/5.7.html#downloads

Choose the version

Choose... According to your own needs 32 Bit or 64 Bit version （ Choose here 64 position ） Click to download

Enter the download page and operate according to the following figure

2. Where to place the unzipped file ： Here, unzip the downloaded file to D:Software Next

Internal file structure after decompression ：（ There's no data The folder and my.ini file ）

3. newly build my.ini Put the files directly into the directory ：D:Softwaremysql-5.7.26-winx64

my.ini The contents of the document ：

[mysqld]
# Set up 3306 port
port=3306
# Set up mysql Installation directory
basedir=D:Softwaremysql-5.7.26-winx64
# Set up mysql Database data storage directory
datadir=D:Softwaremysql-5.7.26-winx64Data
# Maximum connections allowed
max_connections=200
# Number of connection failures allowed . This is to prevent someone from trying to attack the database system from the host
max_connect_errors=10
# The character set used by the server defaults to UTF8
character-set-server=utf8
# The default storage engine that will be used when creating a new table
default-storage-engine=INNODB
# By default “mysql_native_password” Plug in authentication
default_authentication_plugin=mysql_native_password
[mysql]
# Set up mysql Client default character set
default-character-set=utf8
[client]
# Set up mysql The default port when the client connects to the server
port=3306
default-character-set=utf8

What needs to be noted here is my.ini Creating a new file is best text file , Put the code above text In the document , And modify the new text The document and its suffix are my.ini

Otherwise, it may be executed at that time mysqld --initialize The following error prevented the installation mysql

4. Computer environment configuration

New environment variable

Variable name ：MYSQL_HOME

A variable's value ：D:Softwaremysql-5.7.26-winx64 （MySql The directory where the file is decompressed ）

To configure Path:

Here is win10 System , stay path Add in %MYSQL_HOME%in

5. Run as administrator and open cmd Command window

Switch to the corresponding D:Softwaremysql-5.7.26-winx64in Under the table of contents

6.MySql install

Get into bin Catalog , Carry out orders

mysqld --initialize ( This will generate data Catalog )

perform mysqld -install mysql57( install ： Be careful mysql57 Is the alias of the installation service , There's no need to write , The default installation service name is mysql)

function net start mysql57 start-up mysql57 service

Service started successfully

7. Change Password （ If you forget the database password later, you can also reset it in this way ）

stay my.ini file （MySQL Configuration file for ） Of [mysqld] Add a line below skip-grant-tables // Skip permission verification and log in to the database directly without user name and password ,（ Be careful ： I'm revising it my.ini There are some problems with the file , It is suggested that my.ini File copy to text In file , And then text Change the file to my.ini）

Restart the service after modifying the configuration file ： Carry out orders mysql -uroot -p The following password is arbitrary and directly enters the database

Then set the account and password ：update mysql.user set authentication_string=password(“root”) where user=“root”

After modification , sign out quit

Out of Service ：net stop mysql57

Delete my.ini The code in skip-grant-tables

Restart the service net start mysql57

mysql -uroot -proot Login database