Skip to main content
edited tags
Link
Charles
  • 51.5k
  • 13
  • 107
  • 146
Source Link
Toadums
  • 2.8k
  • 8
  • 48
  • 67

Cannot connect to mysql database on remote host

I am not sure if the terms I am using are correct so ask for clarification if you need :).

Anyways, I am hosting through HostEasySolutions (Server A). It comes with a MySql database, using PHPMyAdmin as the frontend. On Server A, I added some PHP files to access the database, and it works fine.

If I copy the php files to my other server, through DreamHost (Server B), I cannot connect to the database. I get the error: Can't connect to MySQL server on 'combinedsystems.ca' (110)

In the cPanel on Server A, I added the IP for Server B into the Remote Database Access Hosts, I also just added the wildcard '%', just to see if I could get it working...but still it can't find the server.

I am not sure what is going on, as far as I can see there is no firewall.

The only thing that stands out to me, is that if I go to PHPmyAdmin for Server A, it says Server: Localhost via UNIX socket, where as for Server B's PHPMyAdmin, it says: Server: mysql.pdem.info via TCP/IP