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:
SHOW GRANTS FOR root;
Results in:
+-------------------------------------------------------------+| Grants for root@% |+-------------------------------------------------------------+| GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION |+-------------------------------------------------------------+