MySQL Workbench 无法连接到数据库服务器
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/16129399/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
MySQL Workbench Cannot Connect to Database Server
提问by gillenpj
I have exactly the same problem as the poster in question 7864276except 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.
我有与问题7864276 中的海报完全相同的问题,除了在我的情况下,我已经验证了服务器实际上正在运行,例如,通过右键单击本地实例 MySQL 并选择启动命令行客户端从 MySQL Workbench 中。只有当我选择查询数据库或双击本地实例 MySQL 时才会出现错误消息。错误消息中的另一条信息是“对此平台请求无效(MYSQL_PROTOCOL_SOCKET)”。一切正常,直到我最近将 MySQL Workbench 更新到 5.2.47 CE 版。
回答by gillenpj
Click on Manage Connections. Select Local Instance MySQL. Change Connection Method to Local Socket/Pipe. Test connection succeeds now.
单击管理连接。选择本地实例 MySQL。将连接方法更改为本地套接字/管道。现在测试连接成功。