Mysql 8.x compatibility

[Kika]

Hello,


I just installed the Zabbix 3.4.13 and I found mysql errors. For example:

• Error in query [SELECT g.groupid,g.name FROM groups g WHERE EXISTS (SELECT NULL FROM hosts h,hosts_groups hg WHERE hg.hostid=h.hostid AND h.status='0' AND g.groupid=hg.groupid)] [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 'groups g WHERE EXISTS (SELECT NULL FROM hosts h,hosts_groups hg WHERE hg.hostid=' at line 1]

The problem is the escaping because the name of the table `groups` is a reserved word from mysql 8.0.2. (https://dev.mysql.com/doc/refman/8.0/en/keywords.html)


I also found a problem in the installation process 2.C step (https://www.zabbix.com/download?zabb...nic&db=MySQL):

grant all privileges on zabbix.* to zabbix@localhost identified by 'password';

This is doesn't works anymore, the correct solution is:

CREATE USER 'zabbix'@'localhost' IDENTIFIED BY 'password'; GRANT ALL ON zabbix.* TO 'zabbix'@'localhost'; flush privileges;

[Atsushi]

Because it conflicts with the keyword that became a new reserved word in MySQL 8.0, I think that MySQL 8.0 can not be used in the back end for Zabbix 3.4.13.
Please use a previous version such as MySQL 5.7.

Support for MySQL 8.0 will be Zabbix 4.0 or later.

ZBX-12451 : "groups" (8.0.2) and "function" (8.0.1) are reserved words since MySQL 8.0

https://support.zabbix.com/browse/ZBX-12451

Release Notes for Zabbix 4.0.0beta1

https://www.zabbix.com/rn/rn4.0.0beta1

[kloczek]

And AFAIK MySQL 8.x support will be not backported to 3.4.
Of course zabbix 4.0.x still will be possible to use with MySQL 5.7.