I am trying to establish a remote MySQL connection from one VPS to another.
I have tried and done everything, I have allowed the outgoing TCP port (3306) in csf.conf, I have used Iptable rules online and of course have allowed remote MySQL from the host I am trying to establish to.
Here are some fsockopen's I have done for checking if the port is retrievable:
fsockopen("REMOTE_SERVER", 3306, $err, $err, 3); Return: fsockopen(): unable to connect to REMOTE_SERVER:3306 (Connection timed out)
I have confirmed that my remote host is not blocked by doing the following:
fsockopen("REMOTE_SERVER", 80, $err, $err, 3); //connects to port 80 fine
I have also allowed remote connections from my home network and am able to successfully connect to my remote MySQL server.
I have spent the last three or so hours trying everything to understand where the blockage lays.
Anyone else here ever come across an odd issue like this?