MYSQL-0-修改MySQL--1251错误

数据库MySQL–Navicat 1251错误

1. 原因：因为版本加密规则不一样，产生错误

2. 解决方案【 大小写不敏感，为了可读性，这里都写了 】：

   用户名为 root，允许localhost访问，密码 000000

   (1) 修改密码并指定加密规则为 mysql_native_password

    ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '000000'; 
   
    alter user 'root'@'localhost' identified with mysql_native_password by '000000';
   

   （2）修改密码为不过期

    ALTER USER 'root'@'localhost' IDENTIFIED BY '000000' PASSWORD EXPIRE NEVER;  
   
    alter user 'root'@'localhost' identified by '000000' password expire never;
   

   （3）刷新权限

    FLUSH PRIVILEGES;
   
    flush privileges;
   

   (4) 重启MYSQL服务

    右键计算机->管理->服务->重启
   

注意：当新建数据库用户时，需要修改密码规则

比如：创建一个 exroot 用户对所有人可用–更改密码规则

ALTER USER 'exroot'@'%' IDENTIFIED WITH mysql_native_password BY '000000';

ALTER USER 'exroot'@'%' IDENTIFIED BY '000000' PASSWORD EXPIRE NEVER;

FLUSH PRIVILEGES;