mv /etc/zabbix/zabbix_server.conf{,_back}
mv /etc/zabbix/zabbix_server.conf.rpmnew /etc/zabbix/zabbix_server.conf
vi /etc/zabbix/zabbix_server.conf
DBPassword=your_secret_password
service zabbix-server restart

If still error:
22001:20180503:094957.500 starting automatic database upgrade
22001:20180503:094957.514 [Z3005] query failed: [1091] Can’t DROP ‘id’; check that column/key exists [alter table history_text drop column id]
22001:20180503:094957.514 database upgrade failed

mysql zabbix
alter table history_text add column id BIGINT(20);
alter table history_log add column id BIGINT(20);
service zabbix-server restart