MySQL Reset root password method under Windows

1. First close the MySQL service net stop MySQL in the command line
2, in the command line into the MySQL installation directory bin directory, to do not check the permissions of the way to start;
Mysqld-nt--skip-grant-tables
The interface will stay there all the time, don't bother with it.

3, and then reopen a command Prompt window, in the command line into the MySQL installation directory under the Bin directory, using a blank password to log in to MySQL with the root user;
Mysql-u Root
Modify the root user's password;
Update Mysql.user set Password=password (' New password ') where user= ' root ';(end must enter a semicolon, or the statement will not be executed)
MySQL flush privileges;

MySQL quit and then

In the command line, go to the MySQL installation directory in the bin directory, press CTRL + ALT + DEL on the keyboard to open Task Manager and end the MYSQL-NT process

Turn the MySQL service off under restart

Then reopen the command line interface
Mysql-uroot-p
Enter your new password on the OK;

MySQL Reset root password method under Windows