When installing CA Process Automation and using MySQL as the backend database which is located on a different server than Process Automation, you may get a message when trying to create the database that simply says "Please check database settings".
If you look into this further by opening the installation.log file (located at /PAM/server/c2o/) you will see a message that states something like:
message from server: "Host 'your.servername.com' is not allowed to connect to this MySQL server"
To resolve this issue, if you are connecting with the root user, then on the MySQL server open the MySQL command line interface and do the following.
Please note enter the full IP address of the server where you are installing CA Process Automation
If you have created another user for this installation, you may use that in the GRANT statement
Enter password: --- your root password here
mysql> use mysql
Database changed
mysql> GRANT ALL ON *.* to root@'xxx.xxx.xxx.xx' IDENTIFIED BY 'your root password';
Query OK, 0 rows affected (0.01 sec)
Then make sure to flush the privileges so it will be immediately applied:
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.02 sec)
Please discuss this with your MySQL DBA before performing any GRANT ALL access.