How to solve 1045 error when navicat connects to mysql, navicat1045

How to solve 1045 error when navicat connects to mysql, navicat1045

The following error occurs when navicat for MySQL is connected to the local database:

I checked a lot of information, which means that mysql does not have the permission to remotely connect, that is, the permission is not enough;

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 and mysql is installed on the d disk. If you are using the C disk, you do not 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

Run the preceding command and try again. Is this error still true!

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.