1.连接数据库
select Host,User,plugin from mysql.user;
![](https://img-blog.csdnimg.cn/img_convert/b75bd2bc83206fc57b8913e1c8180672.png)
2,
![](https://img-blog.csdnimg.cn/img_convert/351ca1d46da52c2b6a80353010c5acf8.png)
将上述加密规则都要改成mysql_native_password
使用一下命令:
ALTER USER 'root'@'localhost' IDENTIFIED BY '你的mysql密码' PASSWORD EXPIRE NEVER; #修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的mysql密码'; #修改密码
ALTER USER 'root'@'%' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER; #更改加密方式
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456'; #更新用户密码
FLUSH PRIVILEGES; #刷新数据
完事!!!