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';