ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Spectrum tomcat MYSQL connection error - "Host <NAME> is not allowed to connect to this MySQL server"


Article ID: 187128


Updated On:


CA Spectrum CA eHealth


OneClick stops working (unable to connect) and the following errors are seen in stdout.log;
ERROR 1130 (HY000): Host '<HOST_NAME>' is not allowed to connect to this MySQL server
        at com.aprisma.util.mysql.SQLScriptRunner.doRunSQLScript(
        at com.aprisma.util.mysql.SQLScriptRunner.runScript(
        ... 34 more


There is a localhost record in the /etc/hosts file


Spectrum 10.x


There's a localhost record in the /etc/hosts file with the same IP address specified as the hostname of the machine. For example: localhost <HOST_NAME>

After commenting out the first line (# localhost), the error message has stopped and OneClick can connect to MySQL.