MySQL Permissions Cheat Sheet

Create a regular user

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,ALTER,EXECUTE
ON database.* TO 'monty'@'localhost'
IDENTIFIED BY 'some_pass';

Drop a user

DROP USER 'monty'@'localhost';

Revoke GRANT permission on a user

REVOKE GRANT OPTION ON *.* FROM 'monty'@'localhost';