Raspberry Pi 2: Configuring it as a Complete WordPress Web Server – Part 4 – Install MySQL

This article is a continuation from this post. Previously, we have provisioned our RasPi 2 and installed BIND on it. We also transferred DNS zones from our Windows DNS system to the RasPi. In the previous post, we installed Apache and PHP.

In this post, we will install the final component necessary to run WordPress – MySQL.

At the time of writing this, the latest edition of MySQL Server available for RasPi (ARM) is 5.5. This posed me a great challenge in setting up any sort of automated replication within MySQL, because of the version differences — my Windows system is running the 5.6 Community Server edition of MySQL.

Install MySQL

Again, simple enough:

# apt-get install mysql-server-5.5 mysql-common mysql-client mysql-utilities php5-mysql

Note that once again, I have php5-mysql component in the install list, though we have already installed it when we installed Apache and PHP in the previous article. This is because I found that without it, the install will actually remove this component.

During the installation, you will be prompted for a password for the MySQL “root” user. This user by default has FULL permissions on your MySQL installation. Set a good password and remember it. We actually need it in our next post.

There is nothing to do actually to configure MySQL. Like I said, I had issues in getting replication working and I have devised my own way of getting the databases across. We are going to examine this, along with scripts (yay!!!) in the next post.