Cannot connect to remote MySQL server

Help please

[AprilS]

Ok, I have done this MANY times before without a problem - so I don't know WHY this isn't working!

I am in the process of moving to a new server - so I am updating my mysql_connect statement to use our NEW server instead of the current one (@ localhost).

I went into MySQL on the NEW server an added two new users - same username - one for the domain name of our current/old server and one for the IP address of our current/old server ... and gave the users the appropriate rights. I then updated my "mysql_connect" statement to point to the NEW server... but I get the following error:

Can't connect to MySQL server on '111.111.111.111' (61)

That is the ONLY error I get.

Both servers (new & old) are with the same hosting company. Our new server is using RedHat Enterprise ES.

Like I previously stated - I have done this many times in the past without any problem - but always on FreeBSD servers. I'm not sure if there is something particular I am missing while trying to connect to MySQL on the RedHat server.

[coopster]

Have you tried the troubleshooting steps on this page?

[dev.mysql.com...]

[AprilS]

Out of all the issues they list - mine is that I can only connect to MySQL via "localhost" (directly from the NEW server). If I try using the hostname or IP address - I get no response from MySQL. According to their notes it means MySQL may not be running on a port (3306) - so then it says to check your MySQL variables to make sure it is running on a port. I did just that and the MySQL variables say MySQL is running on port 3306.

So, I know my exact problem now - but the MySQL help page does not list any ways to troublshoot/fix this problem.

Any clues?

[AprilS]

I apologize that this has turned out to be just a MySQL issue and not due to PHP at all. I will open a thread in webmaster general.