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

This article is to share with you about the solution to navicat connection mysql error 2059. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

The navicat connection mysql reported an error of 2059, as shown in the following figure:

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.

Thank you for reading! On the navicat connection mysql error 2059 solution to share here, I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people 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.