468,268 Members | 1,511 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,268 developers. It's quick & easy.

PEAR DB not working with recently upgraded MySQL 4.1

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.

This is different, I think, from my previous post about php not working with
MySQL 4.12 because I have that working now - php4.4.4 is workingon my
machine with MySQL 4.1 yet Pear DB is not.

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!
Nov 8 '06 #1
1 1830

"Paul" <lo*@invalid.comwrote in message
news:oD******************@bignews2.bellsouth.net.. .
>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.

This is different, I think, from my previous post about php not working
with MySQL 4.12 because I have that working now - php4.4.4 is workingon my
machine with MySQL 4.1 yet Pear DB is not.

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!

Nov 8 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by kain | last post: by
4 posts views Thread by Chung Leong | last post: by
reply views Thread by Robert | last post: by
13 posts views Thread by Tim Tyler | last post: by
3 posts views Thread by Sven Jacobs | last post: by
3 posts views Thread by Wayne Smallman | last post: by
5 posts views Thread by crescent_au | last post: by
5 posts views Thread by john | last post: by
2 posts views Thread by wannabe | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.