CentOS默认情况下提供了一个很老的版本的MySQL 5.1。我们需要MySQL5.6以上版本,需要删除旧版本。
1
2
3
| [iyunv@iZ25pvjcsyhZ ~]# yum list installed | grep mysql
mysql-libs.x86_64 5.1.73-3.el6_5@updates
[iyunv@iZ25pvjcsyhZ ~]# yum remove mysql*
|
配置MySQL源
安装MySQL 1
| [iyunv@hyg ~]# yum install mysql-server
|
查看MySQL版本 1
2
3
4
5
6
7
8
9
10
| [iyunv@hyg ~]# yum list installed | grep mysql
mysql-community-client.x86_64
5.6.32-2.el6 @mysql56-community
mysql-community-common.x86_64
5.6.32-2.el6 @mysql56-community
mysql-community-libs.x86_64
5.6.32-2.el6@mysql56-community
mysql-community-release.noarch
mysql-community-server.x86_64
5.6.32-2.el6@mysql56-community
|
修改mysql配置文件. /etc/my.cnf,在[mysqld]中添加innodb_file_per_table=1 1
2
3
4
5
6
7
8
9
10
11
12
| [iyunv@hyg ~]# vim /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
innodb_file_per_table=1
symbolic-links=0
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
|
启动 1
| [iyunv@hyg ~]# service mysqld start
|
初始化安全数据库
1
| [iyunv@hyg ~]# mysql_secure_installation
|
登录数据库 1
| [iyunv@hyg ~]# mysql -u root -p123456
|
数据库字符集 1
2
| mysql> CREATE DATABASE zabbix CHARACTER SET utf8 COLLATE utf8_bin;
Query OK,1 row affected (0.00 sec)
|
创建一个数据库用户,设置密码和授予特权。 1
2
| mysql> GRANT ALL PRIVILEGES ON zabbix.* TO zabbix@localhost IDENTIFIED BY 'gz';
Query OK,0 rows affected (0.00 sec)
|
检查授权是否成功 1
2
3
4
5
6
7
8
9
10
| mysql> show databases;
+--------------------+
|Database|
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| zabbix |
+--------------------+
4 rows inset(0.00 sec)
|
Zabbix 3需要PHP5.4或更高版本。所以配置一个PHP源。
安装所需的包 1
| [iyunv@hyg ~]# yum install httpd php56w php56w-gd php56w-mysql php56w-bcmath php56w-mbstring php56w-xml php56w-ldap
|
修改php配置 1
2
3
4
5
6
| [iyunv@hyg ~]# vim /etc/php.ini
post_max_size=16M
max_execution_time=300
max_input_time=300
date.timezone=Asia/Shanghai
always_populate_raw_post_data=-1
|
启动web 1
| [iyunv@hyg ~]# service httpd start
|
启用端口80上的iptables 1
2
| [iyunv@hyg ~]# iptables -I INPUT -p tcp --dport 80 -m state --state NEW,ESTABLISHED -j ACCEPT
[iyunv@hyg ~]# iptables-save > /etc/sysconfig/iptables
|
|