SHOW PRIVILEGES

    1. +-------------------------+---------------------------------------+-------------------------------------------------------+
    2. | Privilege               | Context                               | Comment                                               |
    3. +-------------------------+---------------------------------------+-------------------------------------------------------+
    4. | Alter                   | Tables                                | To alter the table                                    |
    5. | Alter                   | Tables                                | To alter the table                                    |
    6. | Alter routine           | Functions,Procedures                  | To alter or drop stored functions/procedures          |
    7. | Create                  | Databases,Tables,Indexes              | To create new databases and tables                    |
    8. | Create routine          | Databases                             | To use CREATE FUNCTION/PROCEDURE                      |
    9. | Create temporary tables | Databases                             | To use CREATE TEMPORARY TABLE                         |
    10. | Create user             | Server Admin                          | To create new users                                   |
    11. | Delete                  | Tables                                | To delete existing rows                               |
    13. | Event                   | Server Admin                          | To create, alter, drop and execute events             |
    14. | Execute                 | Functions,Procedures                  | To execute stored routines                            |
    15. | File                    | File access on server                 | To read and write files on the server                 |
    16. | Grant option            | Databases,Tables,Functions,Procedures | To give to other users those privileges you possess   |
    17. | Index                   | Tables                                | To create or drop indexes                             |
    18. | Insert                  | Tables                                | To insert data into tables                            |
    19. | Lock tables             | Databases                             | To use LOCK TABLES (together with SELECT privilege)   |
    20. | Process                 | Server Admin                          | To view the plain text of currently executing queries |
    21. | Proxy                   | Server Admin                          | To make proxy user possible                           |
    22. | References              | Databases,Tables                      | To have references on tables                          |
    23. | Replication client      | Server Admin                          | To ask where the slave or master servers are          |
    25. | Select                  | Tables                                | To retrieve rows from table                           |
    26. | Show databases          | Server Admin                          | To see all databases with SHOW DATABASES              |
    27. | Show view               | Tables                                | To see views with SHOW CREATE VIEW                    |
    28. | Shutdown                | Server Admin                          | To shut down the server                               |
    29. | Super                   | Server Admin                          | To use KILL thread, SET GLOBAL, CHANGE MASTER, etc.   |
    30. | Trigger                 | Tables                                | To use triggers                                       |
    31. | Create tablespace       | Server Admin                          | To create/alter/drop tablespaces                      |
    32. | Update                  | Tables                                | To update existing rows                               |
    33. | Usage                   | Server Admin                          | No privileges - allow connect only                    |
    34. +-------------------------+---------------------------------------+-------------------------------------------------------+
    35. 32 rows in set (0.00 sec)