CA RiskMinder UNIX Installation Guide › Preparing for Installation › Configuring Database Server › Configuring MySQL

Configuring MySQL

To set up the MySQL database, perform the following steps:

Note: See the MySQL documentation for information about performing the following tasks.

• Enabling Support for the InnoDB Transaction Engine
• Setting the lower_case_table_names Variable
• Creating a New Database
• Creating a Database User

Enabling Support for the InnoDB Transaction Engine

RiskMinder uses the InnoDB storage engine of MySQL. To check whether your MySQL installation supports this storage engine, use the SHOW ENGINES command. If the output of this command shows that InnoDB is not supported, enable support for InnoDB.

Note: For information about the procedure to enable support for InnoDB, see the MySQL documentation.

Setting the lower_case_table_names Variable

If you are running MySQL on a non-Windows platform, set the lower_case_table_names variable to 1.

Note: For detailed information about this variable, see the MySQL documentation.