安装完MySQL8.0,使用HeidiSQL连接MySQL8.0数据
连接失败,报错“Plugin caching_sha2_password could not be loaded”
解决步骤如下:
打开MySQL command line client
输入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';
按照如上步骤,即可!