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

Zabbix Server cannot connect to mysql DB

    XMLWordPrintable

    Details

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

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              arimdjonoks Artjoms Rimdjonoks
              Reporter:
              yurii Jurijs Klopovskis
              Votes:
              1 Vote for this issue
              Watchers:
              12 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: