Configure MySQL external database

Follow these steps to configure MySQL external database:

1. Create the database and user for DLM engine. Replace the username, password, and the dbname.

   
   CREATE USER beacon IDENTIFIED BY 'beacon';
   CREATE DATABASE beacondb;
   GRANT ALL PRIVILEGES ON beacondb.* TO 'beacon'@'%' IDENTIFIED BY 'password';
   

2. Setup the mysql connector in Ambari.
   If Ambari is not already setup with mysql connector, follow these steps:
   1. Download mysql connector.
   2. Setup the connector in Ambari.

      ambari-server setup --jdbc-db=mysql --jdbc-driver=/path/to/mysql/mysql-connector-java.jar