Zabbix 6.2.1: Mysql upgrade failed

[andreagx]

Hello guys,
I have upgraded Zabbix from 6.0 to 6.2 but the database does not want to update itself
I followed the doc and this link without success.

tail -f /var/log/zabbix/zabbix_server.log
1738:20220822:230635.014 database upgrade failed
1742:20220822:230647.238 Starting Zabbix Server. Zabbix 6.2.1 (revision 2c382976146).
1742:20220822:230647.238 ****** Enabled features ******
1742:20220822:230647.238 SNMP monitoring: YES
1742:20220822:230647.238 IPMI monitoring: YES
1742:20220822:230647.239 Web monitoring: YES
1742:20220822:230647.239 VMware monitoring: YES
1742:20220822:230647.239 SMTP authentication: YES
1742:20220822:230647.239 ODBC: YES
1742:20220822:230647.239 SSH support: YES
1742:20220822:230647.239 IPv6 support: YES
1742:20220822:230647.239 TLS support: YES
1742:20220822:230647.240 ******************************
1742:20220822:230647.240 using configuration file: /etc/zabbix/zabbix_server.conf
1742:20220822:230647.266 current database version (mandatory/optional): 06020000/06010048
1742:20220822:230647.266 required mandatory version: 06020000
1742:20220822:230647.266 starting automatic database upgrade
1742:20220822:230647.266 [Z3005] query failed: [1142] TRIGGER command denied to user 'zabbix_srv'@'localhost' for table 'hosts' [create trigger hosts_insert after insert on hosts
for each row

# cat /var/log/zabbix/zabbix_server.log | grep database
9104:20220822:204912.435 starting automatic database upgrade
9104:20220822:204912.436 database upgrade failed
9108:20220822:204924.683 current database version (mandatory/optional): 06020000/06010048
9108:20220822:204924.683 starting automatic database upgrade

Thank you

[andreagx]

Solved
grant all privileges on zabbix.* to 'zabbix_srv'@'localhost';