DB not working with upgraded Mysql 4.1
| From: | l Burnerheimerton | Date: | Wed, 08 Nov 2006 03:32:29 +0000 |
| Subject: | DB not working with upgraded Mysql 4.1 | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-25733@lists.php.net to get a copy of this message | ||
I recently upgraded from MySQL 3.23 to 4.1. Now db is
not working properly. I'd very much like your help in
solving this issue!
Here's the code I used to test it:
require_once 'DB.php';
$db =&
DB::connect('mysql://user:password@localhost/dbname');
if (PEAR::isError($db)) {
die($db->getMessage());
}
$res =& $db->query('SELECT * FROM table');
if (PEAR::isError($res)) {
die($res->getMessage());
}
The error message I get:
DB Error: insufficient permissions
I have this username in MySQL 4.1 set up in mysq.user
in the old style (pre MySQL 4.1) password. This user
has no right in the user table and SELECT rights in
the db table for this dbname. This is the way it
always worked in the past.
I verified the password by UPDATE setting it using
OLD_PASSWORD() and flushing privileges.
Any ideas what I can do to solve this issue?
Many thanks in advance!
____________________________________________________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail.
http://new.mail.yahoo.com