1、安装mysql，使用percona8 修改配置项添加
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
character-set-server=utf8
collation-server=utf8_unicode_ci
init_connect='SET AUTOCOMMIT=1'

2、重启mysql
systemctl restart mysqld.service
3、创建zabbix数据库
create database zabbix
create user zabbix identified by 'xxxx';
grant all privileges on zabbix.* to zabbix@'localhost';
grant all privileges on zabbix.* to zabbix@'%';
flush privileges;

4、使用zabbix用户连接数据库检查autocommit
提示 autocommit on

4、启动zabbix
systemctl start httpd.service
5、访问zabbix进入配置安装界面
http://192.168.1.xx/zabbix
6、进行到Configure DB connection
 提示：Cannot connect to the database
Error setting auto commit.