Install window10 mysql5.7 in the decompressed version and window10mysql5.7

Install window10 mysql5.7 in the decompressed version and window10mysql5.7

1. Decompress mysql-5.7.11-winx64.zip to a folder, such as C: \ DevelopCommon \ mysql-5.7.11-winx64.

 

2. Configure Environment Variables

Variable name: MYSQL_HOME

Variable value: C: \ DevelopCommon \ mysql-5.7.11-winx64

--------------

Variable name: Path

Variable value: % MYSQL_HOME % \ bin

2. Enter the C: \ DevelopCommon \ mysql-5.7.11-winx64 \ bin directory as administrator;

(In the window menu, search for a command prompt and right-click it to run as an administrator)

 

3. Execute the mysqld install command to install mysql

Run the mysqld -- initalize command to initialize the data directory.

Run the net start mysql Command. net is not an internal or external command...

Add the following configuration to the environment variable:

Variable name: Path

Variable value:; % SystemRoot % \ system32;

Run the net start mysql command again

# Remove mysql service mysqld remove

# Disable the mysql service. net stop mysql

 

4. Execute mysql-u root-p

Enter the password root and Access denied for user ....

Solution:

1) stop mysql service and net stop mysql

2) execute mysqld -- skip-grant-tables;

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 your computer. Execute net start mysql

Run mysql-u root-p

Enter the password *****

Install navicat premium

Create a connection

Login, password expired

Solution:

In the successfully logged on doc window, run set password for 'root' @ 'localhost' = password ('root ');

Log on to navicat premium again.

Enter root to log on.