• notice
  • Congratulations on the launch of the Sought Tech site

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.

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!


Technical otaku

Sought technology together

Related Topic


Leave a Reply