Installing and configuring MySQL

Learn how to install and configure MySQL for Edge Flow Manager.

For supported database versions, see System Requirements for Edge Flow Manager.

Install MySQL

If you want to use PostgreSQL or MariaDB instead of MySQL, you may skip these steps. See the instructions for PostgreSQL and MariaDB in the respective sections.

Log in to the machine on which you want to install MySQL to use for the Edge Flow Manager server.
Install MySQL and the MySQL community server, and start the MySQL service. For installation instructions, check Installing and Upgrading MySQL.

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
```
Download the MySQL JDBC Connector and place it in the Edge Flow Manager lib directory: /path/to/efm-1.4.0/lib/.
note
The folder is created when Edge Flow Manager is being installed.
Download the MySQL database driver from MySQL Community Downloads.
note
The above link redirects you to the latest version of the driver. You need to choose the right driver version that fits your DB setup.
It is recommended to select the Platform Independent offering, download one of the archives, extract, and then copy the connector JAR to the lib directory.

Configure MySQL for use by Edge Flow Manager

Launch the MySQL shell:
```
mysql -u root -p
```
Create the database for the Edge Flow Manager service to use:
```
CREATE DATABASE efm CHARACTER SET latin1;
```
Create the efm user account, replacing the final IDENTIFIED BY string with your password:
```
CREATE USER 'efm'@'%' IDENTIFIED BY 'efmPassword';
```

Assign privileges to the efm account:

GRANT ALL PRIVILEGES ON efm.* TO 'efm'@'%';

Commit the operation:
```
FLUSH PRIVILEGES;
```

Configure the Edge Flow Manager database properties

Configure the database properties in the efm.properties file:
```
efm.db.url=jdbc:mysql://localhost:3306/efm
efm.db.driverClass=com.mysql.cj.jdbc.Driver
efm.db.username=efm
efm.db.password=efmPassword
```
The URL should match the host and port of the machine running MySQL. Username and password at the DB side and in the efm.properties file must match.