MySQL CREATE DATABASE CREATE USER GRANT ALL PRIVILEGES

CREATE DATABASE dbname;

CREATE USER 'username'@'%' IDENTIFIED BY 'passwordplain';

GRANT ALL PRIVILEGES ON dbname.* TO 'username'@'%';