This article is a mirror article of machine translation, please click here to jump to the original article.

Architect_Programmer_Code Agriculture Network»Architect › Database & Database › MySQL › Navicat connects to MySQL 8.0.18 with a 2059 error
View: 11396|Reply: 0

[Source] Navicat connects to MySQL 8.0.18 with a 2059 error

[Copy link]
Posted on 2/8/2020 7:41:35 PM | | | |
When connecting to MySQL using Navicat Premium, the following error occurs:
2059 - Authentication plugin 'caching sha2_ password' cannot be loaded:



A 2059 error occurs when connecting to MySQL8+ with navicat, which is due to the new version of MySQL using caching_sha2_password authentication method, which is not yet supported by navicat.

The solution is to change the authentication method to the authentication method used in previous versions (5.7 and below mysql_native_password. For specific verification methods, you can check the user table plugin field in the default database 'mysql'.

If you log in to the database in the command line, you will not get a 2059 error, log in to the database in the command line and run the following command.


'root' can be changed to your own defined username, 'localhost' refers to the IP open to the user, which can be 'localhost' (local access only, equivalent to 127.0.0.1), specific '*.*' (specific IP), or '%' (all IPs can access). 'password' is the verification password you want to use.








Previous:WeChat share link with small pictures
Next:There is a mini program that fails to compile and needs to be solved

Related Posts
Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.
Mail To:help@itsvse.com