zabbix 3.0 升级 5.0 数据库表遇到的问题

1.配数据库的时候会有报错，因为Zabbix3与5.0的数据库表字符集与排序规则不一致，所以会报错

2.解决方法

1.首先修改数据库默认字符集及字符校验集
ALTER DATABASE `zabbix` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
2.然后修改表
#找出字符检验集不对的表,所以报错的表都会被找出来
SELECT CONCAT("ALTER TABLE ", TABLE_NAME," CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;") AS ExecuteTheString FROM information_schema.`COLUMNS` WHERE table_schema ="zabbix" AND COLLATION_NAME ="utf8_general_ci";
3. 复制输出结果，并执行
 ALTER TABLE history_log CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;