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

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.

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.