Cloudera Hadoop Tutorial - Retail DB Installation

The Cloudera getting started tutorial requires "retail_db" mysql database for learning the concepts.  
If you are using the "Cloudera QuickStartVM" then you are fine.  But if you have setup the Hadoop Cluster manually, like me, you will find that the "retail_db" mysql database missing.

This post is for detailing how to install the "retail_db" mysql database.

1.  Download the attached "retail_db" script.
Retail_db MySQL database

Or this can also be downloaded from command prompt using the command

2.  Login to MySQL as below:

3.  Create a database "retail_db" and a database user as below:

4. Grant all permissions to the user "retail_dba" and populate the database using the script downloaded in step 1.

5.  After successful completion of loading script, verity the tables as below:

This will give a sample database in MySQL to complete the Cloudera tutorial.