问题描述
所以我有一个在Namecheap服务器上托管的PHP文件。 $ db = mysql_connect(ipaddress,user,pass)或die('我无法连接到数据库因为:'。mysql_error());
,并且出现此错误:
我无法连接到数据库,因为:无法通过'ipaddress'连接到MySQL服务器(110)
我可以使用网络外的mysql工作台连接到此数据库正好。
我遇到过这个问题。我所做的是使用互联网地址,而不是您的公共IP / DNS。
因为我使用Linux,所以我做了 ifconfig
,您将看到 inet addr:xxx.xxx.xxx.xxx
,并将该IP用作主机而不是公用IP / DNS。在Windows上,只需使用本地IP地址即可。
就这样!
So I have a PHP file hosted on Namecheap server.
$db=mysql_connect ("ipaddress", "user", "pass") or die ('I cannot connect to the database because: ' . mysql_error());
and it gives this error:
I cannot connect to the database because: Can't connect to MySQL server on 'ipaddress' (110)
I CAN connect to this DB using mysql workbench outside of the network just fine.
I have experienced this issue. What I did was use the internet address instead of your public IP/DNS.
Since, I'm using Linux I do ifconfig
and you will see inet addr: xxx.xxx.xxx.xxx
and use that IP as your host instead of the public IP/DNS. On Windows, Simply use your local IP address.
That's it!
这篇关于无法通过'ipaddress'连接到MySQL服务器(110)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!