MySQL create database, user and permissions

mysql -u root -p

create database databasename;

grant usage on *.* to databaseuser@localhost identified by 'userpassword';

grant all privileges on databasename.* to databaseuser@localhost ;