How To Create a Database for Drupal

By default the MySQL root user password is blank.  Change this first for security reasons.
 mysqladmin -u root password NEWPASSWORD
 
Login as root and create a database name, username, and password.  Grant all privileges to username so Drupal can do it's thing.
 
 mysql -u root -p
 <enter password here>
 CREATE DATABASE `db-name`;
 CREATE USER 'db-user'@'localhost';
 SET PASSWORD FOR 'db-user'@'localhost' = PASSWORD('password');
 GRANT ALL PRIVILEGES ON `db-name`.* TO 'db-user'@'localhost';
 \q