|
Posted by Paul on 11/08/06 11:03
"Paul" <lof@invalid.com> wrote in message
news:oDi4h.10831$3L.10608@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!
>
Navigation:
[Reply to this message]
|