mysql8.0安装后，用navicat连接报错2059

阳光穿透心脏的1/2处 2022-11-15 06:27 192阅读 0赞

错误如图：

![在这里插入图片描述][2019092308502314.png]

解决：

1、首先安装之后会有mysql客户端，开始菜单即可进入（或者win+R, cmd进入也可）：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RpYW5zaHVoYW81MjE_size_16_color_FFFFFF_t_70][]

2、然后进入mysql数据库：use mysql

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RpYW5zaHVoYW81MjE_size_16_color_FFFFFF_t_70 1][]

3、查看加密方式：select user,plugin from user where user='root';

![20210331140044981.png][]

可以看到加密方式为caching\_sha2\_password。

4、修改加密方式：ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql\_native\_password BY 'root';  
Query OK, 0 rows affected (0.01 sec);

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RpYW5zaHVoYW81MjE_size_16_color_FFFFFF_t_70 2][]

5、最后执行以下命令使配置生效：flush privileges;

再次使用navicat连接即可成功。

[2019092308502314.png]: /images/20221022/f4924c6a286d41c7a4f72110f49672f2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RpYW5zaHVoYW81MjE_size_16_color_FFFFFF_t_70]: /images/20221022/7da9fb1433c449619f90a63c96566646.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RpYW5zaHVoYW81MjE_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/202103311358446.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RpYW5zaHVoYW81MjE=,size_16,color_FFFFFF,t_70
[20210331140044981.png]: https://img-blog.csdnimg.cn/20210331140044981.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RpYW5zaHVoYW81MjE_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20210331140157809.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RpYW5zaHVoYW81MjE=,size_16,color_FFFFFF,t_70