Sams Teach Yourself MySQL in 21 Days, Second Edition

Managing User Privileges with `GRANT` and `REVOKE`

You've seen how the grant tables work together, in some detail. Although it's possible to create, delete, and modify users by making changes to these tables directly (and prior to version 3.22.11 of MySQL, this was the only way), MySQL now has the GRANT and REVOKE commands, which make user management much easier.

Granting Privileges with `GRANT`

The GRANT statement has the following syntax:

GRANT privileges [(column_list)]
  ON database_name.table_name
  TO username@hostname [IDENTIFIED BY 'password']
  [REQUIRE [SSL | X509]
    [CIPHER cipher [AND]]
    [ISSUER issuer [AND]]
    [SUBJECT subject]]
  [WITH GRANT OPTION |
    MAX_QUERIES_PER_HOUR num |
    MAX_UPDATES_PER_HOUR num |
    MAX_CONNECTIONS_PER_HOUR num ]