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

This article is about how to solve the navicat password forgotten problem. Xiao Bian thinks it is quite practical, so share it for everyone to make a reference. Let's follow the editor and have a look.

There is an error prompt when connecting with navicat. It should be the wrong password, but I forgot the root password.

under Windows

1. Run cmd as a system administrator.

2. Check to see if mysql has started, and if it has, stop: net stop mysql.

3. Switch to MySQL installation path: D:\WAMP\MySQL-5.6.36\bin; if you have configured environment variables, you can not switch.

4. On the command line type: mysqld -nt --skip-grant-tables

5. Restart a cmd command window as administrator, type: mysql -uroot -p, Enter to enter database.

6. If you don't want to change the password, just want to see the original password, you can execute this statement on the command line.

Select host,user,password from mysql.user;//to view the user and password.

7. To change the password, execute the following statements from the command line.

use mysqlupdate user set password=password("new_pass") where user="root";// 'new_pass' here change to the password you want to set flush privileges;exit

8. Restart MYSQL and enter your password to log in!

Thank you for reading! About how to solve the problem of navicat password forgotten to share here, I hope the above content can be of some help to everyone, so that everyone can learn more knowledge. If you think the article is good, you can share it so that more people can see it!

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.