SQLyog错误号码 plugin caching_sha2_password could not be loaded

原因

MySQL新版默认使用caching_sha2_password作为身份验证插件，而旧版是使用mysql_native_password
当连接MySQL时报错“plugin caching_sha2_password could not be loaded”时，可换回旧版插件。

命令

mysql -hlocalhost -uroot -proot -P3306;

use mysql

select Host,User,plugin from mysql.user;

alter user root@localhost identified with mysql_native_password by 'root'

FLUSH PRIVILEGES;

alter user root@'%' identified with mysql_native_password by 'root'

FLUSH PRIVILEGES;