mysql_connect() trouble...

[Anon]

i have a db at www.freesql.org and i access it fine from my computer running php (localhost). however, when i post the same script to www.f2g.net, it wont access the db and gives me:
Warning: MySQL Connection Failed: Can\'t connect to MySQL server on \'www.freesql.org\' (78) in /host/c/h/e/f/2/g/cheaptravel.f2g.net/travel/flights/alphabetical.php on line 27

basically only the mysql_connect function fails. anybody knows why the command works ok when run on localhost but fails from another server (www.f2g.net) ?

[Anon]

i think
in mysql_connect ("ip of f2g.net","user","pass");

u might be keeping it as
mysql_connect("localhost","user","pass");

Please let me know
Regards
Mandar Kelkar

[[deleted]]

Maybe f2g.net don't allow outgoing MySQL connections (firewall).

[Anon]

no, i dont have it as localhost because both are connecting to the www.freesql.com site. the local page connects but the remote doesnt..

[Anon]

that would beat the purpose of being a php host, wouldnt it? although they dont provide db , why they wouldnt allow the scripts to access a remote db?

plus do u know how i could check what the problem is? thanks

[[deleted]]

They can have a ton or reasons for blocking connections.

Have you asked them if there is anything they do to block outgoing connections?

A simple way to check it is by doing what you are doing now: try to connect, and if it works it works.

You may want to give it a try with fsockopen, because that will just try to connect on a socket level. mysql_connect() can also fail because of bad username/password/host etc.

[Anon]

i send them an email and i m waiting a reply. i rather not use sockets if i dont have to so i ll wait for their answer. thanks