13.7.5.27. SHOW PRIVILEGES Syntax

SHOW PRIVILEGES

SHOW PRIVILEGES shows the list of system privileges that the MySQL 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: Databases  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 Section 13.7.5.22, "SHOW GRANTS Syntax", for more information.