phpMyAdmin is a free web software that allows you to work with MySQL, it provides a convenient visual front end to MySQL databases.
Before working with phpMyAdmin you need to have LAMP installed on your server. If you don’t have the Linux, Apache, MySQL, PHP stack on your server please install that first. These instructions are for Ubuntu only!
Install phpMyAdmin
The easiest way to install phpmyadmin is through apt-get:
Putty or SSH into your server and type the command below to get started. Leave the SSH session open you’ll need it again!
sudo apt-get install phpmyadmin apache2-utils
During the installation, phpMyAdmin will walk you through a basic configuration. Once the process starts up, follow these steps:
- Select Apache2 for the server
- Choose YES when asked about whether to Configure the database for phpmyadmin with dbconfig-common
- Enter your MySQL password when prompted
- Enter the password that you want to use to log into phpmyadmin
After the installation has completed, add phpmyadmin to the apache configuration.
From the open putty or SSH session type:
sudo nano /etc/apache2/apache2.conf
Now add the line below to the apache configuration.
Include /etc/phpmyadmin/apache.conf
Hit Ctrl X and save and exit nano.
Now Restart apache.
sudo service apache2 restart
You can then access phpmyadmin by going to youripaddress/phpmyadmin. If everything went well you should see the login screen below.
