无法连接到“ipaddress"上的 MySQL 服务器 (110)

2022-01-25 00:00:00 iis-7 php mysql html windows-server-2008

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!

相关文章