Hello,

I've been working on a new script that will access the MySQL database. In testing this script, I was worried about the complexity of some of my queries, so I naturally went to the MySQL client and ran them with "explain". It appears that I do not have permission to do so. Is this intended? Is something wrong?

EXPLAIN/SHOW can not be issued; lacking privileges for underlying table

See session snippet below:

grphack@willow:~$ mysql -h enwiki-p.userdb.toolserver.org enwiki_p

Server version: 5.1.66 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> explain select * from revision;

ERROR 1345 (HY000): EXPLAIN/SHOW can not be issued; lacking privileges for underlying table

Thanks!

-Aaron