Connection to the registry database cannot be established - MYSQL

Document ID : KB000094840
Last Modified Date : 04/05/2018
Show Technical Document Details
Issue:
Cannot connect to the Registry DB from Workstation.

Getting this Error from Workstation when Registry database is MySQL:

Connection to the registry database cannot be established. Please make sure the database is running and the credentials used to connect to the database is valid. Data will not be saved to the database. This will impact your reports. Do you want to continue?  
Environment:
All Supported release and platforms of DevTest.

MySQL Database
Cause:
Did a telnet to the server where MySQL is running, which is where the Registry is running, and the server is not allowing the Workstation to connect to the database. The MySQL is allowing only localhost connections, is not allowing to start Registry with either an IP or hostname in the JDBC URL connection string.   
Resolution:
Allow MySQL instance to accept connections from any host.

NOTE: also make sure the MySQL Instance is case insensitive.