[root@localhost ~]# mysql -u root mysql> use mysql mysql> update user set password=password('123456') where user='root'; mysql> SELECT Host,User,password_expired FROM user; mysql> update user set host='192.168.%.%',password_expired='N'where host='127.0.0.1'; mysql> grant all privileges on *.* to 'root'@'localhost' identified by '123456' with grant option; mysql> grant all privileges on *.* to 'root'@'192.168.%.%' identified by '123456' with grant option; mysql> flush privileges; mysql> commit; mysql> show global variables like "%datadir%"; +---------------+-----------------+ | Variable_name | Value | +---------------+-----------------+ | datadir | /var/lib/mysql/ | +---------------+-----------------+ 1 row inset (0.00 sec)
[root@localhost ~]# mysql -uroot -p123456 mysql> create database zabbix default charset utf8; mysql> grant all privileges on zabbix.* to zbxuser@localhost identified by 'zbxpass'; mysql> grant all privileges on zabbix.* to zbxuser@'192.168.%.%' identified by 'zbxpass'; mysql> flush privileges; mysql> commit; mysql> quit
1 2 3 4
[root@localhost ~]# cd zabbix-3.4.11 [root@localhost zabbix-3.4.11]# mysql -uzbxuser -pzbxpass zabbix < database/mysql/schema.sql [root@localhost zabbix-3.4.11]# mysql -uzbxuser -pzbxpass zabbix < database/mysql/images.sql [root@localhost zabbix-3.4.11]# mysql -uzbxuser -pzbxpass zabbix < database/mysql/data.sql
配置zabbix
1 2 3 4 5 6 7
[root@localhost ~]# sed -i '/LogFile/s/tmp/var\/log\/zabbix/' /usr/local/zabbix/etc/zabbix_server.conf [root@localhost ~]# sed -i '/^DBUser\=/s/root/zbxuser/' /usr/local/zabbix/etc/zabbix_server.conf [root@localhost ~]# sed -i '/# DBPassword/aDBPassword=zbxpass' /usr/local/zabbix/etc/zabbix_server.conf [root@localhost ~]# sed -i '/# DBPort/aDBPort=3306' /usr/local/zabbix/etc/zabbix_server.conf [root@localhost ~]# sed -i '/^Timeout/s/4/30/' /usr/local/zabbix/etc/zabbix_server.conf #如果修改了数据库的data目录,也需要修改zabbix server配置文件 [root@localhost ~]# sed -i '/^# DBSocket/aDBSocket=/data/mysql_data/mysql.sock' /usr/local/zabbix/etc/zabbix_server.conf
1 2 3 4
[root@localhost ~]# sed -i '/^Server/s/127.0.0.1/192.168.1.202/g' /usr/local/zabbix/etc/zabbix_agentd.conf [root@localhost ~]# sed -i "/^ServerActive/s/127.0.0.1/192.168.1.202:10051/g" /usr/local/zabbix/etc/zabbix_agentd.conf [root@localhost ~]# sed -i "/^Hostname/s/Zabbix server/192.168.1.202/g" /usr/local/zabbix/etc/zabbix_agentd.conf [root@localhost ~]# sed -i '/^LogFile/s/tmp/var\/log\/zabbix/' /usr/local/zabbix/etc/zabbix_agentd.conf