Privileges in MySQL

Usually how are MySQL permissions granted:

mysql> GRANT {{ privilege }} on {{ Database }}.{{ table }} to '{{ user }}'@'{{ host }}';

The {{ privilege }} could be:
ALL PRIVILEGES - Grant all access
DROP - Delete databases
DELETE - Delete rows from table
INSERT - Insert rows into table
SELECT - Read/Query tables
UPDATE - Update rows in table

You can specify multiple permissions separated by comma:

mysql> GRANT SELECT,UPDATE on school.persons to 'john'@'%';