The solution to the inability of mysql8.0.11 client to log in

This article shares the solution that the mysql8.0.11 client cannot log in for your reference. The details are as follows.

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

You can log in on 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 | $Agg005 $7\ M50\% K/Y3'I@j8.ifRKoGiqJD58kgBP8iZj0q9d8yaAr2zWYa4j4r3to0 | + -+ 1 row in set (0.00 sec)

The client cannot find the caching_sha2_password plug-in. You can create new users using 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: different versions of mysql installation tutorials mysql5.7 various versions of installation tutorials mysql5.6 installation tutorials

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.