为什么我无法使用MySQL Workbench连接到我的MySQL数据库？

Question

我无法使用MySQL Workbench连接到我的MySQL数据库。我正在使用MySQL Community Server 8.0.11和MySQL Workbench 6.3 CE。我也在使用Windows 10 Home。

当我点击MySQL Workbench中的默认MySQL连接时，它显示遇到错误。没有提供更多信息。 我能够使用命令mysql -u root -p -h 127.0.0.1 -P 3306轻松连接到MySQL服务器。

以下是我的服务器状态。

mysql  Ver 8.0.11 for Win64 on x86_64 (MySQL Community Server - GPL)

Connection id:          12
Current database:
Current user:           root@localhost
SSL:                    Cipher in use is DHE-RSA-AES128-GCM-SHA256
Using delimiter:        ;
Server version:         8.0.11 MySQL Community Server - GPL
Protocol version:       10
Connection:             127.0.0.1 via TCP/IP
Server characterset:    utf8mb4
Db     characterset:    utf8mb4
Client characterset:    cp850
Conn.  characterset:    cp850
TCP port:               3306
Uptime:                 15 min 55 sec

Threads: 2  Questions: 6  Slow queries: 0  Opens: 110  Flush tables: 2  Open tables: 86  Queries per second avg: 0.006

- user2712674

---

这个回答解决了你的问题吗？无法加载身份验证插件“caching_sha2_password” - outis

Answer 1

我使用命令-log-level=debug3执行了MySQL Workbench：MySQLWorkbench.exe -log-level=debug3。

阅读程序生成的日志后，我发现了如下信息：

21:10:22 [ERR][SQL Editor Form]: SqlEditorForm: exception in do_connect method: Exception: Authentication plugin 'caching_sha2_password' cannot be loaded: Não foi possível encontrar o módulo especificado.

21:10:22 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Authentication plugin 'caching_sha2_password' cannot be loaded: Não foi possível encontrar o módulo especificado.

21:10:22 [ERR][  GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Authentication plugin 'caching_sha2_password' cannot be loaded: Não foi possível encontrar o módulo especificado.

21:10:22 [ERR][SQL Editor Form]: SQL editor could not be connected: Authentication plugin 'caching_sha2_password' cannot be loaded: Não foi possível encontrar o módulo especificado.

21:10:22 [ERR][SQL Editor Form]: Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306:
Authentication plugin 'caching_sha2_password' cannot be loaded: Não foi possível encontrar o módulo especificado.

这个问题Authentication plugin 'caching_sha2_password' cannot be loaded帮助我解决了问题。现在我可以连接到我的MySQL服务器。

- user2712674

Answer 2

看起来是您的机器上MySQL Workbench没有正确启动。我在官方网站上找到了这个链接，尝试看看是否有效，如果无效，请尝试向开发团队报告错误并等待回复。或者，您可以尝试使用其他工具连接数据库。

- DobromirM

---

谢谢。您给我的链接让我发现缓存_sha2_password是问题的原因。 - user2712674