Details
-
Type:
Problem report
-
Status: Closed
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 4.0.21rc1, 4.4.9rc1, 5.0.1rc1
-
Fix Version/s: 4.0.22rc1, 4.4.10rc1, 5.0.2rc1, 5.2.0alpha1, 5.2 (plan)
-
Component/s: Proxy (P), Server (S)
-
Labels:None
-
Team:Team C
-
Sprint:Sprint 64 (May 2020), Sprint 65 (Jun 2020)
-
Story Points:0.5
Description
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.