SQLyog连接MySQL 8报错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 '123456';


如果出现报错：Your password does not satisfy the current policy requirements
则执行：
mysql> set global validate_password.policy=0;