An exception occurs when NavicatPremium connects to MySQL Authentication plugin ‘caching sha2 password’ cannot be loaded solution

Hits: 0

1. Abnormal causes

Since the mysql installed on the personal computer is 8.0, the Authentication plugin ‘caching_sha2_password’ cannot be loaded exception occurs when using [Navicat to connect to the database.]

By collecting information, we know that mysql 8.0 has changed the authentication mechanism (caching_sha2_password) by default , from mysql_native_password to caching_sha2_password before version 5.7. The Navicat client does not support the new [encryption] by default , from mysql_native_password to caching_sha2_password before version 5.7. The Navicat client does not support the new [encryption] method, so this exception occurs.

Second, the abnormal solution

2. Modify account password encryption rules and update user password

1), modify the encryption rules

ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;

Results of the

2), update user password

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

Results of the 

3. Refresh permissions and update password

1), refresh permissions

FLUSH PRIVILEGES;

2), reset the password

alter user 'root'@'localhost' identified by 'root';

Results of the

There is no problem connecting to the database using Navicat again.

Leave a Reply

Your email address will not be published.