MYSQL 2059 Navicate无法连接

淩亂°似流年 2023-02-16 10:59 89阅读 0赞

安装 了`mysql8`后出现2059错误。

原因为安装时选择了强加密规则caching\_sha2\_password，与之前的mysql5.7的mysql\_native\_password规则不同，navicate驱动目前不支持新加密规则。

我们需要更改加密规则  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDY4NTg2OQ_size_16_color_FFFFFF_t_70]

就像图中一样

1.  进入MySQL
    
        mysql -u root -p
2.  查看加密规则
    
        use mysql;
        
        select user,plugin from user where user='root';
        +------+-----------------------+
        | user | plugin                |
        +------+-----------------------+
        | root | caching_sha2_password |
        +------+-----------------------+
        1 row in set (0.00 sec)
3.  修改加密规则
    
        ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
4.  刷新权限
    
        flush privileges;
5.  查看规则
    
        select user,plugin from user where user='root';
        +------+-----------------------+
        | user | plugin                |
        +------+-----------------------+
        | root | mysql_native_password |
        +------+-----------------------+
        1 row in set (0.00 sec)
6.  然后测试连接

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDY4NTg2OQ_size_16_color_FFFFFF_t_70 1]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDY4NTg2OQ_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200609165110342.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDY4NTg2OQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDY4NTg2OQ_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200609165821276.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDY4NTg2OQ==,size_16,color_FFFFFF,t_70