Installation and Creation of MySQL Database Failure

Good evening all!

I’m having some problems setting up a MySQL server in the installation process of wordpress.

I’ve just started with a fresh install of Ubuntu 13.10 64-bit. I’ve installed LAMP (Linux, Apache, MySQL, and PHP). The installation went successfully, I think. There were no errors to my knowledge. However, then I tried goofing around with MySQL. I know nothing about database creation. I tried logging into mysql using:

mysql -u root -p

I entered the default password I provided in install. But now I can’t create a database. I’ve tried:

CREATE DATABASE 7thUSInfReg;

Where “7thUSInfReg” is the name of my database to link wordpress to. I then create a user with:

CREATE USER 'pmbrenner91'@'7thUSInfReg' IDENTIFIED BY 'password';

This ends in an error:

ERROR 1396 (HY000): Operation CREATE USER failed for 'pmbrenner91'@'7thUSInfReg'

So… yeah. Any help would be greatly appreciated.