Solution to 1045 error when navicat connects to mysql

When connecting to the local database, navicat for MySQL shows a 1045 error as shown below:

After checking a lot of information, it means that MySQL does not authorize remote connection, that is, the permissions are insufficient;

Solution:

1. First open the command line: Start->Run->cmd.
2. First enter the bin directory of mysql installed on the computer. Because I use phpstudy, mysql is installed in the D drive. If yours is the C drive, you don’t need to execute the first command.

D: 
cd D:\phpStudy\MySQL\bin 
mysql -u root mysql 

mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root'; 
mysql> FLUSH PRIVILEGES; 
mysql> quit 

After executing the above command, try again and see if this error still occurs!

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.