https://www.baidu.com/Navicat连接 mysql8.0报1251错误解决方法

Navicat连接 mysql8.0报1251错误解决方法

1. 按win键，输入mysql进行搜索
   
2. 选择 mysql 8.0 command line client
   
3. 修改加密方式

 ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;

4. 输入新密码，该例子中新密码为123

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123';

5. 使用navicat重新连接