MySQL Workbench无法连接到数据库服务器 [英] MySQL Workbench Cannot Connect to Database Server

问题描述

我与有问题的发帖人完全相同的问题 7864276 ，不同之处在于我已经通过右键单击本地实例MySQL并选择了启动命令行客户端"，例如从MySQL Workbench中验证了服务器是否确实在运行.只有当我选择查询数据库"或双击本地实例MySQL"时，才会出现错误消息.错误消息中的另一条信息是:对于所请求的平台无效(MYSQL_PROTOCOL_SOCKET)".一切正常，直到我最近将MySQL Workbench更新到5.2.47 CE版本.

I have exactly the same problem as the poster in question 7864276 except that in my case I've verified that the server is actually running, e.g., from within MySQL Workbench by right-clicking on Local Instance MySQL and selecting Start Command Line Client. It's only when I select Query Database or double click on Local Instance MySQL that the error message results. One additional piece of information in the error message is that it says "invalid for this platform requested(MYSQL_PROTOCOL_SOCKET)". Everything worked fine until I recently updated MySQL Workbench to version 5.2.47 CE.

推荐答案

单击管理连接".选择本地实例MySQL".将连接方法"更改为本地套接字/管道".现在测试连接成功.

Click on Manage Connections. Select Local Instance MySQL. Change Connection Method to Local Socket/Pipe. Test connection succeeds now.

这篇关于MySQL Workbench无法连接到数据库服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！