-
Problem report
-
Resolution: Duplicate
-
Trivial
-
None
-
3.4.9
-
None
newly installed zabbix 3.4 on centos 8, with newly installed mysql 8. there is no error during the installation process, but launch the zabbix server, I got the error from log zabbix_server.log:
1213:20180517:084357.744 [Z3005] query failed: [1064] 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 [select groupid,name from groups]
I got erro when execute the [select gourpid,name from groups] in mysql, but [select gourpid,name from `groups`] can be executed in mysql, so I wonder whether the compatibility between zabbix-server-mysql and mysql8 no good.
- duplicates
-
ZBXNEXT-4569 "groups" (8.0.2) and "function" (8.0.1) are reserved words since MySQL 8.0
- Closed