Installation of mysql5.7 graphic tutorial under Windows 10 (unzipped version)_MySQL

1. Unzip mysql-5.7.11-winx64.zip to a folder, such as C:DevelopCommonmysql-5.7.11-winx64.

2. Configure environment variables

Variable name: MYSQL_HOME

Variable value: C:DevelopCommonmysql-5.7.11-winx64

Variable name: Path

Variable value: %MYSQL_HOME%bin

2. Enter the C:DevelopCommonmysql-5.7.11-winx64bin directory as an administrator;

(Search for command prompt under the window menu, right-click and run as administrator)

3. Execute the mysqld install command to install mysql

Execute the mysqld --initialize command to initialize the data directory (be careful not to spell it wrong)

Execute the net start mysql command. At this time, net is not an internal or external command of the system. . .

Add the following configuration in the environment variables:

Variable name: Path

　 Variable value: ;%SystemRoot%system32;

Execute the net start mysql command again

　　　#Remove mysql service mysqld remove
　　#Close mysql service net stop mysql

4. Execute mysql -u root -p

Enter the password root, Access denied for user appears....

Solution:

1) Stop mysql service, net stop mysql

2) Execute mysqld --skip-grant-tables (Do not enter the ; sign in the command line, otherwise the command will be skipped, and another window will appear and can't connect..)

3) Open a new window, keep the original window, and execute

mysql -u root
update mysql.user set authentication_string=password('rocky') where user='root' and Host='localhost';
　　　　flush privileges;
quit;

Restart the computer. Execute net start mysql

Execute mysql -u root -p

Enter password*****

Install navicat premium

Create a connection

Log in, password expired

Solution:

In the doc window where you just logged in successfully, execute set password for 'root'@'localhost' = password('root') ;

Log in to navicat premium again

Enter root root to log in successfully

The above is the graphic tutorial (unzipped version) for installing mysql5.7 under Windows 10 introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support of the website!