You must install MySQL 5, create the Oozie database and MySQL user, and add the MySQL
JDBC driver jar file to Oozie.
-
Install and Start MySQL 5.
-
Create the Oozie Database and Oozie MySQL User.
For example, using the MySQL mysql
command-line tool:
$ mysql -u root -p
Enter password:
mysql> create database oozie default character set utf8;
Query OK, 1 row affected (0.00 sec)
mysql> grant all privileges on oozie.* to 'oozie'@'localhost' identified by 'oozie';
Query OK, 0 rows affected (0.00 sec)
mysql> grant all privileges on oozie.* to 'oozie'@'%' identified by 'oozie';
Query OK, 0 rows affected (0.00 sec)
mysql> exit
-
Add the MySQL JDBC Driver JAR to Oozie.
Copy or symbolically link the MySQL JDBC driver JAR into one of the following
directories:
- For installations that use packages:
/var/lib/oozie/
- For installations that use parcels:
/opt/cloudera/parcels/CDH/lib/oozie/lib/