mysql remote server connection - other threads dont help

[davestacey]

Hi,

I am trying to connect to my own server (mysql), from another server i just bought.

I searched the net to no avail, and this thread doesnt work for me (http://forums.cpanel.net/showthread.php?t=78345)

I have added the new servers ip to my old servers firewall, and it still wont connect, i get this error.

Can't connect to MySQL server on '*.*.*.*' (4)

This is the php code i am using....

// Database configuration details:
$dbHost = "*.*.*.*:3306";
$dbUser = "user";
$dbPass = "password";
$dbName = "database";

// Connect to MySQL:
if (!$dbase = @mysql_connect($dbHost, $dbUser, $dbPass))
{
die(mysql_error());
}

Any simple instructions on how to do this please?

Thanks!

[davestacey]

I have also followed instructions on this page (http://www.cpanel.net/support/docs/1..._acchosts.html)

and it still wont connect? same error msg

[cpanelkenneth]

1. Is MySQL on your SQL server configured to listen on TCP port 3306?

2. Is your MySQL server accessible from your new server (e.g. you can ping the MySQL server from your new cPanel server)?

3. Is the access GRANT for the MySQL user correct (e.g. the Host field either has % or the IP address/hostname connecting from)?

[davestacey]

1. Is MySQL on your SQL server configured to listen on TCP port 3306?

2. Is your MySQL server accessible from your new server (e.g. you can ping the MySQL server from your new cPanel server)?

3. Is the access GRANT for the MySQL user correct (e.g. the Host field either has % or the IP address/hostname connecting from)?

Hi Kenneth,

Thanks for taking the time to answer my thread.

1. yes, port 3306 is open in the csf firewall
2. the new server is a shared non cpanel server, so i got the server admin to ping on my behalf and it pinged ok.
3. yes this is setup


Are there any other tests i can do from the new server to see if it can connect to the sql server?

[davestacey]

Still the same issue.

[me@linux]

Try this from new server, and see if you are able to connect.

telnet oldserver.com 3306

(Replace oldserver.com with your old servername/IP)

[anton_latvia]

There are many things that can happen - firewall on your local server, firewall on the new serve blocking outgoing connections (do you have ConfigServer Firewall installed or may be default iptables rules are enabled?). Then your mySQL server might deny network connections, please give us content of /etc/my.cnf. Then - did you try to connect through shell? (mysql -h REMOTE_ADDR -u USERNAME -p). If this does not work - what exact error do you get?

Anton.