Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-17801

Zabbix Server cannot connect to mysql DB

XMLWordPrintable

    • Team C
    • 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.

            arimdjonoks Artjoms Rimdjonoks
            yurii Jurijs Klopovskis
            Team C
            Votes:
            1 Vote for this issue
            Watchers:
            10 Start watching this issue

              Created:
              Updated:
              Resolved: