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!