sqlyog无法连接mysql8.0的处理办法报2508
第一步:windows+r
第二步:输入
mysql -u root -p回车
再输入密码
输入如下命令行语句
#修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
#修改密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
#刷新权限
FLUSH PRIVILEGES;