MySQL 5.7.14 WIN10 Installation

1. Download: http://dev.mysql.com/downloads/mysql/

2. Unzip the zip folder to the specified directory

3. Add Environment variables

Right-click Environment variables, advanced system settings, Properties-

Locate the variable path in the system variable, click Edit, add the decompression path to the last side of the variable value, and the path to the path under the Bin folder, such as:

　　

4. Go to the decompression path and modify the My-default configuration file under the path:

　　

5. Run cmd with administrator privileges, initialize the MySQL database, then create the data directory you just configured and some basic tables for the database system

Desktop Bar Search cmd, right click Get Administrator privileges.

　　

Input: mysqld --initialize

6. Installing the MySQL Service

Input: Mysqld-install

At this point in the list of services there will be a MySQL service, you can use Win+r open run, enter services.msc quickly open the list of services

　　

　　

7. Skip authentication, login database need to enter a password, the previous account is root, password is empty, this version password is not empty, not clear what is, directly skip verification

Input: Mysqld-nt--skip-grant-tables

Then the window will be stuck there, no phenomenon, re-open a CMD command-line window running as Administrator

8. Executive Mysql-uroot

Input: Update mysql.user set Authentication_string=password (' root ') where user= ' root ';

The previous version UPDATE statement appears to be: Update Mysql.user set Password=password (' root ') where user= ' root ';

This version will prompt for no password this field.

Enter quit to launch MySQL

9. Turn off the MySQL service

The first window does not know how to stop, just turn off the good. In the second window with administrator privileges, enter

Netstat-ano | Findstr 3306 can find the PID number of the process occupied by this port 3306

　　

Then execute taskkill/f/pid 8776 to force the shutdown process.

10. Start the MySQL service

Continue to enter net start MySQL to start the service

Entering net stop MySQL is the shutdown service.

Note that MySQL is the name of the service in the list of the corresponding service name, right-click the selected service, select the properties can be seen

　　

Log in to the database mysql-uroot-proot-h localhost-p 3306 MySQL (after-p can not input, enter the password can be entered, and then use MySQL to select MySQL database on the line)

This completes the most basic configuration of the mysql5.7.14 on the win10.

11. Other Configurations

Some other options can be configured in My-default.ini, such as Log-error=e:\mysqld.log, and so on.

MySQL 5.7.14 WIN10 Installation