Mysql forgot database Password

How to modify the MySQL password under Windows 1. Close the running MySQL service:

A. Run the net stop MySQL under the command

B. Find the MySQL service stop MySQL service

C. Ending the MySQL process in Task Manager

2. Open the command line and go to the MySQL bin directory

C:\USERS\ADMINISTRATOR>CD C:\Program files\mysql\mysql Server 5.5\bin

3. Skip Login Verification

Input: Mysqld-nt--skip-grant-tables, then enter, if there is no error message, on the line;
Note: After the skip-grant-tables parameter is used, the login check can be skipped;

4. Other operations

Open a command line again (because the DOS window is no longer moving), also go to the MySQL bin directory;

MySQL and enter, if successful, a MySQL prompt will appear >

5. Switch to the MySQL user table

Execute: Use MySQL;

Change Password: UPDATE user SET Password=password ("123456") WHERE user= "root";

6. Refresh Permissions

FLUSH privileges;

End!

Mysql forgot database Password