Win10 install mysql5.7.14 detailed graphic tutorial
2.Unzip the zip folder to the specified directory
3.Add environment variables
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.
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!