Navicat连接Mysql出现1251错误:
解决方法:
1. 先用root账号登陆,
命令:
mysql -u root -p
刚安装时root密码为空,敲回车键;
2. 更改密码加密规则(注意:abc123表示root账号新密码,请修改为自己使用的密码)FLUSH PRIVILEGES
ALTER USER 'root'@'localhost' IDENTIFIED BY 'abc123' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'abc123';
FLUSH PRIVILEGES;
FLUSH PRIVILEGES是刷新权限;