Install mysql5.7 text tutorial (decompress version) and window10mysql5.7 in Windows 10

Install mysql5.7 text tutorial (decompress version) and window10mysql5.7 in Windows 10

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

Execute the mysqld -- initialize command to initialize the data directory (Be sure not to spell it wrong)

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 (do not enter the number in the command line; otherwise, the command will be skipped, And the can't connect... will appear in another window ..)

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

mysql -u rootupdate 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.

The above section describes how to install the mysql5.7 graphic tutorial (decompress version) in Windows 10. If you have any questions, please leave a message, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!