CentOS 默认情况下提供了一个很老的版本的 MySQL 5.1。我们需要 MySQL5.6 以上版本,需要删除旧版本。
- [ ~]# yum list installed | grep mysql
- mysql-libs.x86_64
- [ ~]# yum remove mysql*
配置 MySQL 源
- [ ~]# rpm -ivh http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
- Retrieving http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
- Preparing...########################################### [100%]
- 1:mysql-community-release########################################### [100%]
安装 MySQL
- [ ~]# yum install mysql-server
查看 MySQL 版本
- [ ~]# 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
- mysql-community-release.noarch
- mysql-community-server.x86_64
修改 mysql 配置文件. /etc/my.cnf,在 [mysqld] 中添加 innodb_file_per_table=1
- [ ~]# 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
启动
- [ ~]# service mysqld start
初始化安全数据库
- [ ~]# mysql_secure_installation
登录数据库
- [ ~]# mysql -u root -p123456
数据库字符集
- mysql > CREATE DATABASE zabbix CHARACTER SET utf8 COLLATE utf8_bin;
- Query OK,
- 1 row affected (0.00 sec)
创建一个数据库用户,设置密码和授予特权。
- mysql > GRANT ALL PRIVILEGES ON zabbix. * TO IDENTIFIED BY 'gz';
- Query OK,
- 0 rows affected (0.00 sec)
检查授权是否成功
- mysql> show databases;
- +--------------------+
- |Database|
- +--------------------+
- | information_schema |
- | mysql |
- | performance_schema |
- | zabbix |
- +--------------------+
- 4 rows inset(0.00 sec)
Zabbix 3 需要 PHP5.4 或更高版本。所以配置一个 PHP 源。
- [ ~]# rpm - ivh http: //repo.webtatic.com/yum/el6/latest.rpm
安装所需的包
- [ ~]# yum install httpd php56w php56w-gd php56w-mysql php56w-bcmath php56w-mbstring php56w-xml php56w-ldap
修改 php 配置
- [ ~]# 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
- [ ~]# service httpd start
启用端口 80 上的 iptables
- [ ~]# iptables -I INPUT -p tcp --dport 80 -m state --state NEW,ESTABLISHED -j ACCEPT
- [ ~]# iptables-save > /etc/sysconfig/iptables
来源: