ID: 9601
Updated by: cnewbill
Status: Open
Bug Type: MySQL related
Assigned To: 

Couple stupid questions.

1) When you compiled PHP, did you just use --with-mysql instead of 

2) Does the mysql command line tool connect? i.e. mysql -u ceres -pxxxx ceres_test


Previous Comments:

[2001-03-07 09:34:33] [EMAIL PROTECTED]
MySQL: 3.22.32-beta
Apache: 1.3.14

MySQL is connecting to the wrong database:

I have two databases:


The ceres database is the live database and the user "ceres" is granted permissions on 

The ceres_test database is a database that is identical, but I use for testing 

The mysql user "ceresdb" has permissions to access the "ceres" database ONLY.

However, if I execute:

mysql_pconnect("localhost","ceresdb", "password");

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

PHP Development Mailing List <>
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