Configuration Guides › Directory Configuration Guide › MySQL Server › Configure MySQL Data Stores › How to Store Key Information in MySQL › Create the Key Store Schema

Create the Key Store Schema

You create the key store schema so the MySQL database can store key information.

To create the key store schema

1. Navigate to path\MySQL.

   path

   Specifies the path to the schema files extracted from the tier 2 directory zip.

2. Open the following file in a text editor:

   sm_mysql_ps.sql

3. Locate the following lines:

   DROP FUNCTION IF EXISTS `databaseName`.`getdate` $$
   CREATE FUNCTION `databaseName`.`getdate` () RETURNS DATE
   

4. Replace each instance of 'databaseName' with the name of the database functioning as the key store.

   Example: If the name of the database is smkeystore, the required update appears as follows:

   DROP FUNCTION IF EXISTS `smkeystore`.`getdate` $$
   CREATE FUNCTION `smkeystore`.`getdate` () RETURNS DATE
   

5. Copy the contents of the entire file.
6. Paste the file contents into a query and execute the query.

   The key store schema is created.