-
Documentation task
-
Resolution: Fixed
-
Trivial
-
None
-
None
-
Sprint 61 (Feb 2020)
-
0.125
We need to update our documentation, because the section is labeled as MySQL, but actually it works only with MariaDB (5.5 - 10.3), not with the newest MySQL 8
If you will try to execute steps from our official documentation on MySQL 8, you will get an error:
Server version: 8.0.19 MySQL Community Server - GPL Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> create database zabbix character set utf8 collate utf8_bin; Query OK, 1 row affected, 2 warnings (0.01 sec) mysql> grant all privileges on zabbix.* to zabbix@localhost identified by 'zabbix'; 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 'identified by 'zabbix'' at line 1
Syntax which works on both MariaDB and MySQL 8 - separate this in two commands
mysql> create user 'zabbix'@'localhost' identified by 'VeryComplex1!'; Query OK, 0 rows affected (0.01 sec) mysql> grant all privileges on zabbix.* to 'zabbix'@'localhost'; Query OK, 0 rows affected (0.01 sec)
I suggest changing this from 2 lines to 3 lines, or adding separate section or at least notes for MySQL 8. This DB version is used more each day, and it is the recommended version by Oracle (if Oracles MySQL branch is chosen)
