What should I do if I forget my password in navicat?

#What should I do if navicat forgets my password?

1. Close the running MySQL service: Control Panel → Management Tools → Services → MySQL56 (the version I installed is mysql_5.6.16_32_msi)

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

3. Enter mysqld --skip-grant-tables and press Enter. --skip-grant-tables means to skip the permission table authentication when starting the MySQL service.

Related recommendations: "Navicat for mysql graphic tutorial"

4. Open another DOS window (because the DOS window just now cannot be moved), go to Go to the mysql-bin directory.

5. Enter mysql and press Enter. If successful, the MySQL prompt > will appear.

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

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

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

9. Quit.

10. Log out of the system, re-enter, and log in using the user name root and the new password 123 just set.

The above is the detailed content of What should I do if I forget my password in navicat?. For more information, please follow other related articles on the PHP Chinese website!