The command "SHOW GRANTS" will display the privileges that the current user has.
Command: SHOW GRANTS
Sample output:
+------------------------------------------------------------------------------------------------------------------+
|Grants for dbuser@% |
+------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'dbuser'@'%' IDENTIFIED BY PASSWORD '*03E51IIDCEYB2B07FF7A98489A5C0E905A7087BC' |
+------------------------------------------------------------------------------------------------------------------+
You can master the GRANT command to have varied output. Be cautious while using GRANT as you may be restricting the permission(s) to the user.
