MySQL Workbench 5.2 CE，Windows 7，“无法连接到127.0.0.1(10061)上的MySQL Server". [英] MySQL Workbench 5.2 CE, Windows 7, "Can't connect to MySQL Server on 127.0.0.1 (10061)"

问题描述

我已经多次看到这个问题，但是发布的每个解决方案都对我没有帮助.

I've seen this problem asked a bunch of times on here but every solution posted hasn't been helpful for me.

我刚安装了x86，并在计算机上安装了MySQL Workbench 5.2 CE.

I just got the x86 install and installed MySQL Workbench 5.2 CE on my Computer.

此后，我尝试使用localhost作为主机名创建新服务器实例或新连接，然后尝试使用端口3306(并且不尝试使用任何端口)，并且不输入root或默认架构的密码.

After that I tried to create a New Server Instance or New Connection using localhost as the hostname, I've tried Port 3306 (and trying no port) and not putting a password for root or Default Schema.

两次都收到错误消息无法连接到'127.0.0.1'(10061)上的MySQL服务器".

I get the error message "Can't connect to MySQL server on '127.0.0.1' (10061)" both times.

我读到一个可能的问题是MySQL服务器未运行，所以我尝试在MySQL Workbench 5.2 CE文件夹中查找mysqld，但该文件夹不存在(也没有bin文件夹).

I read a possible problem is that the MySQL Server isn't running so I tried looking for mysqld in my MySQL Workbench 5.2 CE folder but it isn't there (there isn't a bin folder either).

令人沮丧的是，我要做的只是创建一个小型应用程序，该应用程序连接到学校项目的MySQL Workbench(尽管我稍后可能会使用MySQL).

It's frustrating since all I want to do is create a small application that connects to MySQL Workbench for a school project (though I may use MySQL later on).

任何帮助将不胜感激.谢谢.

Any help would be very much appreciated. Thanks.

推荐答案

我遇到了同样的问题，并如下解决了该问题.

I had the same problem and solved it as follows.

1. 在Windows搜索栏中搜索服务".
2. 单击服务"，这应该是唯一的匹配项.
3. 向下滚动到"MySQL56".
4. 右键单击该项目，然后单击开始"或重新启动".

就是这样！像馅饼一样简单.

That's it! Easy as pie.

这篇关于MySQL Workbench 5.2 CE，Windows 7，“无法连接到127.0.0.1(10061)上的MySQL Server".的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！