开放原子开发者工作坊

数据库配置:

innodb_file_per_table=1

 

安装mysql

rpm -ivh http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm

 

修改mysql配置:

[mysqld]

default-storage-engine = innodb

innodb_file_per_table

collation-server = utf8_general_ci

init-connect = 'SET NAMES utf8'

character-set-server = utf8

 

mysql_secure_installation

CREATE DATABASE zabbix CHARACTER SET utf8 COLLATE utf8_bin;

GRANT ALL PRIVILEGES ON zabbix.* TO zabbix@localhost IDENTIFIED BY 'zabbix';

 

yum install mysql-devel net-snmp-devel curl-devel -y

./configure --prefix=/usr/local/zabbix-proxy --enable-proxy --enable-agent --with-mysql --with-net-snmp --with-libcurl

./configure --prefix=/usr/local/zabbix-proxy --enable-proxy --with-mysql --with-net-snmp --with-libcurl

 

[root@linux-node2 mysql]# pwd

/home/lanny/tools/zabbix-3.0.4/database/mysql

mysql -u zabbix -p zabbix < schema.sql