Navicat Connection mysql8:2059 Authentication plugin ' Caching_sha2_passord ' Can not is loaded

mysql8.0 installed on the computer today , with the navicat connection when the following error occurred:

This is because MySQL 8.0 defaults to using the Caching_sha2_password authentication mechanism- from the original Mysql_native_password to caching_sha2_ Password upgrading from 5.7 to version 8.0 does not change the authentication method for existing users, but new users will use the new Caching_sha2_password by default.

Here's how to fix it:

Log in with MySQL 8.0 Command line Client-unicode,

Then use the command:alter user ' root ' @ ' localhost ' identified with mysql_native_password by ' root '; password update;

Navicat connected again, successful.

Navicat Connection mysql8:2059 Authentication plugin ' Caching_sha2_passord ' Can not is loaded