CREATE DATABASE [database name];
GRANT ALL ON [database name] TO '[username]'@'[hostname]';
Create a databas in two steps...
- First - think of a really good name.
- Second - run the
Create Database
command
Next you need to assign someone to use the database with a GRANT
command: