Re: MySQL, PHPMyAdmin, GRANT, headaches

Janet Valade wrote:

First, if you are having an access denied problem, you will get a PHP error message. Perhaps you have errors turned off in your PHP script. Turn them on until you get it working.

I forgot to mention that i've temporarily set: ini_set('track_errors', TRUE); // to access $php_errormsg error_reporting(E_ALL); I've determined that i can, indeed, connect to the DB. It's selecting from a table that *seems* to be the problem.

Second, you should be able to use phpMyAdmin to see what the permissions are for the account you are using.

I poked around for that. Apparently, phpMyAdmin has a "Privileges" page but i can't locate it. On the "operations" page, i find this at the bottom: Error The additional features for working with linked tables have been deactivated. To find out why click here. When i follow the link i get: PMA Database ... not OK[ Documentation ] General relation features Disabled David Giragosian wrote:

use your phpmyadmin account to get the permissions for the second username/password login. Show grants for username@yourhostname;

Argh! It's always the simple things one forgets to do, isn't it? GRANT USAGE ON *.* TO ... GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP... So, i'm back to square one, i see. brian