CA Risk Authentication Windows Installation Guide › Pre-Installation Tasks › Configure Database Server › Configure MySQL Server

Configure MySQL Server

This section provides the following configuration information for MySQL.

Follow these steps:

1. To check whether your MySQL installation supports InnoDB storage engine, use the SHOW ENGINES command.

   Note: CA Risk Authentication uses the InnoDB storage engine of MySQL. If the output of this command shows that InnoDB is not supported, enable support for InnoDB. For information to enable support for InnoDB, see the MySQL Documentation.

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

   Note: For more information, see the MySQL Documentation.

3. To create a database, perform the following steps:
   1. Open a MySQL command window.
   2. To create the database schema, run the following command:

      CREATE SCHEMA '<schema-name>' DEFAULT CHARACTER SET utf8;
      

   3. To create the database user, run the following command:

      CREATE USER '<user-name>' identified by '<user-password>';
      

4. Create a user with the following criteria:
   1. Create a user (recommended name is arcotuser) in the new database arcotdb.
   2. Grant the following privileges to the user:
      • Object rights:
      • SELECT
      • INSERT
      • UPDATE
      • DELETE
      • EXECUTE
      • DDL rights:
      • CREATE
      • ALTER
      • CREATE ROUTINE
      • ALTER ROUTINE
      • DROP
      • Other rights:
      • GRANT OPTION