ID: 9601
Updated by: cnewbill
Reported By: [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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
--
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]
