Problem Statement: Error while connecting to Mysql database in process-studio.

PS version: 5.5.0

Error Screenshot:

Resolution:

1. Run the below command on their mysql database
   

SELECT user,host FROM user;

2. It will display the list of Database_User they have and the host_name on which it will be accessible. 
   

3. If you can’t find the IP address of that particular Process-studio machine in this list, it mean you can’t access the DB from that machine.
   
4. To access the DB from that particular machine you have to configure that machine IP address into the DB configuration. To do so, please run below command.
   

GRANT ALL PRIVILEGES ON *.* TO root@my_ip IDENTIFIED BY ‘root_password‘ WITH GRANT OPTION;

5. In this command, first we have tried with private IP address but it didn’t worked, then we have added the public IP address (which present in error screenshot) and it worked perfectly.
   

Refer site: https://confluence.atlassian.com/jirakb/configuring-database-connection-results-in-error-host-xxxxxxx-is-not-allowed-to-connect-to-this-mysql-server-358908249.html