To create a new database and associated username, first run "mysql" as root.

Then, from the MySQL command prompt:

CREATE DATABASE database;
USE mysql;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON database.* TO username@localhost IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
EXIT

And that's it!