MySQL database modify root password method

How to modify the MySQL Super Administrator root password under window

1 Stop Service

Start-and-run input cmd, open a command Prompt window, and then enter net Stopmysql to stop MySQL-related services

2 in the Command Prompt window, go to the bin directory of the MySQL installation directory

If the other disk, please switch to another disk such as input D: Enter, and then enter the CD file path for example

CD D:\wamp\bin\mysql\mysql5.5.20\bin can be accessed under this folder

3 Enter MySQL security mode (so that you do not need to enter a password to enter the MySQL database)

Input Mysqld--skip-grant-tables, at this time the screen does not react, no tube, put it on OK

4 Open a new command window, enter mysql-uroot-p directly, prompt for password, do not need to enter, directly enter the can, and then go to the MySQL database

5 Enter the following command to modify the root user password

Update Mysql.user set Password=password (' 000000 ') whereuser= ' root ';

Mysql.user: Remember that there is a "." for the user table.

000000: That is the new password

6, Refresh the Permissions table, enter the following command flush privileges;

7, exit, enter the following command quit

8 Restarting the MySQL service is OK.

MySQL database modify root password method