navicat连接mysql时1251报错

2019-07-2516:25:10navicat连接mysql时1251报错已关闭评论 38

最近安装了一个mysql8.0数据库,使用navicat连接时提示

 

navicat连接mysql时1251报错

1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

 

出现1251错误是因为,MySQL8.0版本改变了密码的验证规则caching_sha2_password,MySQL之前的版本验证规则是mysql_native_password,现在需要修改MySQL8的验证规则。ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #修改加密规则 、