May 29, 2019

Understanding What Grants a User Has in MySQL

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; In the above command, replace the user with the real username to know the GRANTS associated with the user. Sample: