Navicat连接Mysql8.0.11出现1251错误

 

 

 

# 登录mysql
mysql -u root -p
# 修改加密规则
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '新密码';
#更新一下用户的密码 
mysql> ALTER USER 'root'@'%' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; 
#刷新权限 
FLUSH PRIVILEGES; 

 

posted @ 2019-11-06 11:18  秋寻草  阅读(157)  评论(0编辑  收藏  举报