-
Problem report
-
Resolution: Fixed
-
Critical
-
4.0.21rc1, 4.4.9rc1, 5.0.1rc1
-
None
-
Sprint 64 (May 2020), Sprint 65 (Jun 2020)
-
0.5
Zabbix Server fails to start on CentOS 8 with mysql server with the following error.
[Z3001] connection to database 'zabbix' failed: [1227] Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation
Presumably caused by 90d0172d5d commit.
Install zabbix from packages to reproduce.
https://www.zabbix.com/download?zabbix=4.0&os_distribution=centos&os_version=8&db=mysql&ws=apache
Use mysql server that comes with the distribution.
dnf install mysql-server
Tested with SELinux and firewalld disabled.