当前位置:Gxlcms > 数据库问题 > mysql8.0 Authentication plugin 'caching_sha2_password' cannot be loaded

mysql8.0 Authentication plugin 'caching_sha2_password' cannot be loaded

时间:2021-07-01 10:21:17 帮助过:11人阅读

#修改加密规则
alter user ‘root‘@‘localhost‘ identified by ‘你的密码‘ password expire never;

#更新用户密码
alter user ‘root‘@‘localhost‘ identified with mysql_native_password by ‘你的密码‘;

#刷新权限
flush privileges;

#重新重置密码
alter user ‘root‘@‘localhost‘ identified by ‘你的密码‘;

mysql8.0 Authentication plugin 'caching_sha2_password' cannot be loaded

标签:mysq   ide   load   password   mys   can   ann   The   cannot   

人气教程排行