SHOW PRIVILEGES Syntax
SHOW PRIVILEGES shows the list of system privileges that the MariaDB server supports. The exact list of privileges depends on the version of your server.
mysql> SHOW PRIVILEGES\G
*************************** 1. row ***************************
Privilege: Alter Context: Tables Comment: To alter the table
*************************** 2. row ***************************
Privilege: Alter routine Context: Functions,Procedures Comment: To alter or drop stored functions/procedures
*************************** 3. row ***************************
Privilege: Create Context: Databases,Tables,Indexes Comment: To create new databases and tables
*************************** 4. row ***************************
Privilege: Create routine Context: Functions,Procedures Comment: To use CREATE FUNCTION/PROCEDURE
*************************** 5. row ***************************
Privilege: Create temporary tables Context: Databases Comment: To use CREATE TEMPORARY TABLE
...
Privileges belonging to a specific user are displayed by the SHOW GRANTS statement. See , "SHOW GRANTS Syntax", for more information.