MySQL Recipes

Login Syntax

$ mysql -u <username> -p
Password: <enter password>

Create New User

mysql> CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

Grant User Privileges

> GRANT CREATE ON *.* TO 'username'@'localhost';
> GRANT INSERT ON *.* TO 'username'@'localhost';
> GRANT DELETE ON *.* TO 'username'@'localhost';
> GRANT DROP ON *.* TO 'username'@'localhost';
> GRANT SELECT ON *.* TO 'username'@'localhost';
> GRANT UPDATE ON *.* TO 'username'@'localhost';
> GRANT GRANT OPTION ON *.* TO 'username'@'localhost';