1、安装安装MySQL8
1.1、在线下载安装包
[root@localhost ~]#
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.37-1.el9.x86_64.rpm-bundle.tar
1.2、新建解压文件夹
[root@localhost ~]#mkdir /root/sql
1.3、离线解压安装包安装配备MySQL8
上传安装包到home下
安装配备MySQL8
[root@localhost ~]#tar xf /home/mysql-8.0.37-1.el9.x86_64.rpm-bundle.tar -C /root/sql/
1.4、安装SQL
[root@localhost ~]#cd /root/sql/
[root@localhost sql]#rpm -ivh mysql-community-* --force --nodeps
1.5、启动MYSQL，并开机启动
[root@localhost sql]#systemctl start mysqld
[root@localhost sql]#systemctl enable mysqld
重启MYSQL服务
[root@Za-server ~]#systemctl restart mysqld
1.6、数据库初始密码
[root@localhost sql]#cat /var/log/mysqld.log | grep password
1.7、修改简单密码
[root@localhost sql]#mysql -uroot -p
Enter password:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Xa%^3T%T4!';
set global validate_password.policy=0;
set global validate_password.length=5;
set global validate_password.mixed_case_count=0;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'rootroot';
Quit
1.8、设置ROOT用户远程登录、创建zabbix用户赋予管理员权限
[root@localhost sql]#mysql -uroot -prootroot
use mysql;
update user set user.Host='%' where user.User='root';
flush privileges;
create database zabbix character set utf8 collate utf8_bin;
create user zabbix@localhost identified by 'zabbix123';
CREATE USER 'zabbix'@'%' IDENTIFIED BY 'zabbix';
show databases;
GRANT ALL PRIVILEGES ON mydatabase.* TO 'zabbix'@'localhost';
FLUSH PRIVILEGES;
GRANT SELECT, INSERT ON *.* TO 'zabbix'@'localhost';
GRANT ALL PRIVILEGES ON *.* TO 'zabbix'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
grant system_user on *.* to 'root';
grant system_user on *.* to 'zabbix';
FLUSH PRIVILEGES;
Quit
1.9、设置zabbix远程登录
[root@localhost sql]#mysql -uzabbix -pzabbix123
use zabbix
show tables;
GRANT ALL PRIVILEGES ON *.* TO 'zabbix'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
SELECT user FROM mysql.user WHERE user = 'zabbix';
use mysql;
ALTER USER 'zabbix'@'%' IDENTIFIED WITH caching_sha2_password BY 'zabbix123';
FLUSH PRIVILEGES;
select user, host from user;
quit
2、安装zabbix
2.1、在线加载zabbix的软件库
[root@localhost ]#rpm -Uvhhttps://repo.zabbix.com/zabbix/7.0/alma/9/x86_64/zabbix-release-7.0-4.el9.noarch.rpm
2.2、离线加载zabbix的软件库
[root@localhost sql]#sudo rpm -ivh /home/zabbix-server/zabbix-release-7.0-4.el9.noarch.rpm
2.3、关闭无关的库（在线安装）
[root@localhost sql]#vim /etc/yum.repos.d/epel.repo
enabled=1改成enabled=0
2.4、安装zabbix所需组件、在线
[root@localhost sql]#dnf install -y zabbix-server-mysql zabbix-web-mysql zabbix-apache-conf zabbix-sql-scripts zabbix-selinux-policy zabbix-agent
2.5、安装zabbix所需组件、离线
[root@Zabbix-7 ~]#rpm -ivh /home/zabbix/*.rpm
2.6、epel.repo重新启用（在线安装）
[root@localhost sql]#vim /etc/yum.repos.d/epel.repo
enabled=0改成enabled=1
3、配置zabbix数据库
3.1、导入zabbixd的初始数据库
[root@localhost sql]#zcat /usr/share/zabbix-sql-scripts/mysql/server.sql.gz | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix
Enter password:输入之前设置zabbix访问数据库的密码 zabbix123
检验 Zabbix 的数据库架构是否已经导入
[root@localhost ~]#mysql -uzabbix -pzabbix123
mysql>use zabbix;
show tables;
quit
3.2、配置conf文件
[root@localhost sql]#vim /etc/zabbix/zabbix_server.conf
#设置数据库密码，设置的zabbix密码zabbix123
DBPassword=zabbix123
3.3、关闭selinux
[root@localhost sql]#vim /etc/selinux/config
SELINUX=enforcing改为
SELINUX=disabled
[root@localhost sql]#setenforce 0
[root@localhost sql]#getenforce
Permissive
3.4、启动服务
[root@localhost sql]#systemctl restart zabbix-server zabbix-agent httpd php-fpm
[root@localhost sql]#systemctl enable zabbix-server zabbix-agent httpd php-fpm