Understanding What Grants a User Has in MySQL May 29, 2019 MySQL allows various permissions to be set for users during (or after) creation. The following command comes handy to understand what GRANTS a user has. Command: SHOW GRANTS FOR user;