On Fri, Jan 4, 2013 at 1:55 PM, Aaron Halfaker aaron.halfaker@gmail.com wrote:
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 can leak information from underlying tables, so if you dont have permissions for those tables the explain will fail with the error message provided.