Connecting to remote server.

[ybinds]

I have a task, where I must be able to get connected to a mysql table which is on a remote server. For ex. my php script is on A server and my mysql db table is on B server. Then I must be able to get connected from my script to that remote mysql server. Can anyone please help me in giving the code for this task.

Thanks in advance.

[stolzyboy]

you need to allow remote access on the server with mysql on it

Check this out for a full explanation http://www.mysql.com/documentation/...ege_system.html

example
GRANT ALL PRIVILEGES on databasename.* to username@%;

The above allows "username" to have all privileges to "databasename" from "%"(anywhere).