After installing Navicat in MySQL, 2059 appears, Authentication plugin and local link virtual machine docker, remote link server

Preface

After installing MySQL and Navicat, when connecting, it reports ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: ÕÒ²»µ½Ö¸¶¨µÄÄ£¿ é¡ £. I initially thought it was because I didn't set a password. The password was set in the command line mode. It is worth mentioning that after logging in as root, the password should be set password = 'your password' instead of password = password or something like that. When you see that the error is syntax, you should consider whether there is a problem with this code.

Here is a special reminder: localhost in any remote (virtual machine, tencent ali server or similar) command should be replaced with '%'

text

1.2059 Authentication plugin

When I reconnected, the problem persisted. This sentence means troubleshooting the authentication plug-in:

SELECT `user`, `host`, `authentication_string`, `plugin` FROM mysql.user;

Conduct investigation

Change the root account password verification plug-in type to mysql_native_password. This is a problem after mysql8:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #Modify the encryption rule. password is your own password, and root is also the login account, the same below.

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; #Update the user's password FLUSH PRIVILEGES; #Refresh permissions

SELECT `user`, `host`, `authentication_string`, `plugin` FROM mysql.user; 

This problem is solved.

------------------------------------Dividing line----------------------------------------------------------------------
Here is an update on the solution I used when using local win10 to link to the virtual machine docker reported the same problem. Execute mysql in docker.

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'password'; 
#Update the user's password

All remote localhosts must be replaced with %.

2019/9/11
Today, I also reported an error when remotely connecting to Tencent server MySQL. First, it was error 1130. For how to solve 1130, please see my other article. Then it was error 2059. The solution is the same as above. Go to the mysql in Tencent server and execute

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
 #Update the user's password

Problem solved.

This is the end of this article about MySQL installation Navicat, 2059 appears, Authentication plugin and local connection virtual machine docker, remote connection server. For more related MySQL installation Navicat report 2059 content, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future!