How can I connect to a remote MySQL database from my hosting account

Avatar
  • Answered
I'm trying to connect to a external MySQL server. I've checked that I can connect from another host, I've set firewall rules to accept connections from that host and also from the ip address of my hosting account. However, when I try to make the connection I get a "connection timed out" error, it doesn't even try to send the username and password for the connection. What can be wrong? Do I need to move some firewall rule in the hosting side?

I've already tried the link "Remote MySQL" in my cPanel interface, and I've added the FQDN of my server, a domain pointed to it and also the IP address, with no luck.

Please help me. Thanks in advance, and best regards.
Avatar
Scott
Hello,

Thank you for your question on connecting to a remote MySQL database. Without seeing the specific settings, I am unable to test, however you can test the connection yourself by using a tool such as Heidi SQL. This program is a remote connection tool. If you try this, you should make sure that the IP you are connecting from is allowed to connect via the firewall. If that fails, then it could be a setting or the receiving server. If it works, then you will want to take a look deeper into the code of the connection.

Kindest Regards,
Scott M