Hello, I want to upgrade my Zabbix Server on Centos7 version from 4.02 to 5.0 but after I start the Zabbix Server service the database upgrade process starts and it fails with error:
[1142] REFERENCES command denied to user 'zabbix'@'localhost' for table 'items' [alter table `lld_macro_path` add constraint c_lld_macro_path_1 foreign key (`itemid`) references `items` (`itemid`) on delete cascade]
34780:20221214:133826.827 database upgrade failed
​
How to fix error?
[1142] REFERENCES command denied to user 'zabbix'@'localhost' for table 'items' [alter table `lld_macro_path` add constraint c_lld_macro_path_1 foreign key (`itemid`) references `items` (`itemid`) on delete cascade]
34780:20221214:133826.827 database upgrade failed
​
How to fix error?
Comment