mysql connect to different server

[rosegarden]

I am trying to connect to a mysql database on a different server. I am assuming that I replace localhost with a value which points to the other server. I am unable to find this info on the mysql or php manuals.

[devinemke]

the mysql and php manuals are not going to be able to tell you the path to your server. if you don't know the path, ask that server's sysadmin.

[j_miguel_y]

instead of inputting localhost, input the IP address of the server. You should be able to connect to it. If you still cannot connect, log into the server side and login to mysql as root and use this command.

GRANT ALL PRIVILEGES ON db_name.* username@'%';

Then try logging in from the client side, this should work now
using mysql -u username -p