How to Install and Configure Piwik on CentOS 6.2

Piwik is an open source web analytics software that makes it easy to get the information you want from your visitors. It’s free software alternative to Google Analytics.

1. To run Piwik, your host needs to meets the following minimum requirements :

-PHP version 5.1.3 or greater
-MySQL version 4.1 or greater
-Enabled PHP extension pdo and pdo_mysql, or the mysqli extension.(enabled by default)

If not, then install the following :

[root@centos62 ~]# yum install php-pdo php-gd php-xml -y

2. Enter apache’ document root directory :

[root@centos62 ~]# cd /var/www/html/

3. Download the latest release of Piwik from :

[root@centos62 html]# wget

4. Unzip the piwik’ zip file to document root :

[root@centos62 html]# unzip

5. Enter piwik directory :

[root@centos62 html]# cd piwik

6. Change the permission for ./piwik/config and ./piwik/tmp as below :

[root@centos62 piwik]# chmod 777 config
[root@centos62 piwik]# chmod 777 tmp

7. Login to mysql server using root and create the following database and it’s permission. You can create a new user with the command :

mysql> CREATE USER 'piwik'@'localhost' IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON piwik_db.* TO 'piwik'@'localhost' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

8. Navigate the browser to the piwik portal as below :

READ  How to Display MySQL root Password in Zimbra

9. Complete the piwik installation wizard :












Leave a Reply

Your email address will not be published. Required fields are marked *

A world leading hosting company that provides fully-managed innovative and secure solutions, suitable for hosting small to medium-sized websites

Built on the best available technologies combined with Google Cloud for strong redundancy and application availability. Backed by skilled experts to address web security threats, a devops team to create advanced custom security solutions, and 24/7 sysadmins to watch over the platform. This powerful, hands-on approach makes your sites faster, safer, and easier to manage. Starting from only $3.95/mo.


* up to 30 days money back guarantee