Windows MySQL forgot root password solution (load) learning

MySQL version: 5.1\5.5

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 ';

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.

Original path: http://www.cnblogs.com/andy_tigger/archive/2012/04/12/2443652.html

Windows MySQL forgot root password solution (load) learning