PhpMyAdmin is a handy web interface for managing local MySQL databases, and can make database queries, management and backups easy.
In this tutorial, I'm going to talk you through installing PhpMyAdmin on your Raspberry Pi powered web server. I'm assuming you've got Raspbian installed, and you've followed my tutorial: install Apache, PHP and MySQL on Raspberry Pi.
Step 1 – Begin the PhpMyAdmin installation
From terminal, we begin by changing to the root user in terminal by entering:
Now we need to install the PhpMyAdmin package using:
apt-get install phpmyadmin
The package will begin installing. You will be asked which web server is installed, choose apache2.
My screenshots show purple, but you'll see blue. I've already got PhpMyAdmin installed on my Raspberry Pi so had to install it on a ubuntu VM for the purpose of this tutorial – apologies for the wrong colours, but I can assure you the procedure is the same for Debian/Raspbian and Ubuntu!
Step 2 – configure for dbconfig-common
Next we'll need to configure PhpMyAdmin's database. You'll see the following prompt:
When prompted, choose Yes. Next you'll be asked for an administrative password, this is the root password that was set during the MySQL installation in the previous tutorial.
You'll be asked to set a password for PhpMySQL. I've used the same password as the MySQL root password, but its up to you what you set here. Make a note of it somewhere.
That's PhpMyAdmin installed. Next we need to change the apache configuration to allow us to use http://your.raspberrypi.domain/phpmyadmin to access it.
Step 3 – Configure Apache to work with PhpMyAdmin
We need to alter the Apache configuration in order to access PhpMyAdmin. To do this, enter the following command to alter the configuration:
The configuration file will load in Nano. Navigate to the bottom of the file (keep pressing CTRL + V to jump page by page until you're at the bottom of the file) and add the following new line to the file:
Save the file (CTRL + X and enter Y when prompted to save) and restart Apache2. To restart Apache, enter the following command:
That's it! You're all installed and ready to go. Give accessing it a try by going to your Raspberry Pi's IP address or domain name and add ‘/phpmyadmin' to the end in your web browser, ie http://your.raspberrypi.domain/phpmyadmin.
As always your comments are welcome, feel free to leave one below. My next tutorial will guide you through installing WordPress through terminal, and hosting your first WordPress site on your Raspberry Pi web server.