navicat 连接docker mysql 2059 - Authentication plugin 'caching_sha2_password' cannot be loaded: ....

你的名字 2022-04-04 10:42 258阅读 0赞

> **docker创建mysql 容器**
> 
> docker run -di --name=pinyougou\_mysql -p 33060:3306 -e MYSQL\_ROOT\_PASSWORD=123456 mysql

使用Navicat连接显示如下的错误：

# ![20180612021422331][] #

原因是docker mysql为最新的，更换了新的身份验证插件（caching\_sha2\_password）, 原来的身份验证插件为（mysql\_native\_password）

--------------------

首先登陆docker mysql

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1Mjc1MjMz_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1Mjc1MjMz_size_16_color_FFFFFF_t_70 1][]

[20180612021422331]: /images/20220404/6050b9d01c7f4046aa320852c74394bf.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1Mjc1MjMz_size_16_color_FFFFFF_t_70]: /images/20220404/199235e928df41a6a05e6afefcbc0b47.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1Mjc1MjMz_size_16_color_FFFFFF_t_70 1]: /images/20220404/a20d1dc6b6c246528afe880595d58938.png

navicat 连接docker mysql 2059 - Authentication plugin 'caching_sha2_password' cannot be loaded: ....

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Navicat连接Mysql出现authentication plugin ‘caching_sha2_password‘ cannot be loaded

相关 MySQL 2059 - Authentication plugin ‘caching_sha2_password‘ cannot be loaded:问题解决

相关连接远程mysql8 2059 - Authentication plugin ‘caching_sha2_password‘ cannot be loaded: .... 解决办法

相关 Navicat 连接 MySQL 报错：Authentication plugin ‘caching_sha2_password‘ cannot be loaded

相关 Navicat连接linux上的mysql报2059 Authentication plugin ‘caching_sha2_password‘cannot be loaded

相关 navicat 连接docker mysql 2059 - Authentication plugin 'caching_sha2_password' cannot be loaded: ....

相关 2059 - Authentication plugin 'caching_sha2_password' cannot be loaded

相关 2059 - Authentication plugin ‘caching_sha2_password‘ cannot be loaded: dlopen(../Frameworks/caching_

相关 2059 - Authentication plugin ‘caching sha2 password‘ cannot be loaded:

相关 Linux中Navicat Premium连接MySQL报错：2059 - authentication plugin caching_sha2_password cannot be loaded