Solution to the problem that the mysql8.0.11 client cannot log in

This article shares with you the solution to the problem that the mysql8.0.11 client cannot log in, for your reference, the specific content is as follows

The default encryption method of MySQL 8.0.11 is [caching_sha2_password], which is not supported by Navicat for MySQL and Navicat Premium 12 clients.

You can log in to the database server using:

mysql>use mysql; 
mysql> select user, host, plugin, authentication_string from user where user='test';
+------+------+-----------------------+------------------------------------------------------------------------+
| user | host | plugin | authentication_string |
+------+------+-----------------------+------------------------------------------------------------------------+
| test | % | caching_sha2_password | $A$005$7\m5O\%K/Y3'[email protected] |
+------+------+-----------------------+------------------------------------------------------------------------+
1 row in set (0.00 sec)

The client cannot find the caching_sha2_password plugin. You can create a new user to use native encryption or modify

ALTER USER 'test'@'%' IDENTIFIED WITH mysql_native_password BY '123456a?';

Just change your login password at this time.

Wonderful topic sharing: Installation tutorials for different versions of MySQL Installation tutorials for MySQL 5.7 versions Installation tutorials for MySQL 5.6 versions

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.