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

This article mainly introduces the navicat connection report 1045 error solution, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

A 1045 error occurred when navicat for MySQL connected to the local database, as shown below:

This indicates that the database password is incorrect when connecting to MySQL, and the problem can only be solved by changing the password.

The resolution steps are as follows:

1. First open the command line: start-> run-> cmd

2. First go to the bin directory of mysql installed on your computer (the installation path of your own software). If it is disk C, you can directly execute the command: mysql-u root mysql

3. Execute the command after entering mysql: UPDATE user SET Password=PASSWORD ('newpassword') where USER='root'

4. If an error of 1820 is reported, execute the command: ALTER USER USER () IDENTIFIED BY 'new password', prompting Query OK, indicating that the password has been modified successfully

5. If an error of 1054 is reported as shown in the figure below, change the command statement to: update user set authentication_string=password ('root') where user='root';.

Because the password field is no longer in the mysql database, the password field has been changed to authentication_string.

6. When you are finished, execute the command: quit or exit, and exit mysql.

Ps: if a 1064 error is reported during the execution of the command, it may be a syntax error. Check your sql statement to see if there are any errors.

Thank you for reading this article carefully. I hope the article "the solution to the error of navicat Link 1045" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.