cdh_prereq8.txt

$ mysql –u root  –p 
mysql> create database testdb;
mysql> create database rman;
mysql> create database hive;
mysql> create database oozie;
mysql> grant all on testdb.* to 'root' identified by 'password';
mysql> grant all on rman.* to 'rman' identified by 'rman';
mysql> grant all on hive.* to 'hive' identified by 'hive';
mysql> grant all on oozie.* to 'oozie' identified by 'oozie';
mysql> exit;

//NOTE: to create users and assign permissions on database: grant all on testdb.* to 'testuser' identified by 'password';