Shulou(Shulou.com)06/01 Report--

Function: users test the data storage function of zabbix

Migrate database

Zabbix server

Stop zabbix-server # stops the zabbix service so that data is no longer generated

Scp-r / var/lib/mysql/ root@192.168.110.172:/data/zabbix/ # migrate the files under the database to the remote host database

Database host side

Vim / etc/my.cnf

Datadir=/data/zabbix # modify the location of the database

Mkdir-p / data/zabbix

Rm-rf / data/zabbix # initialize the database

Chown mysql:mysql / data/zabbix-R

Start mysqld

Modify the data storage database

Zabbix-server side modification

Vim / etc/zabbix/zabbix_server.conf

(modify database address)

DBHost=localhost # Database address

Service start zabbix-server & & netstat-tnlp | grep 10051

Web page modification

Administration-Installation # reinstall to set the database location or

Modification in vim / etc/zabbix/web/zabbix.conf.php configuration file

Database authorization

Mysql > grant all on zabbix.* to 'zabbix'@'192.168.110.171' identified by' zabbix'

Query OK, 0 rows affected (0.00 sec) # authorized zabbix server can connect to the database host using the zabbix user zabbix password

Mysql > flush privileges

Query OK, 0 rows affected (0.00 sec)

Mysql-uzabbix-h292.168.110.172-pzabbix # ensure that you can connect to the database host using the zabbix user and password

Mysql-uroot-h292.168.110.172 # ensure that the user administrator can connect to the database server (ensure that zabbix-sever can successfully test the link to the database host)

Verification: monitoring-latest data- selects the monitoring item graph (adjust the timeline to check to view previous data)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.