Cloudera Docs

Install MySQL

Learn how to install a MySQL external database for NiFi Registry.

If you have already installed a PostgreSQL database, you may skip these steps. Both databases are not required.

  1. Log in to the node on which you want to install NiFi Registry.
  2. Install MySQL and the MySQL community server, and start the MySQL service: 
    yum localinstall \
https://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

yum install mysql-community-server

systemctl start mysqld.service
  3. Obtain the randomly generated MySQL root password: 
    grep 'A temporary password is generated for root@localhost' \
/var/log/mysqld.log |tail -1
  4. Reset the MySQL root password. Enter the following command. You are prompted for the password you obtained in the previous step. MySQL then asks you to change the password: 
    /usr/bin/mysql_secure_installation

Once you have completed the MySQL installation, configure it for use with NiFi Registry.