Skip to main content

How to install phpmyadmin on ubuntu 14.04

Phpmyadmin is a free web tool used to administrative MySQL database. You can perform all major tasks like creating , deleting  and modifying databases. you can also repair and optimize tables with a single click .

Install phpmyadmin on ubuntu 14.04 :

Before proceeding with phpmyadmin installation, you must have webserver configured in your machine .Here we choose LAMP ( Apache, Mysql and PHP ) stack for webserver . Please follow the links to configure LAMP server .

1. Apache2 installation
2. Mysql installation
3. PHP installation
4. Testing all together

After configuring LAMP server, you can continue with below steps to install and configure phpmyadmin.
Step 1 » Update repositories using the below command
krizna@leela:~$ sudo apt-get update
Step 2 » Issue the below command to install phpmyadmin .
krizna@leela:~$ sudo apt-get install phpmyadmin
Step 3 » During the installation, You will prompted to choose the type of web server . just choose “apache2”.
Install phpmyadmin on ubuntu 14.04
Step 4 » Now you will be prompted for mysql database configuration, just choose “No” as we already configured mysql server manually and hit enter to complete the installation.
Install phpmyadmin on ubuntu 14.04
Step 5 » That’s it, now open the path “http://localhost/phpmyadmin” in the browser , you will prompted for username and password . just type Mysql root username and password given during the Mysql installation. Now after successfull login , you can see the screen like below .
Install phpmyadmin on ubuntu 14.04
If you are getting “Page not found” issue .Include the below line in /etc/apache2/apache2.conf file.
Include /etc/phpmyadmin/apache.conf
and restart apache2 service
sudo /etc/init.d/apache2 restart