MySQL :: MySQL 5.6 Reference Manual :: 13.7.1.4 GRANT Syntax

CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'mypass';
GRANT ALL ON db1.* TO 'jeffrey'@'localhost';
GRANT SELECT ON db2.invoice TO 'jeffrey'@'localhost';
GRANT USAGE ON *.* TO 'jeffrey'@'localhost' WITH MAX_QUERIES_PER_HOUR 90;

MySQL :: MySQL 5.6 Reference Manual :: 13.7.1.4 GRANT Syntax