CA Strong Authentication Windows Installation Guide › How to Configure the Database Server › MySQL Database Configuration

MySQL Database Configuration

This section provides the following configuration information for MySQL database.

CA Strong Authentication uses the InnoDB storage engine of MySQL. To check whether this storage engine is supported by your MySQL installation, 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 MySQL documentation.

1. Open a MySQL command window.
2. Run the following command to create the database schema:

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

3. Run the following command to create the database user:

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

4. Create a user (recommended name is arcotuser) in the new database arcotdb.
5. Grant the following privileges to the user:

   Objects rights:

   SELECT
   

   INSERT
   

   UPDATE
   

   DELETE
   

   EXECUTE
   

   DDL rights:

   CREATE
   

   ALTER
   

   CREATE ROUTINE
   

   ALTER ROUTINE
   

   DROP
   

   Other rights:

   GRANT OPTION