MySQL错误10061 [英] MySQL error 10061

问题描述

我在通过远程连接到MySQL时遇到了一个奇怪的问题.这是一个内部局域网，因此应该没有防火墙问题.我已经安装了MySQL 5.0，并尝试了: mySQL-front 和 DBTools-manager .总是错误'10061'，是的，我的'mysql'数据库表权限

I'm having a strange problem connecting via remote to MySQL. This is an internal LAN, so there should be no firewall issues. I've installed MySQL 5.0 and I've tried: mySQL-front and DBTools-manager. It's always error '10061', and yes, my 'mysql' database table permissions

我试图重新启动MySQL服务，但没有成功.我将其卸载并从 c:/Program Files 中删除了MySQL文件夹，然后再次安装了mysql，但出现相同的错误.

I tried to restart the MySQL services, but it didn't work. I uninstalled it and removed the MySQL folder from c:/Program Files and installed mysql again but I get the same error.

推荐答案

错误 10061 是拒绝连接.这意味着您正在访问服务器，但是服务器说它不接受该端口上的连接.

Error 10061 is Connection Refused. This means that you are reaching the server, but the server says that it is not accepting connections on that port.

以下一些重要信息可以帮助您解决问题.

Here's some important information which may help you resolve the issue.

如果在客户端使用回送 localhost 或 127.0.0.1 ，则必须在服务器端使用回送 localhost 或 127.0.0.1 .如果服务器已明确绑定到诸如192.168.0.1的真实IP地址，则它将不会在127.0.0.1或本地主机上侦听.

If you are using the loopback localhost or 127.0.0.1 on the client side, then you must be using the same on the server side. If the server is explicitly bound to a real IP address like 192.168.0.1, then it will not be listening on 127.0.0.1 or localhost.

您必须显式绑定到 127.0.0.1 ，或者必须绑定到 all .

You must explicitly bind to 127.0.0.1, or you must bind to all.

因此，如果本地主机或127.0.0.1在客户端上不起作用，请尝试使用IP地址.

So, if localhost or 127.0.0.1 isn't working on the client side, then try with the IP address.

此外，除非您关闭了ICMP服务，否则无论MySQL是否在此运行，您都很有可能会成功ping通回送IP地址.您正在对自己的计算机执行ping操作.

Also, unless you have the ICMP service shut off, you will most likely succeed in pinging the loopback IP address, regardless of whether MySQL is running there. You're pinging your own machine.

这篇关于MySQL错误10061的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！