mysql> create database zabbix character set utf8mb4 collate utf8mb4_bin; mysql> create user zabbix@localhost identified by 'password'; mysql> grant all privileges on zabbix.* to zabbix@localhost; mysql> set global log_bin_trust_function_creators = 1; mysql> quit;
# Import initial schema and data. ~]# zcat /usr/share/zabbix/sql-scripts/mysql/server.sql.gz | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix
# Disable log_bin_trust_function_creators option after importing database schema. mysql> set global log_bin_trust_function_creators = 0; mysql> quit;
Configure the database for Zabbix server.
~]# cat >>/etc/zabbix/zabbix_server.conf <<EOF # The following is added for Zabbix DBPassword=password EOF