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.
- Install and Start MySQL 8.
-
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
-
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/
- For installations that use packages: