Create user and grant access to mysql database

mysql_commands.sql

/* Login from terminal */
mysql -u USERNAME -p DATABASENAME;

/* Simple commands */
create database DATABASENAME;
show databases;
use DATABASENAME;

/* Create a user and grant access to database */
grant all privileges on DATABASENAME.* 
to 'USERNAME'@'localhost' 
identified by 'PASSWORD';

/* Change user password */
SET PASSWORD FOR 'USERNAME'@'localhost' = PASSWORD('NEWPASSWORD');

/* Show grants */
show grants for 'USERNAME'@'localhost';

/* Links */
http://cse.unl.edu/~sscott/ShowFiles/SQL/CheatSheet/SQLCheatSheet.html