create user 'username'@'localhost' identified by 'password'

grant all privileges on *.* to 'username'@'localhost';
grant all privileges on 'DBname'.* to 'username'@'localhost';

drop user 'username'@'localhost';

CREATE DATABASE 'DBname';

CREATE TABLE table_name
(
column1 data_type(size),
column2 data_type(size),
column3 data_type(size),
...
)