Configure MySQL external database
Follow these steps to configure MySQL external database:
-
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';
-
Setup the mysql connector in Ambari.
If Ambari is not already setup with mysql connector, follow these steps:
- Download mysql connector.
-
Setup the connector in Ambari.
ambari-server setup --jdbc-db=mysql --jdbc-driver=/path/to/mysql/mysql-connector-java.jar