The solution of forgetting password in navicat

This article is to share with you about the solution to navicat forgetting your password. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

What if navicat forgets his password?

1. Close the running MySQL service: control panel → management tools → service → MySQL56 (my installed version is mysql_5.6.16_32_msi)

2. Open the DOS window and change to the mysql → bin directory. (my installation path is C:\ MySQL\ MySQL Server 5.6)

3. Enter mysqld-- skip-grant-tables enter. Skip-grant-tables means to skip authorization table authentication when starting the MySQL service.

4. Open another DOS window (because the DOS window just now can no longer be moved), and change to the mysql-bin directory.

5. Enter mysql to enter, and if successful, the MySQL prompt will appear.

6. Connect to the permission database: use mysql;.

7. Change the password: update user set password='123' where user= "root"; (don't forget to add the semicolon at the end)

8. Refresh permissions (required): flush privileges;.

9. Quit quit.

10. Log out of the system, enter again, and log in with the user name root and the new password 123 you just set.

Thank you for reading! This is the end of this article on "the solution to navicat forgetting your password". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!