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