[ZBX-14704] zabbix3+ mysql8 Created: 2018 Aug 09  Updated: 2018 Aug 09  Resolved: 2018 Aug 09

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: None
Affects Version/s: 3.4.12
Fix Version/s: None

Type: Incident report Priority: Critical
Reporter: Aaron Bape Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

zabbix3.4.12 mysql8 Linux7（CentOS）

Attachments: PNG File zabbix1.png     PNG File zabbix2.png    
Issue Links:
Duplicate
is duplicated by ZBXNEXT-4569 "groups" (8.0.2) and "function" (8.0.... Closed

 Description   

when i in mysql.schema=zabbix use 'desc groups'  

err: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

desc zabbix.groups   

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)

this is normal

i feel 'groups'(this is key word in mysql8)

how can i resolve thie problem?  

 Comments   
Comment by Alexey Pustovalov [ 2018 Aug 09 ]

Zabbix supports MySQL 8 since 4.0 version only.

Generated at Sat Apr 20 12:38:39 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.