MySQL forgot password

Sometimes suddenly forget the MySQL password will be really uncomfortable, here is a MySQL password forgot to reset the password method, operating system Win8,mysql version:5.6.10

1 shut down the Mysql.exe,mysqld.exe process inside the task manager;

2 Open cmd window in MySQL installed folder (shift+ right button)

Enter the Mysqld–skip-grant-tables as follows:

It probably means skipping the authorization form.

3 Landing

At this time the login password is empty, so enter password when the direct return to the line. The results are as follows:

4 Change Password

Update Mysql.user set Password=password (' xxx ') where user = ' root ';

The following are the specific examples:

5 Refresh

After modifying the password, remember to refresh or wait until the next login or the password before the program, refresh the sentence:

Flush privileges;

6 restart

Close Mysql,mysqld, and then restart.

MySQL forgot password