Symptoms
MySQL DB related task fails with the following error:
Can't connect to MySQL database service on XX.XX.XX.XX:XXXX. Service specific error message: Can't initialize character set latin1 (path: /usr/share/mysql/charsets/).
Cause
MySQL Service Controller misconfiguration on MN.
Resolution
Set
default-character-set
variable value tolatin1
inmy.cnf
file:[root@osscore ~]# cat /etc/my.cnf ... [client] default-character-set=latin1
Restart PEM and PAU services:
[root@osscore ~]# service pem stop [root@osscore ~]# service pau stop [root@osscore ~]# service pau start [root@osscore ~]# service pem start