当前位置：Gxlcms >
数据库问题 >
Navicat Premium 连接MySQL数据库出现Authentication plugin 'caching_sha2_password' cannot be loaded的解决方案
Navicat Premium 连接MySQL数据库出现Authentication plugin 'caching_sha2_password' cannot be loaded的解决方案
时间：2021-07-01 10:21:17
帮助过：3人阅读
root‘@
‘localhost‘ IDENTIFIED BY
‘password‘ PASSWORD EXPIRE NEVER;
ALTER USER ‘root‘@
‘localhost‘ IDENTIFIED WITH mysql_native_password BY
‘password‘;
4、运行如下指令刷新密码，并更新密码
FLUSH PRIVILEGES;
alter user ‘root‘@‘localhost‘ identified by ‘新密码‘;
5、再次连接就可以了
Navicat Premium 连接MySQL数据库出现Authentication plugin 'caching_sha2_password' cannot be loaded的解决方案
标签：连接mysql inf mic color 解决 use pass flush ever
