Create MySQL DB

The following is a quick example on how to create a database in mysql.  You would type secctions in blue.

#mysql -u root -p
Enter password:

Create a DB called blogger1
mysql> create database blogger1;

Allow user ‘xyz’ with password ‘xyzpassword’ access to server
mysql> grant usage on *.* to xyz@localhost identified by ‘xyzpassword’;

Allow all privileges on the blogger1 database to this user ‘xyz’
mysql> grant all privileges on blooger1.* to xyz@localhost ;

Now connect to the DB with user xyz
#mysql -u xyz -p blogger1