Create new MySQL database and user

mysql -u root -p
mysql> create database dbname default character set utf8;
mysql> grant usage on *.* to dbuser@localhost identified by 'userpass';
mysql> grant all privileges on dbname.* to dbuser@localhost ;
mysql -u dbuser -p'userpass' dbname