December 2002
Beginner
640 pages
16h 41m
English
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.
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 ]
GRANT has enough ...