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 C
    • Sprint 64 (May 2020), Sprint 65 (Jun 2020)
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: