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.
...