Connect to remote mysql server

[strunkwriter]

I am using PHP version 4.3.7 paired with MySQL 4.0.18 on a Unix/Apache database.

I will be trying to connect to the database from another server. I think I'm having trouble with the mysql_connect syntax, but I'm not totally sure.

I have already configured the mysql database to accept remote access from the other server. (hopefully). But, just to make sure I do everything right, I tested this script on my own server, using the server name instead of "localhost." I figured the remote db language should THEORETICALLY work (even if I leave it on the same server) if I have the syntax right. (I hope this is clear.)

So, let's say I'm using the script:

$link = mysql_connect("localhost", "username", "password")
   or die("Could not connect : " . mysql_error());
mysql_select_db("database") or die("Could not select database");

How would I replace "localhost"? My host company said I would want to use strunkwriter.com as the db host address, but simply replacing "localhost" with "strunkwiter.com" doesn't work. I tried "mysql.strunkwriter.com" and "mysql.www.strunkwriter.com" and "http://www.strunkwriter.com".

I am out of ideas and any suggestion would be welcome. Thanks in advance.

[drew010]

you might try connecting to the ip address instead of the hostname.

you may also need to add a unique username based on the host you are accessing it from.

ie if you are connecting to strunkwriter.com from a host called something.someserver.com, and you are connecting as myusername, it will try to authenticate you as [e-mail]

i.e. from the command line
mysql -h 192.168.0.1 -u myuser -pPassword
it may give you a warning like this:

Access denied for user [e-mail] using password (YES)