This problem gives me a headache because navicat15.0.26 does not support the newly added encryption method of mysql8.0, caching_sha2_Password, so we need to modify the user’s encryption method. First log in to MySQL,
mysql -uroot -p
This is my configuration information
Mysql 8.0.27 Navicat 15.0.26 tomcat 9.0.54 jdk 1.8.0.65
View encryption method:
show variables like 'default_authentication_plugin';
Log in to the database using the command-line client tool provided with MySQL database, and enter use mysql
Query the original authentication plug-in of MySQL user from the database user table
select user,host,plugin,authentication_string from user;
Replace the authentication plug-in used by the user with MySQL used in the previous version_ native_ password
ALTER USER 'root'@'localhost'IDENTIFIED WITH mysql_native_password BY'root';
Just use Navicat to connect again.