-
Documentation task
-
Resolution: Unresolved
-
Trivial
-
None
-
6.0.16
-
None
The https://www.zabbix.com/download wizard was improved at least 3x better during the last years.
One additional proposal to make it even better is to respect the SQL syntax - SQL commands ALL in CAPITAL letters, just like here:
https://www.dataquest.io/blog/sql-commands/
One of Zabbix official documentation pages is already using this excellent syntax:
https://www.zabbix.com/documentation/6.4/en/manual/appendix/install/db_encrypt/mysql
I would propose to convert the https://www.zabbix.com/download into a same level of readability.
For example:
mysql> create database zabbix character set utf8mb4 collate utf8mb4_bin;
mysql> create user zabbix@localhost identified by 'password';
mysql> grant all privileges on zabbix.* to zabbix@localhost;
mysql> set global log_bin_trust_function_creators = 1;
Must be:
mysql> CREATE DATABASE zabbix CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; mysql> CREATE USER zabbix@localhost IDENTIFIED BY 'password'; mysql> GRANT ALL PRIVILEGES ON zabbix.* TO zabbix@localhost; mysql> SET GLOBAL log_bin_trust_function_creators = 1;
Maybe this would be even better (as it allows to use mouse to perform a double click to alter username or host name):
mysql> CREATE DATABASE zabbix CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; mysql> CREATE USER 'zabbix'@'localhost' IDENTIFIED BY 'password'; mysql> GRANT ALL PRIVILEGES ON zabbix.* TO 'zabbix'@'localhost'; mysql> SET GLOBAL log_bin_trust_function_creators = 1;