Install MySQL¶

Overview¶

FMR requires a SQL database for storage of content, settings and audit records.

MySQL 8.0 is a good choice for light production and non-production use cases and will be used as the reference in the rest of this guide.

Oracle and SQL Server are also supported.

Get MySQL¶

Download and install the MySQL 8.0 Community edition.

Create a database schema¶

Create a database schema and a service account for the FMR installation to use:

$ mysql -u root -p 
mysql> CREATE DATABASE fmr;
mysql> CREATE USER 'fmruser'@'%' IDENTIFIED BY 'new_password';
mysql> GRANT ALL ON fmr.* TO 'fmruser'@'%';

Download and install the MySQL Java connector¶

FMR does not ship with the MySQL Java connector. Refer to the guidance for details of how to download and install it.