Mysql create database, user and grant privileges

create database database_name character set utf8;

create user username identified by 'password';

grant all privileges on database_name.* to username@'%';

This command equals to the two commands above
grant all privileges on database_name.* to username@'%' identified by 'password';