MySQL shutdown skip-grant-tables fast reset mysql Password

First of all, it is an honor to find this article ...

If you have forgotten the MySQL password, try this method below.

1, open My.ini

The code is as follows	Copy Code
[Mysqld] port=3306 #skip-grant-tables

Add Skip-grant-tables at the end

2, restart the MySQL service, access to the console (Bin directory directly under the Mysql.exe the fastest)

To enter Password: Direct ENTER

3, use the command to modify the password

The code is as follows	Copy Code
Use MySQL; Update user set Password=password (' 12345 ') where user= ' root ';

Well, that's done!

Remember after the modification to the My.ini just added "skip-grant-tables" comment out ...