mysql8.0 Authentication plugin ' Caching_sha2_password ' cannot be loaded

After installing mysql8.0, use Navicat to create the connection and then report the warning as shown in title. Refer to the following solutions:

https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded

8.0 changed the authentication plugin to use the old version of the authentication plug-in way.

My operation steps:

1. In the C:\ProgramData\MySQL\MySQL Server 8.0\my.ini file, change Caching_sha2_password to Mysql_native_password

#default_authentication_plugin =caching_sha2_passworddefault_authentication_plugin=mysql_native_password

2. Change the MySQL password, restart the MySQL service is OK.

CD "C:\Program files\mysql\mysql server 8.0\bin" C:\Program files\mysql\mysql Server 8.0\bin> mysql-u root-penter Pass Word: *********mysql> ALTER USER ' root ' @ ' localhost ' identified with Mysql_native_password by ' Newrootpassword '; Query OK, 0 rows affected (0.10 sec) mysql> exit

======================================== I'm a split line ==========================================

Thank:

1.https://www.cnblogs.com/zzqc/p/9192217.html

2.80156362

mysql8.0 Authentication plugin ' Caching_sha2_password ' cannot be loaded