无法连接到“ipaddress"上的 MySQL 服务器 (110) [英] Can't connect to MySQL server on 'ipaddress' (110)

问题描述

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)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！