A simple way to add a database and a user and grant all privileges

create database DatabaseName;
create user UserName identified by 'Password';
grant all privileges on DatabaseName.* to 'UserName'@'localhost';
grant all privileges on DatabaseName.* to 'UserName'@'%';

Continue reading...