打开cmd:mysql -u root -p
输入密码root
进入mysql依次执行下面语句
ALTER USER‘root‘@‘localhost‘ IDENTIFIED BY ‘root‘ PASSWORD EXPIRE NEVER; #
修改加密规则
ALTER USER‘root‘@‘localhost‘ IDENTIFIED WITH mysql_native_password BY ‘root‘; #
更新一下用户的密码
FLUSH PRIVILEGES; #
刷新权限
重置密码:alter user‘root‘@‘localhost‘ identified by ‘root‘;
SQLyog连接报错 Error No.2058 Plugin caching_sha2_password could not be loaded
原文:https://www.cnblogs.com/M87-A/p/12391541.html
如果您也喜欢它,动动您的小指点个赞吧