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.

For a list of supported MySQL databases, see Supported NiFi Registry databases.

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

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:
```
/usr/bin/mysql_secure_installation
```

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