Jump to content


Photo

How do I Connect to remote mysql database


  • Please log in to reply
1 reply to this topic

#1 beachcomber

beachcomber
  • New Members
  • Pip
  • Newbie
  • 1 posts
  • LocationTonbridge Kent England

Posted 10 September 2003 - 05:42 PM

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

#2 metalblend

metalblend
  • Members
  • PipPipPip
  • Advanced Member
  • 89 posts
  • LocationCalifornia, USA

Posted 11 September 2003 - 12:48 AM

The code works fine.. this is a server issue.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users