Connecting to MySQL db on different domain

[steve_green]

I'm trying to connect to a MySQL db on a different domain using:

mysql_connect('mysql5.servername.lon.periodicnetwo rk.com:3306', 'mysql_user', 'mysql_pass');

and I've created 'mysql_user' as a new user on the db in Helm, but MySQL is saying:

Can't connect to MySQL server on 'mysql5.servername.lon.periodicnetwork.com' (10049)

Could anybody shed light on what I'm doing wrong please?

[RFH Reseller: SKILLIT]

If you are trying to do an external connection from outside of the RedFox environment -

Should the command seperator not be a semicolon?
Should you not also include ;Database=xxxxxxxx ?

[steve_green]

I've just changed it to:

mysql_connect('servername', 'mysql_user', 'mysql_pass');

and it's worked okay.

I'm connecting from inside the RedFox environment, but as it was using a db on a different domain I mistakenly thought I had to use the external string to connect to the server.

Thanks anyway.

[Tanzy]

Can't connect to MySQL server on 'mysql5.servername.lon.periodicnetwork.com' (10049)

I have a funny feeling that you can't use the external connection from the internal network. The plus side of this is that you don't use up any of your bandwidth quota connecting to the database.