0、客户端MySQL连接报如下错误:
1、通过mysql命令进入数据库
2、修改加密方式:
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘123456’ PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
3、更新密码:
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘654321’;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';
4、刷新:
FLUSH PRIVILEGES;
5、再次连接