What should I do if I forget my password for navicat for myaql?

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

Related recommendations: "Navicat for mysql usage tutorial"

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

2. Open the DOS window and 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.

4. Open another DOS window (because the DOS window just now cannot be moved) and 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 for navicat for myaql?. For more information, please follow other related articles on the PHP Chinese website!