devxlogo

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;