remote connection to mySQL

[sfullman]

Hi there,

I would be really jazzed if I could establish a database connection between two different domains on different servers (I have a couple companies that host my sites which run mySQL).

This, of course, works for a connection on a local server:

$records_cnx = mysql_connect("hostname", "username", "password");

But if I try to make a connection to a remote server using this format:

$records_cnx = mysql_connect("www.digitalconcept.com:3306", "remotename","remotepassword");

I get this error message:

Warning: Access denied for user: '[e-mail]' (Using password: YES) in ..../team/php/remote.php

Well, shell6.bayarea.net is the LOCAL server, so apparently the connection is not being allowed to "escape."

Am I making a syntax error, or is there a setting I need to change on the computer?

Sam Fullman

'[e-mail]'

[Anon]

Is that a valid mySQL user on the remote machine, and does that user have permissions from that hostname?