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