ID: 8507 Updated by: sniper Reported By: [EMAIL PROTECTED] Old-Status: Feedback Status: Closed Bug Type: MySQL related Assigned To: Comments: No feedback. Old PHP version. Previous Comments: --------------------------------------------------------------------------- [2001-01-02 08:51:43] [EMAIL PROTECTED] I assume that mysqld is running? Try reconfigure php to use the installed mysql instead of the bundled client library. 1. Delete config.cache 2. Use --with-mysql=/path/to/mysql/install/dir 3. 'make clean ; make depend ; make ; make install' Please report back whether this works for you or not. --Jani --------------------------------------------------------------------------- [2000-12-31 22:24:38] [EMAIL PROTECTED] I own a Cobalt Raq4 preinstalled with PHP Version 4.0.1pl2 and Chilisoft ASP. Chilisoft ASP will only work with Mysql 3.22.32. I am unable to connect to my databases using PHP 4.0.1 in MySQL 3.22.32. phpinfo(); returns Mysql Client API version 3.23.10-alpha. The script I am using is as follows <?php //connect $connection = mysql_connect("localhost","user","password") or die ("Couldn't connect to server."); //select db $db = mysql_select_db("database", $connection) or die("Couldn't select database."); //create sql statement $sql = "SELECT * (tablename)"; //execute sql query and get results $sql_result = mysql_query($sql) or die("Couldn't execute query."); //results //format results by row while ($row = mysql_fetch_array($sql_result)) { $id = $row["id"]; //for every field copy this line and make it for that row. echo "the contents you want displayed"; echo "the contents you want displayed"; } //close connection mysql_free_result($sql_result); mysql_close($connection); ?> I have filled in all of the correct parameters and I got the following message. The script is cut from the page and the error message line matches up with the actual page. Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /home/sites/site2/web/info.php on line 5 Couldn't connect to server. Is this a bug or is there a way to make PHP 4.0.1pl2 connect to Mysql 3.22.32. Any help would be greatly appreciated --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=8507&edit=2 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]