MySQL Workbench:“无法连接到127.0.0.1'(10061)上的MySQL服务器"错误 [英] MySQL Workbench: "Can't connect to MySQL server on 127.0.0.1' (10061)" error

问题描述

对不起..我知道这个问题以前已经问过很多次了，但是我尝试了很多建议，却找不到解决方法.

问题:我在托管服务器上运行一个MySQL数据库. 我必须使用SSH进行连接，并且具有相关的公钥和私钥文件.

我特别想使用PC版本的 MySQL Workbench 来访问该数据库，运行查询，检查数据等.

如果我在Mac上运行 Sequel Pro ，它可以正常运行，并且我可以浏览和查询数据库.没问题.

如果我在PC上运行 SQLyog 的试用版，它也可以正常运行.没问题.

但是，如果我尝试使用完全相同的设置和SSH私钥文件使用MySQL自己的" MySQL Workbench "应用程序进行连接，它将拒绝连接，并抛出众所周知的错误:

无法连接到127.0.0.1'(10061)上的MySQL服务器

我发现它令人沮丧，因为在SQL Workbench中，我指定了要使用的"MySQL Hostname"，即 db01.mysql.vm.MyHostingServer.net ，但是Workbench似乎忽略了它，并要求改为连接到127.0.0.1.

((我读到Workbench表示它需要公钥文件，但实际上意味着私钥文件...而且我已经尝试了两者.我还尝试了在 MySQL Workbench 一台Mac，但是整个地方都崩溃了，只是当我输入服务器名称和密码时..真是一团糟!!)

我使用的托管服务为我提供了更改MySQL设置的有限权限，并且鉴于Sequel Pro和SQLyog 可以成功连接，所以我不想开始搞乱和更改事情

有什么想法吗??

解决方案

也许不允许您启动"MySQL 55"服务.将服务"MySQL 55"的登录信息设置为本地！

要查看Windows 7中的可用服务列表，请执行以下操作:

1. 打开运行框
2. 键入services.msc并按回车键.
3. 找到服务MySQL55
4. 右键单击MySQL55本地服务将显示属性->登录

I apologise.. I know this question has been asked many times before, but I've tried lots of suggestions, and simply can't find a solution.

The problem: I have a MySQL database running on a hosted server. I have to use SSH to connect to it, and I have the relevant Public and Private Key files.

I specifically want to use the PC version of MySQL Workbench, to access this database, for running queries, checking data, etc.

If I run Sequel Pro on a Mac, it connects fine, and I can browse and query the database. No problems.

If I run the trial version of SQLyog on a PC, it also connects fine. No problems.

But if I try to connect use MySQL's own "MySQL Workbench" application, using exactly the same settings and SSH Private Key file, it refuses to connect, throwing the well-known error:

Can't connect to MySQL server on 127.0.0.1' (10061)

I find it frustrating, as, in SQL Workbench, I specified the "MySQL Hostname" to use, db01.mysql.vm.MyHostingServer.net, but Workbench seems to ignore it, and demand to connect to 127.0.0.1 instead.

(I have read that Workbench says it needs the Public key file, but actually means the Private key file... and I have tried with both. I've also tried with MySQL Workbench on a Mac, but that crashed all over the place, simply when I was typing in server names and passwords.. it was a mess !!)

The hosting service I've gone with gives me limited permissions for changing MySQL settings, and given that Sequel Pro and SQLyog can connect successfully, I don't want to start messing about and changing things randomly.

Any ideas...?

解决方案

Maybe you are not allowed to start the service "MySQL 55". Set the login information of Service "MySQL 55" as local!

To see the list of aviable services in Windows 7:

1. Open a run box
2. Type services.msc and press return.
3. Find the service MySQL55
4. A right click of the MySQL55 Local Service shows Properties -> Log On

这篇关于MySQL Workbench:“无法连接到127.0.0.1'(10061)上的MySQL服务器"错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！