I tried doing the steps with following details
database host name : quickstart.cloudera
database type Mysql
But was not sure of the database name, user name, password.
Then went into terminal, loged into Mysql using
$mysql -uroot -pcloudera
And then listed all databases using mysql> show databases;
use one of them mysql> use database_name;
And then listed all tables using mysql> show tables;
created a table name as reportdb.
used table name as Reportdb, user as root and password as cloudera to create the report manager role succesfully.
This is just the next steps in the same chain. I thought it is better to keep it updated that might help people to see that.