Process Automation: Error installing Process Automation to MySQL Database Not Allowed to connect to this MySQL Database

Products

• CA Process Automation Base

Issue/Introduction

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"

Environment

Release: ITPASA99000-4.3-Process Automation-Add On License for-CA Server Automation
Component:

Resolution

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)

Additional Information

Please discuss this with your MySQL DBA before performing any GRANT ALL access.