Database Administration

• User Management
  • Database User
  • CREATE USER
  • ALTER USER
  • DROP USER
  • GRANT
  • REVOKE
  • ALTER … OWNER
  • User Authorization Management METHOD
• SET
  • System Parameter
  • User Variables
• KILL
• SHOW
  • DESC, DESCRIBE
  • EXPLAIN
  • SHOW TABLES
  • SHOW COLUMNS
  • SHOW INDEX
  • SHOW COLLATION
  • SHOW TIMEZONES
  • SHOW GRANTS
  • SHOW CREATE TABLE
  • SHOW CREATE VIEW
  • SHOW ACCESS STATUS
  • SHOW EXEC STATISTICS
  • Diagnostics