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

Editor to share with you how to solve the problem of navicat connection report 2059 error, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Recently, I need to use a database when learning django, so I downloaded navicat to be used with mysql, but the following problems did occur when connecting:

After searching on the Internet, it was found that the reason for this error was that the encryption rule was mysql_native_password in the previous version of mysql8 and caching_sha2_password in the later version of mysql8.

There are two ways to solve this problem, one is to update the navicat driver to solve this problem, and the other is to change the encryption rule of mysql user login to mysql_native_password.

The second approach is taken according to most of the suggestions on the Internet:

1. Open cmd with administrator privileges, enter mysql-u root-p to enter the password and enter the mysql database

Mysql-u root-p # enter the database

two。 Modify the encryption rules and password and refresh them.

ALTER USER 'root'@'localhost' IDENTIFIED BY' your mysql password 'PASSWORD EXPIRE NEVER; # modify encryption rules ALTER USER' root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your mysql password; # change password FLUSH PRIVILEGES; # refresh data

Under normal circumstances, continue to use navicat to connect to mysql can be successful, but I died in the first step, unable to access the database

I don't know if any of my friends have encountered this kind of situation, but don't panic. Cmd is not allowed to enter. We can log in directly with mysql client.

Enter the password, enter mysql and enter the command in the second point to solve the problem.

The above is all the contents of this article entitled "how to solve the problem of navicat connection report 2059 error". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.