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

  1. Set default-character-set variable value to latin1 in my.cnf file:

    [root@osscore ~]# cat /etc/my.cnf
...
[client]
default-character-set=latin1

  2. 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

Internal content