MySQL新版默认使用caching_sha2_password作为身份验证插件,而旧版是使用mysql_native_password。
当连接MySQL时报错“plugin caching_sha2_password could not be loaded”时,可换回旧版插件。
可按如下步骤操作:
mysql -h localhost -u root -p123456//进入数据库,用户名root,密码123456
use mysql;
修改本地连接身份验证插件:
ALTER USER root@localhost IDENTIFIED WITH mysql_native_password BY '123456'; //123456是密码
FLUSH PRIVILEGES
修改远程连接身份验证插件:
ALTER USER root@‘%‘ IDENTIFIED WITH mysql_native_password BY '123456'; //123456是密码
FLUSH PRIVILEGES