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.
For a list of supported MySQL databases, see Supported NiFi Registry databases.
- Log in to the node on which you want to install NiFi Registry.
Install MySQL and the MySQL community server, and start the MySQL
yum localinstall \ https://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm yum install mysql-community-server systemctl start mysqld.service
Obtain the randomly generated MySQL root password:
grep 'A temporary password is generated for root@localhost' \ /var/log/mysqld.log |tail -1
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:
Once you have completed the MySQL installation, configure it for use with NiFi Registry.