The command “SHOW GRANTS” will display the privileges that the current user has.
Command: SHOW GRANTSSample 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.