RE: [PHP-DB] php4 / mysql connection problems From: Jason Stechschulte (jpstech <email protected>)
Date: 07/13/00

Are you using the same server? It sounds like the
server name or address may have changed. To
connect to a remote mysql host, the mysql server
has to be configured to give permission to the
remote host to connect to it. If mysql is
configured on the server php is running on, try
this.

mysql --host=<hostname> --user=<username> --passwo
rd=<password>

If this doesn't work from the same machine that
your php scripts are on, then there is a problem
with the mysql configuration.

Jason Stechschulte
jpstech <email protected>

-----Original Message-----
From: BENNETTM <email protected>
[mailto:BENNETTM <email protected>]
Sent: Thursday, July 13, 2000 12:19 PM
To: php-db <email protected>
Subject: [PHP-DB] php4 / mysql connection problems

Hello,
 I've installed php4 on my system and now my
scripts
can't
connect to a mysql server on a remote system.
Using
php3 worked
fine (This is has been an active site for a while)

PHP4 is dying on this line:

$connection = mysql_connect("<hostname>",
"<username>" ,
"<password>");

The message I'm getting is this:

Warning: MySQL Connection Failed. Can't connect to
MySQL
server on '<server name goes here>' (111) in <html
file>
on line 26.

Unfortunately, I can't go back to php3 because of
a
number of
reasons.

Please help! I have to get this site back up ASAP.

Thank you very much! 

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail:
php-db-unsubscribe <email protected>
For additional commands, e-mail:
php-db-help <email protected>
To contact the list administrators, e-mail:
php-list-admin <email protected>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>