Connect to database on other domain

[Delight]

I have a website on domain_A. I like to have it connect to a database witch is on domain_B (differend provider and differend url).

Is this possible?

[GregL83]

Yes, provide the location of the mysql server (domainB) in your database connection function.

 

i.e.

 

$connection = mysql_connect('domain_location','username','password');

 

assuming your using php.

[GregL83]

http://us3.php.net/mysql_connect

 

That should help...

[Zane]

of course...that's the proper way of connecting and all...

 

but on the mysql side of it all....you need to ALLOW domain A to connect.. or else you'll get an error saying something like

 

error connection...using password YES

are you using phpmyadmin or are you using the mysql shell to acces your database?

[revraz]

Many Hosts do not allow outside access to the Database, you should really check with your Host first.

[Delight]

Thanks all, I'll give this a try.

 

To answer all the questions: I'm using php, phpmyadmin and mysql.