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

ID: 9601 Updated by: cnewbill Reported By: gkopp@ideastar.com Old-Status: Open Status: Closed Bug Type: MySQL related Assigned To: Comments: 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 Previous Comments: --------------------------------------------------------------------------- [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. --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=9601&edit=2