Useful mysql commands

CREATE DATABASE database1;
CREATE USER 'user1'@'localhost' IDENTIFIED BY '********';
GRANT ALL PRIVILEGES ON database1.* TO 'user1'@'localhost';