Remote MySQL Error 2003 (110) From Linux Box
I am 5 days into trying to solve an issue I am facing connecting to MySQL from one linux box to another. I have read instructions, forum posts...the works, but am still unable to resolve my dilema :(
When trying to make a connection to a MySQL database from linux server A to linux server B, i get the following error message:
Error 2003 (HY000): Can't connect to MySql Server on 'IP_ADDRESS' (110).
Firstly, I know for sure that the credentials being used for MySQL are sound. I can connect fine to the database from my home (Windows) PC. Therefore, remote connections are setup seemingly fine to MySQL on server B.
My next train of thought is that there must be a firewall issue on server A. I am not an expert with iptables, but have attempted to open up necessary ports for MySQL (3306) in and out but the issue remains. My feeling is it must be firewall related, but I still get the issue after switching the firewall OFF on server A.
I have also checked my.cnf file on server A and made sure there are no binding or other restrictions that would prevent the remote connection being made.
Does anybody have any ideas what this maybe or suggest ways I may be able to narrow down where the problem is?