zabbix 无法选择mysql_ZABBIX bug 在mysql8 上无法正常使用

mysql> use zabbix

Database changed

mysql> desc groups;

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 'groups' at line 1

mysql> desc zabbix.groups;

+----------+---------------------+------+-----+---------+-------+

| Field    | Type                | Null | Key | Default | Extra |

+----------+---------------------+------+-----+---------+-------+

| groupid  | bigint(20) unsigned | NO   | PRI | NULL    |       |

| name     | varchar(255)        | NO   | MUL |         |       |

| internal | int(11)             | NO   |     | 0       |       |

| flags    | int(11)             | NO   |     | 0       |       |

+----------+---------------------+------+-----+---------+-------+

4 rows in set (0.00 sec)

原因分析 应该是groups在MySQL8上是关键字 并且被Oracle 隐藏 其他表均能正常使用

已经提交zabbix.support

support.zabbix  ：只有zabbix4+ 才能支持mysql8

大兄弟们 记得上mysql8 zabbix要上4.X