Navicat连接Mysql8.0.11出现1251错误

#登录

mysql -uroot -ppassword 

#选择数据库
use mysql; 
# 远程连接请将'localhost'换成'%'

#更改加密方式
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; 

#更新用户密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; 

#刷新权限
FLUSH PRIVILEGES; 

 

posted @ 2021-10-26 14:00  宇宙小咖  阅读(41)  评论(0)    收藏  举报