Zabbix5.0 导入数据库时报错ERROR 1071 (42000) at line 165: Specified key was too long

解决办法

现象：使用MySQL和Mariadb使用zcat /usr/share/doc/zabbix-server-mysql-5.0.*/create.sql.gz|mysql -uroot -p zabbix导入数据库时报错：ERROR 1071 (42000) at line 165: Specified key was too long; max key length is 767 bytes

# 将默认的字符编码改成utf8create database zabbix character set utf8mb4 collate utf8mb4_bin;create database zabbix character set utf8 collate utf8_bin;  #使用这种