RE: [PHP-DB] php4 / mysql connection problems

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@nc.edu -----Original Message----- From: BENNETTM@cnbrown.com [mailto:BENNETTM@cnbrown.com] Sent: Thursday, July 13, 2000 12:19 PM To: php-db@lists.php.net 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@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net