phpMyAdmin is a free software that provides you a user friendly interface to work with MySQL on the web. It simply provides you a convenient visual frontend to access MySQL capabilities. This tutorial shows you the steps for installing phpMyAdmin on Ubunu Linux so before installing it make sure you must have root privileges on your virtual private server.
apt-get is the easiest way of installing phpMyAdmin on Linux. Open your terminal and give the following command:
sudo apt-get install phpmyadmin
During the installation, phpMyAdmin will ask you a few questions for configuration:
- It asks yous to choose server, select Apache2 for the server:
- Next select YES when it asks you to configure database for phpmyadmin using dbconfig-common:
- When it prompts you will have to enter your MySQL password
- Now enter password that you want to use for logfing into phpmyadm
- Re-type and confirm the password
After installation completes, add phpmyadmin to apache configuration via following command:
sudo nano /etc/apache2/apache2.conf
Scroll down the cursor and add the phpmyadmin config to file by copy-pasting the following line:
Include /etc/phpmyadmin/apache.conf
Restart apache by following command in terminal:
sudo service apache2 restart
Now you can access phpmyadmin by opening youraddress/phpmyadmin