Help with Zabbix after Ubuntu auto upgrade MYSQL

[anderklein]

Hello, my zabbix 5.2.1 is operating normally, but my Ubuntu automatically updated the Mysql database and after that I have a warning on the Dashboard saying:

Incorrect default charset for Zabbix database: "utf8mb3" instead "UTF8".

Surely this happened because something changed in the Mysql version, I did a short google search and didn't find anything concrete about this problem, is there an easy way to solve this problem and this warning disappears from zabbix?

[cyber]

https://www.zabbix.com/documentation...all/db_scripts

MySQL

Character sets utf8 (aka utf8mb3) and utf8mb4 are supported (with utf8_bin and utf8mb4_bin collation respectively) for Zabbix server/proxy to work properly with MySQL database. It is recommended to use utf8mb4 for new installations.

I am pretty sure you can find something about collation and changing it in forum...

[Markku]

Hello, my zabbix 5.2.1

https://www.zabbix.com/documentation...all/db_scripts (Zabbix 5.2 database information page) says:

Character set utf8 and utf8_bin collation is required for Zabbix server/proxy to work properly with MySQL database.

I would recommend upgrading from that old unsupported Zabbix version to 6.0.12 or 6.2.6. Make good backups, and you can try the new Zabbix versions with a copy of the current database.

Markku