Cloudera Edge Management Installation
Also available as:
PDF

Configuring the EFM Server Metadata Store in MySQL

EFM Server requires a relational data store to store metadata. To use MySQL for this, install MySQL and create a database for the CEM metastore.

  1. Launch the MySQL monitor:
    mysql -u root -p
  2. Create the database for the CEM metastore:
    CREATE DATABASE EFM DEFAULT CHARACTER SET utf8;
  3. Create the efm user account, replacing the final IDENTIFIED BY string with your password:
    CREATE USER 'efm@'%' IDENTIFIED BY '9oNio)ex1ndL';
  4. Assign privileges to the efm account:
    GRANT ALL PRIVILEGES ON *.* TO 'efm@'%' WITH GRANT OPTION;
  5. Commit the operation:
    commit;