sudo -s
INSTALL MYSQL
sudo apt update
sudo apt install mysql-server
sudo systemctl start mysql.service
CONFIGURE MYSQL
sudo mysql
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘password‘;
exit
sudo mysql_secure_installation
mysql -u root -p
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH auth_socket;
INSALL ZABBIX REPOSITORY
(UBUNTU 20)
wget https://repo.zabbix.com/zabbix/6.4/ubuntu/pool/main/z/zabbix-release/zabbix-release_latest+ubuntu20.04_all.deb
dpkg -i zabbix-release_latest+ubuntu20.04_all.deb
apt update
(UBUNTU 22)
wget https://repo.zabbix.com/zabbix/6.4/ubuntu/pool/main/z/zabbix-release/zabbix-release_latest+ubuntu22.04_all.deb
dpkg -i zabbix-release_latest+ubuntu22.04_all.deb
apt update
(UBUNTU 24)
wget https://repo.zabbix.com/zabbix/6.4/ubuntu/pool/main/z/zabbix-release/zabbix-release_latest+ubuntu24.04_all.deb
dpkg -i zabbix-release_latest+ubuntu24.04_all.deb
apt update
Install Zabbix proxy
apt install zabbix-proxy-mysql zabbix-sql-scripts
Create initial database
Make sure you have database server up and running.
Run the following on your database host.
mysql -uroot -p
password
mysql> create database zabbix_proxy character set utf8mb4 collate utf8mb4_bin;
mysql> create user zabbix@localhost identified by 'password';
mysql> grant all privileges on zabbix_proxy.* to zabbix@localhost;
mysql> set global log_bin_trust_function_creators = 1;
mysql> quit;
password
mysql> create database zabbix_proxy character set utf8mb4 collate utf8mb4_bin;
mysql> create user zabbix@localhost identified by 'password';
mysql> grant all privileges on zabbix_proxy.* to zabbix@localhost;
mysql> set global log_bin_trust_function_creators = 1;
mysql> quit;
On Zabbix server host import initial schema and data. You will be prompted to enter your newly created password.
cat /usr/share/zabbix-sql-scripts/mysql/proxy.sql | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix_proxy
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;
password
mysql> set global log_bin_trust_function_creators = 0;
mysql> quit;
Configure the database for Zabbix proxy
Edit file /etc/zabbix/zabbix_proxy.conf
DBPassword=password
Start Zabbix proxy process
Start Zabbix proxy process and make it start at system boot.
systemctl restart zabbix-proxy
systemctl enable zabbix-proxy
systemctl enable zabbix-proxy
