Configuring MySQL for Oozie

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
Bye

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/