- GRANT is how we add users, and GRANT permissions
mysql>GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...]
ON {tbl_name | * | *.* | db_name.*}
TO user_name [IDENTIFIED BY 'password']
[, user_name [IDENTIFIED BY 'password'] ...]
[WITH GRANT OPTION]
making sense of the above
multi-level privileges: tables, column, db, global
*.* == global, db.* == database
what can a username be?
why care what host the user connects from?
FLUSH PRIVILEGES;
REVOKE
SHOW GRANTS
NEXT
INDEX
Master Index