Reading MySql from Remote server

[Anon]

Hi,

I need to connect to a MySql database on a remote server.
So, I used the command $db = mysql_connect($host,$user,$pswd);

Where I assigned appropriate values.
i.e. $host = "208.56.207.211" ;
$user = "The UserName" ;
$pswd = "The Pswd" ;

The user-pwd combi IS correct and it works when the script is run from the same server with $host="localhost";
But when I put the IP add. to connect from another server I get an Access Denied.

Could you please give some advise as to how I can get this working...

Thanks a Lot....
Ashutosh

[Anon]

mysql is using your IP to verify that your machine (IP-number) is allowed to connect to mysql. That means that you have a user username@localhost. This user is allowed to connect from localhost ( the machine where mysql is installed ). username@your_ip_number is allowed from your_ip_number. take a look at :
http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.html#Privilege_system , specially 6.9 and on. Be carefull with the privileges you give.

Lars Brandi Jensen