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
_______________________________________________
Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list: 
https://wiki.toolserver.org/view/Mailing_list_etiquette

Reply via email to