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

MySQL instructions do not work for MySQL 8

    XMLWordPrintable

    Details

    • Type: Documentation task
    • Status: Closed
    • Priority: Trivial
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.0 (plan)
    • Component/s: Documentation (D)
    • Labels:
      None
    • Team:
      Team I
    • Sprint:
      Sprint 61 (Feb 2020)
    • Story Points:
      0.125

      Description

      We need to update our documentation, because the section is labeled as MySQL, but actually it works only with MariaDB (5.5 - 10.3), not with the newest MySQL 8
      If you will try to execute steps from our official documentation on MySQL 8, you will get an error:

      Server version: 8.0.19 MySQL Community Server - GPL
      Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
      Oracle is a registered trademark of Oracle Corporation and/or its
      affiliates. Other names may be trademarks of their respective
      owners.
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
      
      mysql> create database zabbix character set utf8 collate utf8_bin;
      Query OK, 1 row affected, 2 warnings (0.01 sec)
      
      mysql> grant all privileges on zabbix.* to [email protected] identified by 'zabbix';
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by 'zabbix'' at line 1
      

      Syntax which works on both MariaDB and MySQL 8 - separate this in two commands

      mysql> create user 'zabbix'@'localhost' identified by 'VeryComplex1!';
      Query OK, 0 rows affected (0.01 sec)
      
      mysql> grant all privileges on zabbix.* to 'zabbix'@'localhost';
      Query OK, 0 rows affected (0.01 sec)
      

      I suggest changing this from 2 lines to 3 lines, or adding separate section or at least notes for MySQL 8. This DB version is used more each day, and it is the recommended version by Oracle (if Oracles MySQL branch is chosen)

        Attachments

          Activity

            People

            Assignee:
            yurii Jurijs Klopovskis
            Reporter:
            kaspars.mednis Kaspars Mednis
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: