MySQL User Management

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password'; # local user
CREATE USER 'username'@'%' IDENTIFIED BY 'password'; # any host

GRANT ALL PRIVILEGES ON database.* TO 'username'@'localhost'; # all privileges
GRANT SELECT, INSERT ON database.* TO 'username'@'localhost'; # specific privileges
FLUSH PRIVILEGES; # reload privileges

REVOKE INSERT ON database.* FROM 'username'@'localhost'; # revoke privilege

SHOW GRANTS FOR 'username'@'localhost'; # view user privileges

DROP USER 'username'@'localhost'; # delete user

ALTER USER 'username'@'localhost' IDENTIFIED BY 'newpassword'; # change password