mysql connect to external server

[Anon]

I have a server and mysql on my compter. I also have a web site hosted by another company. How do I connect to my database located on the other companies server. It keeps trying to connect to my mysql server.

here's to code:

<?
$mysql_link = mysql_connect("the address to the other mysql", "username", "pass")
or die
("<p>Could not connect to the database!");
mysql_select_db("my database", $mysql_link)
or die
("<p>Could not open the database!");
?>

whenver I run this it says could not connect username@my_ip_address.

how do i get it to find mysql on the other server. Thanks

[Anon]

you will need to ask the server admin to set up your account for external MySQL access this is done by setting Host to % for your username in the user table under the MySQL database