Import the initial schema and data, and you will be prompted to enter a newly created password.
# zcat /usr/share/zabbix-sql-scripts/mysql/server.sql.gz | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix
disable log_bin_trust_function_creators option after importing database schema.
# mysql -uroot -p
password
mysql> set global log_bin_trust_function_creators = 0;
mysql> quit;
The above is the command used to import the initial schema and data of the Zabbix server in a MySQL database, and it performs the following steps:
Import the initial schema and data, and you will be prompted to enter a newly created password.
This line is a description that you will need to enter the password for the Zabbix user that you created earlier before importing the database schema.
zcat /usr/share/zabbix-sql-scripts/mysql/server.sql.gz | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix
This line is a shell command that indicates that you use the zcat command to unzip usr share zabbix-sql-scripts mysql serversql.GZ file and pass its contents as a SQL statement to the MySQL command, log in to the Zabbix database with the Zabbix user and password, and specify the default character set as UTF8MB4. This allows you to create the required tables and indexes in the Zabbix database.
disable log_bin_trust_function_creators option after importing database schema.
This line is a description that after you import the database schema, you need to disable the Log Bin Trust Function Creators option, which is a MySQL global variable that controls whether non-superusers are allowed to create deterministic triggers. If binary logging is enabled, this option defaults to 0, which means it is not allowed, but Zabbix needs to create a deterministic trigger, so you need to set it to 1 before importing the mode, and then back to 0 after the import mode to avoid security risks.
mysql -uroot -p
This line is a shell command that indicates logging in to the MySQL database with the root user and password.
password
This line is your input and represents the password you entered for the root user.
mysql> set global log_bin_trust_function_creators = 0;
This line is a SQL statement that disables the ability for non-superusers to create deterministic triggers by setting the global variable Log bin Trust Function Creators to a value of 0 in the MySQL database.
mysql> quit;
This line is a SQL statement that indicates exiting the MySQL database.
The above is what I have explained to you about the meaning of each line you entered**, I hope it will be helpful to you. If it helps, like, follow, comment