Sams Teach Yourself MySQL in 21 Days, Second Edition

GRANT

Syntax:

GRANT privileges [(column_list)] [,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 ]

Description: Grants user privileges.

privileges may be given by any of ALL PRIVILEGES (or its synonym ALL), ALTER, CREATE, CREATE TEMPORARY TABLES, DELETE, DROP, EXECUTE, FILE, INDEX, INSERT, LOCK TABLES, PROCESS, REFERENCES, RELOAD, REPLICATION CLIENT, REPLICATION SLAVE, SELECT, SHOW DATABASES, SHUTDOWN, SUPER, UPDATE, and USAGE.

database_name and table_name may be specified, or you may give wildcards, ...