(mysql.info) show-privileges

Info Catalog

(mysql.info) show-open-tables

(mysql.info) show

(mysql.info) show-procedure-status

 
 13.5.4.17 `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: Functions,Procedures
      Comment: To use CREATE FUNCTION/PROCEDURE
      *************************** 5. row ***************************
      Privilege: Create temporary tables
      Context: Databases
      Comment: To use CREATE TEMPORARY TABLE
      ...
 

Info Catalog

(mysql.info) show-open-tables

(mysql.info) show

(mysql.info) show-procedure-status