Unable to determine current Zabbix database version: the table "dbversion" was not found

Question

OS: Debian10 App: Zabbix4.0 Installed app:Mariadb,Apache2,php

I got this error after I input this command in mysql.

create database zabbix character set utf8 collate utf8_bin;

and when I tried to restart zabbix-server,

zabbix-server.service: Can't open PID file /run/zabbix/zabbix_server..

Any idea regarding this error?

Answer 1

The problem with Zabbix database can be solved with the following command:

sudo zcat /usr/share/doc/zabbix-server-mysql*/create.sql.gz | mysql -uzabbix -p zabbix_db

where zabbix_db is your Zabbix database name in which you named in MySQL configuration.

Then you need to restart your zabbix-server.