Accessing mysql from an external host

[frankymacho]

Is it possible to access mysql from an external host. For example, I have a site (www.example_1.com) with a mysql database implemented through my hosting company. Would it be possible to access the info in those tables and populate www.example_2.com with it?

FYI, my current php/mysql connection code is:

$mysql_db = "db1";
$mysql_user = "user1";
$mysql_pass = "pass1";
$mysql_link = mysql_connect("localhost", $mysql_user, $mysql_pass);
mysql_select_db($mysql_db, $mysql_link);

-Thanks

[LordShryku]

Yes, it's possible.

[frankymacho]

Cool, now that I know it's possible, what would be the appropriate code I'd need to add/subtract to what I currently have...

$mysql_db = "db1";
$mysql_user = "user1";
$mysql_pass = "pass1";
$mysql_link = mysql_connect("localhost", $mysql_user, $mysql_pass);
mysql_select_db($mysql_db, $mysql_link);

I've already tried replacing "localhost" with the ip address and url of the database location, but it's still not connecting. Any help would be greatly appreciated.

-Thanks

[LordShryku]

Your permissions in the database need to specify that you can access it from somewhere other than localhost.

[frankymacho]

Thanks for the info, I'll check the permissions. -fm