Hello Linux Geeksters. As you may know, phpMyAdmin is an open-source tool for administrating MySQL, MariaBD and Dizzle databases, written in PHP. Among others, it enables the users to easily manage databases, tables, relations, indexes, users, columns, ect via the user interface. The latest version avalable is phpMyAdmin 4.2.5, which has been released a while ago.
In this article I will show you how to install phpMyAdmin 4.2.5 on Ubuntu 14.04 Trusty Tahr, Ubuntu 13.10 Saucy Salamander, Ubuntu 12.04 Precise Pangolin, Linux Mint 17 Qiana, Linux Mint 16 Petra, Linux Mint 13 Maya, Pinguy OS 14.04, Pinguy OS 12.04, LXLE 14.04, Elementary OS 0.3 Freya, Elementary OS 0.2 Luna, Peppermint Five, Linux Lite 2.0 and other Ubuntu derivative systems.
Because it is available via PPA, installing phpMyAdmin 4.2.5 on the listed Ubuntu, Linux Mint, Pinguy OS, Elementary OS, LXLE, Linux Lite and Peppermint systems is easy. All you have to do is install the apache2, php5 and mysql packages, add the ppa to your system, update the local repository index and install the phpmyadmin package. Like this:
$ sudo apt-get install apache2 php5 mysql-server
$ sudo add-apt-repository ppa:tuxpoldo/phpmyadmin
$ sudo apt-get update
$ sudo apt-get install phpmyadmin
Follow the instructions from the graphical user interface, select the desired webserver (apache or lightppd), configure the phpMyAdmin database, set the admin password and the mysql administration password.
After the installation has been performed successfully, do:
$ sudo sh -c 'echo "Include /etc/phpmyadmin/apache.conf" >> /etc/apache2/apache2.conf'
And restart the apache2 service:
$ sudo service apache2 restart
And that’s it. To launch phpMyAdmin, open your browser and type http://localhost/phpmyadmin as URL and login with the chosen username and password.