Re: Connecting to DB on separate server?

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 */