|
CentOS默认情况下提供了一个很老的版本的MySQL 5.1。我们需要MySQL5.6以上版本,需要删除旧版本。
[root@iZ25pvjcsyhZ ~]# yum list installed | grep mysql
mysql-libs.x86_64 5.1.73-3.el6_5@updates
[root@iZ25pvjcsyhZ ~]# yum remove mysql* 配置MySQL源
[root@hyg ~]# 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
[root@hyg ~]# yum install mysql-server
查看MySQL版本
[root@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
[root@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
启动
[root@hyg ~]# service mysqld start 初始化安全数据库
[root@hyg ~]# mysql_secure_installation登录数据库
[root@hyg ~]# 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 zabbix@localhost 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源。
[root@hyg ~]# rpm -ivh http://repo.webtatic.com/yum/el6/latest.rpm安装所需的包
[root@hyg ~]# yum install httpd php56w php56w-gd php56w-mysql php56w-bcmath php56w-mbstring php56w-xml php56w-ldap修改php配置
[root@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
[root@hyg ~]# service httpd start启用端口80上的iptables
[root@hyg ~]# iptables -I INPUT -p tcp --dport 80 -m state --state NEW,ESTABLISHED -j ACCEPT
[root@hyg ~]# iptables-save > /etc/sysconfig/iptables
|
|
|
|
|
|
|