(mysql.info.gz) SHOW PRIVILEGES

 
 13.5.4.14 `SHOW PRIVILEGES' Syntax
 ..................................
 
      SHOW PRIVILEGES
 
 `SHOW PRIVILEGES' shows the list of system privileges that the
 underlying MySQL server supports.  This statement is implemented as of
 MySQL 4.1.0.
 
      mysql> SHOW PRIVILEGES\G
      *************************** 1. row ***************************
      Privilege: Select
        Context: Tables
        Comment: To retrieve rows from table
      *************************** 2. row ***************************
      Privilege: Insert
        Context: Tables
        Comment: To insert data into tables
      *************************** 3. row ***************************
      Privilege: Update
        Context: Tables
        Comment: To update existing rows
      *************************** 4. row ***************************
      Privilege: Delete
        Context: Tables
        Comment: To delete existing rows
      *************************** 5. row ***************************
      Privilege: Index
        Context: Tables
        Comment: To create or drop indexes
      *************************** 6. row ***************************
      Privilege: Alter
        Context: Tables
        Comment: To alter the table
      *************************** 7. row ***************************
      Privilege: Create
        Context: Databases,Tables,Indexes
        Comment: To create new databases and tables
      *************************** 8. row ***************************
      Privilege: Drop
        Context: Databases,Tables
        Comment: To drop databases and tables
      *************************** 9. row ***************************
      Privilege: Grant
        Context: Databases,Tables
        Comment: To give to other users those privileges you possess
      *************************** 10. row ***************************
      Privilege: References
        Context: Databases,Tables
        Comment: To have references on tables
      *************************** 11. row ***************************
      Privilege: Reload
        Context: Server Admin
        Comment: To reload or refresh tables, logs and privileges
      *************************** 12. row ***************************
      Privilege: Shutdown
        Context: Server Admin
        Comment: To shutdown the server
      *************************** 13. row ***************************
      Privilege: Process
        Context: Server Admin
        Comment: To view the plain text of currently executing queries
      *************************** 14. row ***************************
      Privilege: File
        Context: File access on server
        Comment: To read and write files on the server
Info Catalog
(mysql.info.gz) SHOW LOGS
(mysql.info.gz) SHOW
(mysql.info.gz) SHOW PROCESSLIST
automatically generated byinfo2html