[SOLVED] Quick question about database connection

[adamjones]

Hi.

 

Just wondering how I would go around connecting to a database on a different server?

 

<?php

$host="localhost";
$username="username";
$password="password";
$db_name="database";

?>

 

Would I just change it to;

 

<?php

$host="mywebaddress.com";
$username="username";
$password="password";
$db_name="database";

?>

 

Or is it more complex? Sorry about the silly question!

 

 

[wildteen88]

Yes just specify the domain or the IP address for the mysql server you're wanting to connect to.

[adamjones]

Does this work if you're using shared hosting? Just tried and got this error;

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'wowdream_domaine'@'atlantic.lc-hosting.com' (using password: YES) in /home/visionop/public_html/test.php on line 8

cannot connect

 

 

...Must I have dedicated hosting?

 

Regards.

[.josh]

the target host needs to be set to allow outside connections, as well.  You have to specify the allowed host's IP through cpanel or on command line or wherever.

[adamjones]

Ok.

 

I'm using cPanel 10 - How do I do this?

[.josh]

go down to database section click on remote mysql and fill in the blank

[adamjones]

Thanks! [: