Cloudera Docs

Configuring MySQL 8 for Oozie

You must install MySQL 8, create the Oozie database and MySQL user, and add the MySQL JDBC driver jar file to Oozie.

  1. Install and Start MySQL 8.
  2. 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> CREATE USER 'oozie'@'localhost' IDENTIFIED BY 'oozie';
 Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON oozie.* TO 'oozie'@'localhost';
 Query OK, 0 rows affected (0.00 sec)
mysql> CREATE USER 'oozie'@'%' IDENTIFIED BY 'oozie';
 Query OK, 0 rows affected (0.01 sec)
mysql> GRANT ALL PRIVILEGES ON oozie.* TO 'oozie'@'%';
 Query OK, 0 rows affected (0.00 sec)
mysql> exit
  3. 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/