Installing HDF Services on a New HDP Cluster
Also available as:

Configuring NiFi Registry Metadata Stores in MySQL

MySQL provides the option to use an externally located database that supports high availability.

Perform the following steps to use MySQL:

  1. Download the MySQL JDBC driver and place it somewhere accessible to NiFi Registry.
  2. Create a database inside MySQL (enter mysql shell using mysql -u root -p).
    CREATE DATABASE nifi_registry;
  3. Create a database user and grant privileges (for remote users, use nifireg'@'<IP-ADDRESS>, or nifireg'@'% for any remote host).
    GRANT ALL PRIVILEGES ON nifi_registry.* TO 'nifireg'@'localhost' IDENTIFIED BY 'changeme';
  4. Configure the database properties in