Jump to content

Archived

This topic is now archived and is closed to further replies.

beachcomber

How do I Connect to remote mysql database

Recommended Posts

Hi,

 

I have a requirement to allow remote access to my mysql database.

 

I\'ve read a million threads on this subject and none of them seem to give clear instructions on how to do this.

 

I tried the following code.

 

where $db_hostname is the ip address of the server.

 

 




 $db_hostname= xxx.xxx.xxx.xxx 

 $db_username="XXXXX"; 

 $db_password="YYYYYY";







if(!mysql_connect("$db_hostname","$db_username","$db_password"))

{

echo "SQL_ERROR: Cannot connect to Database: $db_name<br>"; exit();

}



else



{



echo "Connection successful";



}



 

 

This produced the following set of errors.

 

Warning: Access denied for user: \'XXXXXX@ns0.ennsol.co.uk\' (Using password: YES) in /www/html/_codebase/connect/remote_connect.php on line 22

 

Warning: MySQL Connection Failed: Access denied for user: \'XXXXX@ns0.ennsol.co.uk\' (Using password: YES) in /home/virtual/site97/fst/var/www/html/_codebase/connect/remote_connect.php on line 22

SQL_ERROR: Cannot connect to Database: testbed_ennsol_co_uk

 

If I use localhost as the db_hostname I connect without any problems. What do I have to do to allow a remote connection to the database?

 

Is this a coding issue or is there a setting on the server that needs to be changed?

 

 

All help and suggestion greatfully received!

 

Rob

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.