Using Oozie with MySQL

Before using Oozie with a new or existing MySQL database; obtain the appropriate driver and .jar files, create a Oozie user with sufficient permissions, and create the Oozie database.

1. On the Ambari Server host, stage the appropriate MySQL connector for later deployment.
   1. On the Ambari Server host, Download the MySQL Connector/JDBC driver from MySQL.
   2. Runambari-server setup --jdbc-db=mysql --jdbc-driver=/path/to/mysql/mysql-connector-java.jar
   3. Confirm that mysql-connector-java.jar is in the Java share directory.
      ls /usr/share/java/mysql-connector-java.jar
   4. Make sure the .jar file has the appropriate permissions - 644.
   5. Execute the following command:
      ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar
2. Create a user for Oozie and grant it permissions.
   using the MySQL database admin utility:

   # mysql -u root -p
   CREATE USER '<OOZIEUSER>'@'%' IDENTIFIED BY '<OOZIEPASSWORD>';
   GRANT ALL PRIVILEGES ON *.* TO '<OOZIEUSER>'@'%';
   FLUSH PRIVILEGES;

   Where [OOZIE_USER] is the Oozie user name and [OOZIE_PASSWORD] is the Oozie user password.
3. Create the Oozie database.
   The Oozie database must be created before loading the Oozie database schema.

   # mysql -u root -p
   CREATE DATABASE [OOZIE_DATABASE]

   Where [OOZIE_DATABASE] is the Oozie database name.