SQLyog连接数据库报错解决办法
错误提示如下图所示
打开cmd:mysql -uroot -p
1:进入mysql依次执行下面语句 :
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 'hxzk';
重置密码,hxzk就是变更后的密码
48