1, first check whether the MySQL service is started, if it has been started to stop the service, can be run in the Start menu, using the command:
Open the first cmd1 window, switch to the MySQL bin directory, and run the command:
-- defaults-file= "F:\ALIME\MySql\mysql-5.7.20-winx64\my.ini"--console--skip-grant-tables
Comments:
This command starts the MySQL service by skipping permission security checks, so that when you connect to MySQL, you do not have to enter a user password. The MySQL service is now open!
This window is reserved for not closing.
2. Open a second CMD2 window to connect to MySQL:
Enter the command:
- -P
Appear:
Enter Password:
Enter the carriage directly here without entering the password.
Then there will be a login success message,
Use the command:
show databases;
To switch to the MySQL database using the command:
use MySQL;
To change the root password using the command: (mysql-5.7.20-winx64)
UPDATE User SET authentication_string=PASSWORD ('root'whereUSER ='root';
Refresh permissions:
privileges;
Then exit and log back in:
Quit
Re-login: You can turn off the previous Cmd1 window. Then start the service with net start MySQL
- -P
Enter a password prompt, enter a new password to log in:
Enter Password: ***********
Display login Information: Success is all OK.
La La la
Mysql Window decompression version forgot password