Shulou(Shulou.com)06/01 Report--

Editor to share with you how to solve the problem of navicat for myaql password forgotten, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

What if I forget my password for navicat for myaql? The solution is as follows:

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.

The above is all the contents of this article entitled "how to solve the problem that the navicat for myaql password has been forgotten". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.