mariadb:
#yum install mariadb-server mariadb mariadb-devel -y
#systemctl start mariadb
#systemctl enable mariadb
#mysql_secure_installation
#vi /etc/my.cnf
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
innodb_file_per_table=on
log-bin=mysql-bin
#vi /etc/my.cnf.d/client.cnf
[client]
default-character-set=utf8
#systemctl restart mariadb
zabbix_proxy:
#rpm -ivh http://repo.zabbix.com/zabbix/3.4/rhel/7/x86_64/zabbix-release-3.4-1.el7.centos.noarch.rpm
#yum install zabbix-proxy-mysql -y
#mysql -uroot -p
MariaDB [(none)]> create database zabbix_proxy character set utf8 collate utf8_bin;
MariaDB [(none)]> grant all privileges on zabbix_proxy.* to zabbix@localhost identified by 'zabbix#1358';
MariaDB [(none)]> flush privileges;
MariaDB [(none)]> \q
#zcat /usr/share/doc/zabbix-proxy-mysql-3.4.7/schema.sql.gz | mysql -uzabbix -p zabbix_proxy
修改/etc/zabbix/zabbix_proxy.conf 的信息如下,
#vi /etc/zabbix/zabbix_proxy.conf
Server=192.168.10.223
Hostname=Zabbix proxy
DBName=zabbix_proxy
DBUser=zabbix
DBPassword=zabbix#1358
#systemctl restart zabbix-proxy
修改zabbix_agent上的配置文件:
#vi /etc/zabbix/zabbix_agentd.conf
Server=192.168.10.222 zabbix_proxy地址
ServerActive=192.168.10.222 zabbix_proxy地址
转载于:https://blog.51cto.com/dodowolf/2091911