c.Create an initial database.
Product Brochure. make sure you h**e database server up and running.
Run the following on the database host.
# mysql -uroot -p
password
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;
mysql> quit;
What does the above information mean?
These are used to create and configure a database and user named Zabbix in a MySQL database. Specifically, each line ** does the following:
# mysql -uroot -p: This is a note that indicates that you log in to the MySQL database as root in the terminal and enter your password.
password: This is the password of the root user and is used to verify identity.
mysql> create database zabbix character set utf8mb4 collate utf8mb4_bin;: This is a SQL statement that creates a database named Zabbix in a MySQL database and specifies that its character set is UTF8MB4 and the collation is UTF8MB4 Bin.
mysql> create user zabbix@localhost identified by 'password';: This is a SQL statement that creates a user named Zabbix in the MySQL database and specifies its password as Password. The user can only log in from localhost.
mysql> grant all privileges on zabbix.* to zabbix@localhost;: This is to grant a Zabbix user permission in a MySQL database to all tables in a Zabbix database (Zabbix.).*) to all privileges.
mysql> set global log_bin_trust_function_creators = 1;: This is a SQL statement that sets a global variable (Global) Log bin Trust Function Creators with a value of 1 in a MySQL database. This variable is used to control whether or not to allow the creation or modification of stored functions, and if set to 1, super privileges are not required.
mysql> quit;: This is the command to exit the mysql database.