Arch Linux Connecting to mysql UTF8 Errors.

[ibarton]

I have installled and configured Zabbix as per the wiki. I am getting the following errors when trying to connect to the database:

Jul 27 14:36:41 blacky.wilkesley.net zabbix_server[14986]: cannot set MySQL character set to "utf8"
Jul 27 14:36:41 blacky.wilkesley.net zabbix_server[14986]: database is down: reconnecting in 10 seconds

I dropped that database and recreated it using the latest script from Zabbix with the same result:

mysql> create database zabbix character set utf8 collate utf8_bin;

Here are the relevant bits of my.cnf;

[client]
#password       = your_password
port            = 3306
socket          = /run/mysqld/mysqld.sock
default-character-set = utf8mb4

[mysqld]
collation_server = utf8mb4_unicode_ci
character_set_client = utf8mb4
character_set_server = utf8mb4

[mysql]
no-auto-rehash
default-character-set = utf8mb4

I can connect to the database using the mysql cli without any errors.

[ibarton]

Solved

Somehow the setup hadn't put the password for the mysql server in zabbix_server.conf!