Okay so I have been using Piwik for about a year now and find it to be  flawless so I thought I’d do a write up about it.

From the Piwik website: Piwik is the leading open source web analytics platform that give s you valuable insights into your website’s visitors, your marketing campaigns and much more, so you can optimize your strategy and online experience of your visitors.



This is assuming the following is already configured:

  • A valid public domain
  • The said public domain has A records pointing to a publicly visible Apache web server
  • The said Apache web server has a valid vhost configuration for said domain
  • The said Apache web server has PHP 5.5 or greater installed and working
  • The said Apache server has internet access to download files
  • The said web server has mySQL installed and configured correctly

Configuring Apache

Create a directing for the Piwik install, I will be using example.com as an example domain

Download Piwik

Install Unzip (if not installed)

Unzip the contents of the zip file

Change ownership and permissions

Configuring mySQL

Note1: Do not use the “mysql>” at the beginning of the command, that is just to indicate you are in mysql command prompt.

Note2: mySQL commands require a “;” at the end of the command

Log into mySQL

Create  a new database

Use the database

Create a user

Grant permissions for the piwik account to the piwik database (don’t use password123)

Finish Install

Browse to the Piwik installation using your browser (I am using example.com)


Select “Next”


Make sure everything has green ticks next to them and click “Next”

Leave the database server as

Type in the username

Type in the password

Type in the database name


Click “Next”


Ensure tables are created and click “Next”

Type in the desired admin login name, password and email address and press “Next”

Type in the website name, URL, time zone and whether or not it is a ecommerce site or not and then press “Next”


Take a copy of the Javascript tracking code and select “Next”


Click on “Continue to Piwik” to continue


If prompted, upgrade database


I recommend donating using the secure PayPal feature, select “Continue to Piwik”

Sign in to start using Piwik

Should you have any questions, comments or suggestions, please don’t hesitate to comment below. If you like what you have read, please share it on your favourite social media medium.

Leave a Reply

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

Time limit is exhausted. Please reload CAPTCHA.