centos9镜像下载:
https://mirror.stream.centos.org/9-stream/BaseOS/x86_64/iso/ 官方镜像源https://mirrors.tuna.tsinghua.edu.cn/centos-stream/9-stream/BaseOS/x86_64/iso/清华大学镜像源https://mirrors.aliyun.com/centos-stream/9-stream/BaseOS/x86_64/iso/ 阿里云镜像源

# 关闭防火墙(测试环境)
sudo systemctl stop firewalld && sudo systemctl disable firewalld
临时关闭 SELinux
sudo setenforce 0
sudo sed -i 's/SELINUX=enforcing/SELINUX=permissive/' /etc/selinux/config
安装基础工具
sudo dnf install -y wget vim
zabbix7.4官网安装部署手册
https://www.zabbix.com/cn/download.html?zabbix=7.4&os_distribution=centos&os_version=9&components=server_frontend_agent&db=mysql&ws=nginx
sudo rpm -Uvh https://repo.zabbix.com/zabbix/7.4/rhel/9/x86_64/zabbix-release-latest-7.4.el9.noarch.rpm sudo dnf clean all
sudo dnf install -y zabbix-server-mysql zabbix-web-mysql zabbix-nginx-conf zabbix-sql-scripts zabbix-selinux-policy zabbix-agent
sudo dnf install -y mariadb-server
sudo systemctl enable --now mariadb
sudo mysql_secure_installation 一路y删除db数据库的匿名登录,删除测试账户。
mysql -uroot -p
执行 SQL:
CREATE DATABASE zabbix CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
CREATE USER zabbix@localhost IDENTIFIED BY 'YourPassword'; # 替换密码
GRANT ALL PRIVILEGES ON zabbix.* TO zabbix@localhost;
set global log_bin_trust_function_creators = 1;
FLUSH PRIVILEGES;
EXIT;
mysql>show global variables like 'log_bin_trust_function_creators';
若返回值为 1,则表示生效。
zcat /usr/share/doc/zabbix-sql-scripts/mysql/server.sql.gz | mysql -uzabbix -p zabbix
安全建议:Zabbix 数据库导入完成后,建议立即关闭该选项(设置为 0),避免潜在的安全风险:
mysql -uroot -p
password(输入root账号)
mysql> set global log_bin_trust_function_creators = 0;
mysql> quit;
systemctl restart mariadb 重启数据库后会恢复默认值(0)
