For those of you, like myself, who don't use Mysql too often, it is worth having a reference for MySQL commands.
These are just a very simple selection of basic commands that you will need to get a database and users setup quickly.
Show all users:
mysql> select * from mysql.user;
CREATE DATABASE mydb CHARACTER SET utf8 COLLATE utf8_bin;
CREATE USER 'myuser'@'%' IDENTIFIED BY PASSWORD 'password';
Grant all access to database for user:
GRANT ALL ON mydb.* TO 'myuser'@'%';
GRANT ALL ON mydb TO 'myuser'@'%';
GRANT CREATE ON mydb TO 'myuser'@'%';
Use this at the end of running any commands to save permanently:
References and further reading: