rpm -Uvh https://repo.zabbix.com/zabbix/6.4/rhel/9/x86_64/zabbix-release-6.4-1.el9.noarch.rpm
dnf clean all && dnf makecache

dnf install zabbix-server-mysql zabbix-web-mysql zabbix-nginx-conf zabbix-sql-scripts zabbix-selinux-policy zabbix-agent

yum install centos-release-scl -y

mysql安装包下载(适用于Rocky-Linux9.1,其他版本请自行测试)：https://share.weiyun.com/lXsCGb4J 密码：9usdxr

#!/bin/bash
# **********************************************************
# * Author        : 青菜浪人
# * Create time   : 2023-05
# * Filename      : mysql_install.sh
# * Description   : mysql安装脚本
# **********************************************************
#卸载自带的mariadb
rpm -e --nodeps `rpm -qa|grep mariadb`
rpm -e --nodeps `rpm -qa|grep MySQL`
rpm -e --nodeps `rpm -qa|grep mysql`

rpm_list=(
    mysql-community-client-plugins-8.0.33-1.el9.x86_64.rpm
    mysql-community-libs-8.0.33-1.el9.x86_64.rpm
    mysql-community-common-8.0.33-1.el9.x86_64.rpm
    mysql-community-libs-8.0.33-1.el9.x86_64.rpm
    mysql-community-client-8.0.33-1.el9.x86_64.rpm
    mysql-community-icu-data-files-8.0.33-1.el9.x86_64.rpm
    mysql-community-server-8.0.33-1.el9.x86_64.rpm

)
for install_rpm in ${rpm_list[@]}
do
		rpm -ivh ${install_rpm}
done

echo '正在启动MySQL，请稍等......'
systemctl restart mysqld.service
if [ $? -ne 0 ];then
   echo 'MySQL启动失败'
   exit 1
else
   echo 'MySQL启动成功'
fi

A=1
while [ $A -eq 1 ]
do
	echo "新密码必须为8位字符字母大小写、数字+特殊符号"
	read -p "请输入新密码："  newpasswd
	read -p "请确认密码："  passwd
   if [ "$newpasswd" ==  $passwd ];then
      A=2
      echo "密码设置成功"
   else
      echo "两次密码不一致，请重新输入"
    fi
done

echo "设置的新密码为：${newpasswd}"

echo "skip-grant-tables" >>/etc/my.cnf   
systemctl restart mysqld.service
echo "************************************"
echo "注：该脚本默认配置了无密码登录，此处直接回车即可。"
echo "************************************"

mysql --connect-expired-password -uroot -p  -e "flush privileges;set global validate_password.policy=LOW;set global validate_password.length=4;alter user 'root'@'localhost' identified  by '${newpasswd}';"

if [ $? -ne 0 ];then
   echo '新密码设置失败!!!'
   exit 1
else
   echo "新密码设置成功!，新密码为：${newpasswd}"
fi

sed -i "s/skip-grant-tables/#skip-grant-tables/" /etc/my.cnf
echo "已禁用无密码登录mysql" 
systemctl restart mysqld.service
if [ $? -eq 0 ];then
   echo "mysql已启动"
else
   echo "mysql启动失败"
fi

#`create database zabbix character set utf8mb4 collate utf8mb4_bin;  这条命令创建了一个名为`zabbix`的数据库，并设置了数据库字符集为`utf8mb4`，排序规则为`utf8mb4_bin`。
#create user zabbix@localhost identified by 'zabbix@123';   这条命令创建了一个名为`zabbix`的用户，该用户只能从`localhost`连接到数据库，并使用密码`zabbix@123`进行身份验证。
#grant all privileges on zabbix_proxy.* to zabbix@localhost;   这条命令授予用户`zabbix@localhost`对数据库`zabbix`的所有权限。这意味着该用户可以执行该数据库中的所有操作。
#set global log_bin_trust_function_creators = 1;   这条命令设置了全局变量`log_bin_trust_function_creators`的值为1。这个变量决定了是否允许二进制日志信任函数创建者。如果将其设置为1，则表示信任函数创建者，即使他们不是SUPER或PROCESS用户。这可以使得在某些情况下创建的函数可以被复制到其他服务器，而不需要相同的用户权限。

mysql -uroot -p"Admin@123" -e "create database zabbix character set utf8mb4 collate utf8mb4_bin;create user zabbix@localhost identified by 'zabbix@123';grant all privileges on zabbix.* to zabbix@localhost; set global log_bin_trust_function_creators = 1;"

scp /usr/share/zabbix-sql-scripts/mysql/server.sql.gz   root@192.168.10.10:/root/

zcat server.sql.gz|mysql --default-character-set=utf8mb4  -uzabbix -p"zabbix@123" -D"zabbix"

mysql -uroot -p"Admin@123" -e "set global log_bin_trust_function_creators = 0;flush privileges;"

vim /etc/zabbix/zabbix_proxy.conf

vim /etc/nginx/conf.d/zabbix.conf

systemctl restart zabbix-server zabbix-agent nginx php-fpm
systemctl enable zabbix-server zabbix-agent nginx php-fpm

mysql -uroot -p"Admin@123" -e "update mysql.user set Host = '%' where Host = 'localhost' and User='zabbix';flush privileges;grant all privileges on zabbix.* to 'zabbix'@'%';
"

mv graphfont.ttf graphfont.ttf.bak
 mv SIMYOU.TTF graphfont.ttf

#安装repo源
rpm -Uvh https://repo.zabbix.com/zabbix/6.4/rhel/7/x86_64/zabbix-release-6.4-1.el7.noarch.rpm
yum clean all && yum makecache

yum install zabbix-agent

Server=192.168.10.39
ServerActive=192.168.10.39
Hostname=Agent-Centos7

systemctl start zabbix-agent
systemctl enable zabbix-agent