Mysql 5.7.17 winx64 installation tutorial on win7

Software version and platform: MySQL-5.7.17-winx64, win7 Home Edition

1. Download the installation package

https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.18-winx64.zip

2. Unzip the installation package to your folder. Here, I unzip it to C:\Program Files

3. Open the unzipped folder, I changed its name to Mysql (just for ease of writing), copy my-default.ini, and paste it in the lib folder. Change the file name to my.ini. Copy the following characters and paste them at the bottom of my.ini. You can also modify the fields in the file.

[client]
default-character-set=utf8
[mysqld]
basedir = "C:\Program Files\MySQL"
datadir = "C:\Program Files\MySQL\Mysql\data"
port=3306
default-character-set=utf8

4. Modify environment variables

System variables

Computer-Properties-Advanced System Settings-Environment Variables-System Variables

Create a new variable - variable name MySql_HOME, variable value: C:\Program Files\Mysql

Open Path and add the path where mysql.exe is located, usually C:\Program Files\Mysql\bin

User variables

Add at the end of PATH

%MySql_HOME%\bin;

Note: There must be a ";" at the end of each program path.

5. Configure the database

1. Open CMD as an administrator

2. Type “cd C:\Program Files\Mysql\bin”

3. Register mysql service mysqld --install mysql

4. Initialize the data folder

Type mysqld --initialize-insecure (generate a root account without a password)

It is recommended to copy the above command directly

At this time, a data folder will be generated in the mysql folder, which will contain some files

5. Start the service net start mysql and shut down the service net stop mysql

6. Shut down the mysql service and add the following line under the [mysqld] entry in C:\Program Files\Mysql\lib\my.ini:

skip-grant-tables

Restart the service

Now type in CMD

mysql -u root -p

When the password box pops up, ignore it and press Enter to enter the system

7. Set the password mysqladmin -u root password your password

8. Turn off the mysql service - remove the [mysqld] entry in C:\Program Files\Mysql\lib\my.ini

skip-grant-tables

Restart the service

9. mysql -u root -p the password you set. Login successful

6. Delete mysql

Enter the directory cd C:\Program Files\Mysql\bin

Close the database net stop mysql

Then mysqld --remove

The above is the installation tutorial of Mysql 5.7.17 winx64 on win7 introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!