Incorrect charset for MySQL database "utf8mb3" instead "UTF8"

ZABBIX监控使用的数据库版本MySQL 8.0.27，应安全部门要求升级到MySQL 8.0.29。

 

升级到新版本WEB端有如下警告：Incorrect charset for MySQL database "utf8mb3" instead "UTF8"

 

MySQL 8.0版本UTF8等于UTF8MB3。

mysql> create database zabbix4 character set utf8;
Query OK, 1 row affected, 1 warning (0.01 sec)

mysql> show warnings;
+---------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level   | Code | Message                                                                                                                                                                     |
+---------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Warning | 3719 | 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. |
+---------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

 

Incorrect charset for MySQL database "utf8mb3" instead "UTF8"对ZABBIX监控目前无影响，暂时忽略。

 

参考：https://support.zabbix.com/browse/ZBXNEXT-7694