A DataMiner running 9.6 CU9 has a MySQL Central Database configured and is currently showing the error \"Central database not reachable\". The database has been migrated to a new machine using the MySQL Workbench Migration Wizard.
The credentials were double-checked and it is possible to query the DB via MySQL Workbench:
The same can be done from within Cube:
Checking the SLDBConnection.txt log shows the following:
I was able to find the same issue reported in task 125205. In this task, the issue was tracked to the character encoding, and changing it from latin1 to UTF-8 corrected the issue.
In my case, checking the encoding shows UTF-8:
Restarting the DataMiner Agent does not clear the error.
What further checks can be performed to find the root cause of the error?
What known root causes for this error could be at play here?
Thank you for your help.