搭建piwik，

搭建piwik，

一、安装数据库
yum install numactl libaio perl-Time-HiRes per-devel httpd -y
mkdir -p /home/tools
cd /home/tools
将mysql-5.7.18-1.el6.x86_64.rpm-bundle.tar放到tools目录
tar -xvf mysql-5.7.18-1.el6.x86_64.rpm-bundle.tar
rpm -ivh mysql-community-common-5.7.18-1.el6.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.18-1.el6.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-client-5.7.18-1.el6.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-server-5.7.18-1.el6.x86_64.rpm --nodeps --force

rpm -qa | grep mysql //查看原来安装的Mysql
rpm -e --nodeps mysql-libs-5.1.71-1.el6.x86_64 //卸载原来mysql

vi /etc/my.cnf //在最后添加以下参数
character_set_server=utf8
lower_case_table_names=1
max_connections=1000

service mysqld start
chkconfig mysqld on
grep 'temporary password' /var/log/mysqld.log //生成随机密码

mysql -uroot -p //登录mysql输入随机密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Report@123'; //设置mysql密码
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Report@123' WITH GRANT OPTION; //允许root用户在任何地方进行远程登录
FLUSH PRIVILEGES; //具有所有库任何操作权限
create database piwik; //创建数据库piwik
grant all privileges on piwik.* to piwik@'localhost' identified by 'Report@123'; //设置库密码权限
quit

二、安装php
rpm -Uvh http://ftp.iij.ad.jp/pub/linux/fedora/epel/6/x86_64/epel-release-6-8.noarch.rpm
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
yum install --enablerepo=remi --enablerepo=remi-php56 php php-opcache php-devel php-mbstring php-mcrypt php-mysqlnd php-phpunit-PHPUnit php-pecl-xdebug php-pecl-xhprof php-mysql php-pdo php-gd php-mbstring php-dom php-xml

vi /etc/php.ini //添加和修改以下内容
mbstring.func_overload = 0
extension=mysqli.so
extension=pdo.so
extension=pdo_mysql.so

memory_limit = 512M //修改

always_populate_raw_post_data = -1 //修改
:wq

三、安装piwik
yum install wget -y
yum install unzip -y
cd /var/www/html/
将piwik放到此目录
unzip piwik.zip
chown -R apache:apache /var/www/html/piwik
chmod -R 0755 /var/www/html/piwik/tmp
service httpd start
rm -Rf /var/www/html/piwik/plugins/Morpheus/icons/submodules

用火狐浏览器打开http://192.168.88.20/piwik/
下一步---->下一步---->填写数据库账号(root)密码(Report@123)数据库名称(piwik)---->下一步
---->超级用户(admin)密码(123.bmk)Email(605738758@qq.com)取消下边两个对勾---->
网站名称(www.allbring.com)网址(http://www.allbring.com/)网站时区(UTC+8)---->下一步
---->继续使用PIWIK---->输入用户名admin密码123.bmk---->点击DON'T SHOW THIS MESSAGE FOR THE NEXT HOUR