本地网络上的MySQL错误10061 [英] Mysql error 10061 on local network

问题描述

我正在尝试将他的数据库(位于192.168.0.198)连接到本地服务器， 但出现10061错误.

I'm tryig to connect to a local server his databases (located at 192.168.0.198), but I'm getting the 10061 error.

当我尝试连接真正的腻子(然后只是正常的mysql登录名)时，它没有任何问题. 一个Mincraft插件使用以下命令登录数据库:mysql://localhost:3306/DB_NAME那里没有问题.

When I try connecting true putty (then just an normal mysql login) it gives me no problems. A mincraft plugin uses the following command to login to the database: mysql://localhost:3306/DB_NAME no problems there.

但是当我用mysql workbench和cmd尝试时.它拒绝工作.

But when I try it with mysql workbench, and cmd. It refuses to work.

有人知道如何解决此问题吗?

Anyone got any idea/solution how I could fix this?

猕猴桃

推荐答案

我遇到了与完全错误消息完全相同的问题.

i had the exact same problem with the exact error message.

在阅读@ruakh的评论后，我检查了my.cnf，我注意到mysql服务器已绑定到127.0.0.1 ip地址，这是一个只能在本地访问的环回.

after reading @ruakh's comment i checked my.cnf and I noticed that the mysql server is bind to 127.0.0.1 ip address which is a loopback that can be reached only locally.

当我将其更改为绑定到常规IP地址(而非循环)时，它解决了该问题.我可以正确连接.你应该试试看！ :)

when i changed it to bind to the regular ip address (not loop) it resolved the issue. i could connect properly. you should try that ! :)

祝你好运

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