Right click on My Computer->Properties->Advanced System Settings->Advanced->Environment Variables->

　　Find the variable Path in the system variables, click edit, add the decompression path at the end of the variable value, the path should be the path under the bin folder, such as:

4.Enter the decompression path and modify the my-default configuration file under the path:

5.Run cmd with administrator privileges to initialize the mysql database, then the newly configured data directory and some basic tables for the database system will be created

　　Search cmd on the desktop bar, right-click to get administrator privileges.

　　 input: mysqld --initialize

6.Install mysql service

　　input: mysqld -install

　　 At this time, there will be a MySQL service in the service list, you can use win+R to open and run, enter services.msc to quickly open the service list

7.Skip authentication, you need to enter a password to log in to the database.The previous account is root, and the password is empty.The password for this version is not empty.If you don’t know what it is, just go straight Skip verification

　　input: mysqld -nt --skip-grant-tables

　　 At this time, the window will be stuck there, there is nothing wrong, reopen a cmd command line window running as an administrator

8.Execute mysql -uroot

　　 input: update mysql.user set authentication_string=password('root') where user='root';

　　 The previous version update statement seems to be: update mysql.user set password=password('root') where user='root';

　　This version will prompt that there is no password field.

　　Enter quit to launch mysql

9.Turn off mysql service

　　 I don’t know how to terminate the first window, just close it.Enter in the second window with administrator rights

　　netstat -ano | findstr 3306 　　 You can find the process PID number occupied by the port 3306

　　 then execute taskkill/f/pid 8776 to forcefully close the process.

10.Start mysql service

　　 continue to enter net start MySQL to start the service

　　Enter net stop MySQL to shut down the service.

　　Note that the name MySQL should be the corresponding service name in the service list.Right-click the selected service and select properties to see it

　　Log in to the database mysql -uroot -proot -h localhost -P 3306 mysql (you don't need to enter after -p, you can enter the password after pressing Enter, and then use use mysql to select the mysql database)

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

11.Other configuration

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

12.Using software (such as Navicat) to connect will report an error

　　ERROR 1862 (HY000): Your password has expired.To log in you must change it using a client that supports expired passwords.

　　Use mysql -uroot -proot to log in, and then enter set password=password('root');

The above is a detailed graphic tutorial for installing mysql 5.7.14 under win10 introduced by the editor.I hope it will be helpful to you.If you have any questions, please leave a message to me.The editor will reply to you in time.Thank you very much for your support to the website!