File README-DB.SUSE of Package zabbix

c. Create initial database
--------------------------
Make sure you have database server up and running.

Run the following on your database host.
# mysql -uroot -p
password
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;

On Zabbix server host import initial schema and data. You will be prompted to enter your newly created password.
# zcat /usr/share/zabbix-sql-scripts/mysql/server.sql.gz | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix

Under openSUSE:
cat /usr/share/doc/packages/zabbix-server/mysql/schema.sql | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix
cat /usr/share/doc/packages/zabbix-server/mysql/images.sql | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix
cat /usr/share/doc/packages/zabbix-server/mysql/data.sql | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix

Disable log_bin_trust_function_creators option after importing database schema.
# mysql -uroot -p
password
mysql> set global log_bin_trust_function_creators = 0;
mysql> quit;


d. Configure the database for Zabbix server
-------------------------------------------
Edit file /etc/zabbix/zabbix_server.conf
DBPassword=password


e. Start Zabbix server and agent processes
------------------------------------------
Start Zabbix server and agent processes and make it start at system boot.
# systemctl restart zabbix-server zabbix-agent httpd php-fpm
# systemctl enable zabbix-server zabbix-agent httpd php-fpm


f. Open Zabbix UI web page
--------------------------
The default URL for Zabbix UI when using Apache web server is http://host/zabbix