To Create the ATNA Repository Database

Before You Begin

Complete To Create the PIX/PDQ Database Tables.

1. Create a schema in your MySQL environment named arrdb.

2. Create a user for the ATNA tables by running the following command:

   grant create, alter, drop, delete, index, insert, select, trigger, update, create routine, alter routine, execute on arrdb.* to username identified by 'password';

   Substitute an actual user name and password for username and password in the above command. The default user name and password are both arr.

3. Navigate to the directory to which you downloaded the PIX/PDQ projects during installation, and then navigate to the SQL folder.

4. Log in to the arrdb schema as the ATNA user you just created.

5. From a SQL editor, run the arrdb.sql file against the arrdb schema.

6. To Create the PIX/PDQ Checkpoint Database.