MySQL - Create new database, new user, set privileges

Create database, create user, grant privileges, reload MySQL:

CREATE DATABASE `dbname` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE USER 'dbuser'@'hostname' IDENTIFIED BY '***password***';

GRANT USAGE ON * . * TO 'dbuser'@'hostname' IDENTIFIED BY '***password***' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

GRANT SELECT , INSERT , UPDATE ON `dbname` . * TO 'dbuser'@'hostname';

FLUSH PRIVILEGES;