navicat连接mysql时报出2059错误。
1.在cmd中连接mysql
2.查询登陆账号的加密规则(8.0以上的mysql默认:caching_sha2_password)
输入语句:
use mysql;
select user,host,plugin from user where user=‘root’;
3.修改加密规则(注意需要修改的user,host)
输入语句:
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER; #更改加密方式
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’; #更新用户密码
FLUSH PRIVILEGES; #刷新权限
mysql-2059错误
最新推荐文章于 2023-11-17 16:46:30 发布