MySQL

Adding a user

grant all privileges on {database_name}.* to {database_user}@'%' identified by 'their_password';

Revoking privileges

revoke usage on {databse_name}.* from 'user'@'%';

Removing a user entirely

drop user {user_name}@'%';