PHP 4.0 Bug #9601 Updated: MySQL connects to wrong database

ID: 9601 User Update by: gkopp@ideastar.com Status: Closed Bug Type: MySQL related Description: MySQL connects to wrong database The grant tables are fine. Perhaps we misunderstood ourselves. If I use "mysql" to connect to the live database using a user name and password that is in the grant tables, it works fine. If I use "mysql" to connect to the test database using a user name and password that DOES NOT HAVE PRIVILEGES to this database, authentication fails, as it should. If I use PHP to connect to the live database using a user name and password that is in the grant tables, it works fine. If I use PHP to connect to the test database using the SAME user name and password that works for the live database, it connects to the LIVE database instead of the test database. We found this by accident when setting up a test web site that duplicates a live site. When I changed the database name in the connection object, it didn't fail, it just connected to the live database. Previous Comments: --------------------------------------------------------------------------- [2001-03-07 10:59:54] cnewbill@php.net USER NOTES FROM EMAIL: I just used --with-mysql AND ERROR 1045: Access denied for user: 'ceresdb@localhost' (Using password: YES) When executing the mysql command from a bash shell. Greg --------------------------------------------------------------------------- [2001-03-07 10:59:01] cnewbill@php.net Please use the bug system when replying. Thanx. Well it looks like you don't have the Grant Tables setup properly OR you didn't flush them after changing them. Do a mysqladmin reload and try again, if it still doesn't connect then you need to fix your grant tables. See http://www.mysql.com/documentation/index.html for information on how to do this. I haven't seen it cause any problems, but just to be safe you should recompile PHP using --with-mysql=/path/to/mysql so PHP is aware of what version you are actually using. If for some reason your grant tables are not the problem simply reopen this report. -Chris --------------------------------------------------------------------------- [2001-03-07 10:45:31] cnewbill@php.net Couple stupid questions. 1) When you compiled PHP, did you just use --with-mysql instead of --with-mysql=/path/to/mysql? 2) Does the mysql command line tool connect? i.e. mysql -u ceres -pxxxx ceres_test -Chris --------------------------------------------------------------------------- [2001-03-07 09:34:33] gkopp@ideastar.com 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. --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=9601