####安装

1. 准备zabbix源

rpm -Uvh https://repo.zabbix.com/zabbix/5.0/rhel/8/x86_64/zabbix-release-5.0-1.el8.noarch.rpm

yum repolist 可以查看是否安装源成功

1. 安装

yum -y install zabbix-server-mysql zabbix-agent

安装前端相关依赖

yum -y install zabbix-web-mysql.noarch zabbix-nginx-conf.noarch

1. 安装数据库相关依赖
2. 安装mysql

下载mysql源

wget https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm

# 安装mysql数据源

yum install mysql80-community-release-el8-1.noarch.rpm

# 检测mysql源是否安装成功

yum repolist enabled | grep "mysql.*-community.*"

# 禁用centos自带的mysql模块

yum module disable mysql

# 安装mysql

yum install mysql-community-server

service mysqld status

service mysqld start

# 查找随机密码

grep 'temporary password' /var/log/mysqld.log

mysql -uroot -p

修改默认密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Root_21root'

查看密码策略

SHOW VARIABLES LIKE 'validate_password%';

修改密码长度

set global validate_password_length=1;

set global validate_password.length=1;

修改密码等级

set global validate_password_policy=0;

set global validate_password.policy=0;

设置自己想要的密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxxxxx'

mysql 8以上需要修改配置文件 /etc/my.cnf

default_authentication_plugin=mysql_native_password

mysql允许远程连接

create user 'root'@'%' identified by 'zHAs3erVUnD0DkJz';

grant all privileges on . to 'root'@'%' with grant option;

FLUSH PRIVILEGES;

配置

1. mysql配置
2. 创建zabbix数据库

 	`create database zabbix character set utf8 collate utf8_bin;`

• 创建zabbix用户

 ` create user 'zabbix'@'%' identified by 'zabbix';`

 `grant all on zabbix.* to zabbix@'%';`

• 找到初始化数据库的sql

 ```shell

 rpm -ql zabbix-server-mysql

 zcat /usr/share/doc/zabbix-server-mysql/create.sql.gz > zabbix.sql

 vim zabbix.sql

 #在第一行新增, 选择数据库, 就上面新创建的就行

 use zabbix;

 # 注入SQL

 Mysql -p < zabbix.sql

1. zabbix配置

vim /etc/zabbix/zabbix_server.conf

数据库名称

DBName=zabbix

DBUser=zabbix

DBPassword=zabbix

1. 配置前端应用

vim /etc/php-fpm.d/zabbix.conf 

listen.acl_users = apache,nginx

php_value[date.timezone] = Asia/Shanghai

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

				listen          80;

       server_name     10.122.1.79;

1. 检测安全项目

关闭防火墙

systemctl disable --now firewalld

selinux

setenforce 0

vim /etc/selinux/config

SELINUX=disable

启动

systemctl start zabbix-server.service  php-fpm.service nginx.service

此时可以访问该ip了

1. 确认配置是否都是ok的

1. 连接数据库

3.. 输入名称

1. 确认配置

1. 配置成功

1. 开始使用

报错及解决方案

1. The server requested authentication method unknown to the client
2. 删除之前的用户delete from user where user='zabbix' and host='localhost';
3. 修改mysql配置文件 default_authentication_plugin=mysql_native_password
4. 重启mysql并创建用户 create user zabbix@localhost identified by 'zabbix1';``grant all privileges on zabbix.* to zabbix@localhost;
5. 设置远程连接 update user set host='%' where user='zabbix'; flush privileges;
6. 确认可以远程连接 select host, user, authentication_string, plugin from user; zabbix用户的host是% 表示成功
7. 重启mysql和php-fpm
8. Unsupported charset or collation for tables:

数据库字符集问题

• 删除原本的数据库 drop database zabbix;
• 创建新的数据库 create database zabbix character set utf8 collate utf8_bin;
• 注入表格等内容 mysql -p < zabbix.sql
• 数据库密码不符规定

查看密码策略

SHOW VARIABLES LIKE 'validate_password%';

修改密码长度

set global validate_password_length=1;

set global validate_password.length=1;

修改密码等级

set global validate_password_policy=0;

set global validate_password.policy=0;

设置自己想要的密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxxxxx'