PHP 4.0 Bug #9601: MySQL connects to wrong database

From: gkopp@ideastar.com Operating system: Linux 6.2 PHP version: 4.0.4pl1 PHP Bug Type: MySQL related Bug description: MySQL connects to wrong database MySQL: 3.22.32-beta Apache: 1.3.14 MySQL is connecting to the wrong database: I have two databases: ceres ceres_test The ceres database is the live database and the user "ceres" is granted permissions on it. The ceres_test database is a database that is identical, but I use for testing purposes. The mysql user "ceresdb" has permissions to access the "ceres" database ONLY. However, if I execute: mysql_pconnect("localhost","ceresdb", "password"); mysql_select_db("ceres_test"); It actually connects to the "ceres" database instead. I should have recieved and error that it was unable to connect. We have verified this several ways. Also, if I change the username/password to the root user or a user that has permissions on ALL databases, it works fine. -- Edit Bug report at: http://bugs.php.net/?id=9601&edit=1