用SQLyog连接数据库时,出现了问题,提示plugin caching_sha2_password could not be loaded
在cmd打开数据库(以下sql语句不分大小写也可以)
1、改变密码规则
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
2、 设置权限
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
3、 刷新权限
FLUSH PRIVILEGES;
4、修改密码、
alter user 'root'@'localhost' identified by '123fzw';