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:
net stop MySQL
Open the first cmd window, switch to the MySQL bin directory, and run the command:
Mysqld--defaults-file= "C:\Program files\mysql\mysql Server 5.1\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.
2. Open a second cmd window and connect to MySQL:
Enter the command:
Mysql-uroot-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:
UPDATE user SET Password=password (' NewPassword ') where user= ' root ';
High version by:
UPDATE user SET Authentication_string=password (' root ') where user= ' root ';
Refresh permissions:
FLUSH privileges;
Then exit and log back in:
Quit
Re-login:
Mysql-uroot-p
Enter a password prompt, enter a new password to log in:
Enter Password: ***********
Display login Information: Success is all OK.
A workaround for MySQL forgot root password under windows