zabbix安装部署mysql8.0

阿里云镜像：https://developer.aliyun.com/mirror/?spm=a2c6h.13651104.0.d1002.778f352dF64BW2

 

一、rpm安装mysql8.0

mysql-8.0.31-1.el7.x86_64.rpm-bundle.tar

# rpm -ql | grep mariadb
# rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64

# tar xvf mysql-8.0.31-1.el7.x86_64.rpm-bundle.tar
按顺序安装
# rpm -ivh mysql-community-common-8.0.31-1.el7.x86_64.rpm
# rpm -ivh mysql-community-icu-data-files-8.0.31-1.el7.x86_64.rpm
# rpm -ivh mysql-community-common-8.0.31-1.el7.x86_64.rpm --nodeps --force
# rpm -ivh mysql-community-libs-8.0.31-1.el7.x86_64.rpm --nodeps --force
# rpm -ivh mysql-community-client-8.0.31-1.el7.x86_64.rpm --nodeps --force
# rpm -ivh mysql-community-server-8.0.31-1.el7.x86_64.rpm --nodeps --force
# yum install -y libssl.so.10*

# 初始化
# mysqld --initialize

# cd /var/lib/mysql
# chown mysql:mysql /var/lib/mysql -R

# 启动
# systemctl start mysqld
# systemctl enable mysqld

# cat /var/log/mysqld.log | grep password
# dnf install -y libncurses.so.5*

 

二、进入mysql

# mysqladmin -uroot -puf0TZtQawq#X password Wushao123456
# mysql8 之前的版本中加密规则是mysql_native_password,而在mysql8之后,加密规则是caching_sha2_password
# 开启远程链接
# msyql -uroot -p
# use mysql;
# update user set host = '%' where user = 'root';
# GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;
# FLUSH PRIVILEGES;
# ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Wushao123456';
# ALTER USER 'root'@'%' IDENTIFIED BY 'Wushao123456' PASSWORD EXPIRE NEVER;
# FLUSH PRIVILEGES;

 

三、配置zabbix-proxy

# vim /etc/zabbix/zabbix_proxy.conf

### Option: ProxyMode
# Proxy operating mode.
# 0 - proxy in the active mode           主动
# 1 - proxy in the passive mode          被动
#
# Mandatory: no
# Default:
# ProxyMode=0                   # 主动模式

Server=127.0.0.1                # server-ip

Hostname=Zabbix proxy           # 主机名

DBHost=192.168.0.7

DBPassword=Wushao123456

ConfigFrequency=60           # 多久从server刷新配置

DataSenderFrequency=1        # 多久给server汇报一次数据