You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SQLyog连接数据库报错plugin caching_sha2_password could not be loaded
打开cmd:mysql -uroot -p
进入mysql依次执行下面语句
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; #更新一下用户的密码
FLUSH PRIVILEGES; #刷新权限
重置密码:alter user 'root'@'localhost' identified by 'xzx123456';
The text was updated successfully, but these errors were encountered:
idea跑项目的时候出现
解决方式:
SQLyog连接数据库报错plugin caching_sha2_password could not be loaded
The text was updated successfully, but these errors were encountered: