• PAM Appliance is a black box. The MYSQL DB is not installed in PAM. It has to be created in your own environment, in a DB server.
• To prepare it, it is only necessary to create a new database accordingly. No tables need be created. 
• When PAM accesses the new MySQL Database for the very first time, it will automatically create the tables.

Follow the below steps:

1) Install MySQL in a server.

Note: Ensure port 3306 is open between PAM and the MySQL Server.

2) Connect to MySQL in the external server and create the database. 

mysql> create database <Database Name>;

3) Grant privileges to the db user that is going to connect to the database from PAM:

mysql> GRANT ALL PRIVILEGES ON *.* TO [email protected]'<PAM Hostname>' IDENTIFIED BY '<your password>' WITH GRANT OPTION;

[OR mysql>GRANT ALL PRIVILEGES ON *.* TO [email protected]'%' IDENTIFIED BY '<your password>' WITH GRANT OPTION;]

mysql> FLUSH PRIVILEGES;

4) Login to PAM and go to:

• 2.x:  Config>>Logs

• 3.x: Configuration>>Logs>>External Log Server

• Configure the External Log Server by checking the "Enable logging to the external server" checkbox.
• Enter the server IP where the DB is connected, port and credentials.

5) Click on Update. You should get the following message:

6) Connect to your database and verify that tables get created:

mysql>use <Database Name>; 

mysql>show tables;

Eg: my <Database Name> is logpam