Connecting to DB on separate server?
| From: | Cassy M Rowe | Date: | Mon, 04 Nov 2002 04:27:11 +0000 |
| Subject: | Connecting to DB on separate server? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-22948@lists.php.net to get a copy of this message | ||
I have a php page on server #1 trying to access a database on server #2. What do I put in the following blanks:
$hostname: ___________ (have tried IP, http, localhost, nothing works)
$username: blah
$password: blah
$database: _____________
$link=mysql_connect($hostname, $user, $pass) or die("Failure to communicate with database");
$close=mysql_select_db($database, $link);
All I get is the "Failure to communicate....." message.
Server #1: ellerweb.eller.arizona.edu
Server #2: datamonster.sbs.arizona.edu
$database is cassy, but do I need to add anything to that?
I've tried asking two people who are really good at this and they have no answers.
THANK YOU IN ADVANCE!
Cassy Rowe