Re: Connecting to DB on separate server?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Monday 04 November 2002 12:35, Bob Lockie wrote:
> Cassy M Rowe wrote:
> > 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)

IP address or the FQDN (obviously it has to be resovable to an IP address).

> > $username: blah
> > $password: blah
> > $database: _____________

Just the name of the 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?

The obvious question is: does server #2 ALLOW remote connections from server 
#1? If so does it work if you connect using the mysql command line?

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *


/*
It's not so hard to lift yourself by your bootstraps once you're off the 
ground.
		-- Daniel B. Luten
*/


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux