MySQL create user

To create user:


CREATE USER 'username'@'host' IDENTIFIED BY 'password';

To grant all privileges to user on a specific database:

GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'host';