php - Can't connect to MySQL server on 'ipaddress' (110)

Question

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.

Answer 1

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!