Page History
...
Most SQL DM for MySQL functionalities don't do not require any privileges at all for the user it uses in establishing client connections with MySQL. You can create it without any special global or object privileges, using the following command:
...
In order to use the EXPLAIN option on the processlist, you need to grant SELECT and SHOW VIEW to the objects accessed by the statements you want to explain, or , more simply, grant the global SELECT privilege.
...