zabbix切换数据库操作
1、安装mysql-server数据库 ，讲三个表结构复制过去
将schema.sql images.sql data.sql 数据库从zabbix服务器上复制到/root路径下面
然后导入表结构
[root@mysql-server ~]# /usr/bin/mysql -uzabbix -pzabbix zabbix < /root/schema.sql
Warning: Using a password on the command line interface can be insecure.
[root@mysql-server ~]# /usr/bin/mysql -uzabbix -pzabbix zabbix < /root/images.sql
Warning: Using a password on the command line interface can be insecure.
[root@mysql-server ~]# /usr/bin/mysql -uzabbix -pzabbix zabbix < /root/data.sql
Warning: Using a password on the command line interface can be insecure.
2、修改zabbix_server.conf 中 注意这边是下划线
LogFile=/var/log/zabbix/zabbix_server.log
DBName=zabbix
DBUser=zabbix
DBPassword=zabbix
3、修改zabbix-server.php
[root@Zabbix02 ~]# vi /var/www/html/zabbix/conf/zabbix.conf.php
注意检查表红色的地方
<?php
// Zabbix GUI configuration file.
global $DB;
$DB[‘TYPE‘] = ‘MYSQL‘;
$DB[‘SERVER‘] = ‘10.7.10.56‘;
$DB[‘PORT‘] = ‘3306‘;
$DB[‘DATABASE‘] = ‘zabbix‘;
$DB[‘USER‘] = ‘zabbix‘;
$DB[‘PASSWORD‘] = ‘zabbix‘;
本文出自 “北极星” 博客，请务必保留此出处http://beijixing.blog.51cto.com/8561924/1914652
原文：http://beijixing.blog.51cto.com/8561924/1914652