MySQL forgot password processing method solution

MySQL forgot password processing method solution:

1. Stop the MySQL service. Open a command line window to stop the MySQL service: Net stop MySQL

2. Start MySQL, general to the installation path of MySQL, find Mysqld-nt.exe

Execution: mysqld-nt--skip-grant-tables The current window will stop.

3. In addition, open a command line window, enter the MySQL installation location under the bin directory, running MySQL

4. Enter the following command:

>use MySQL

>update User Set Password=password ("New_password") where user= "root";

>flush privileges;

>exit

6. With Ctrl+alt+del, find the mysqld-nt process kill it, restart the Mysql-nt service, you can log in with the new password