From:             [EMAIL PROTECTED]
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



-- 
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]

Reply via email to