Skip to main content

How to install phpmyadmin on ubuntu 12.04


Phpmyadmin on ubuntu :

Phpmyadmin is a free tool used to administrative MySQL database in a GUI mode ( Using web browser ) . You can perform almost all the major tasks like creating , deleting  and modifying databases, tables, rows etc. you can also optimize and repair tables just with a single click .

Phpmyadmin on ubuntu 12.04 :

Inorder to install phpmyadmin on ubuntu 12.04, you need 3 main packages apache , MySQL and php has to be installed and configured properly. You can refer the below posts to install, configure and test the apache, mysql and php together.

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

After installing apache2, mysql and php, you can continue with the below steps to install and configure phpmyadmin

Step 1 » Update ubuntu repositories by giving the below command

krizna@leela:~$ sudo apt-get update

Step 2 » Type the below command to install phpmyadmin .

krizna@leela:~$ sudo apt-get install phpmyadmin

Step 3 » You will prompted to choose the type of web server for phpmyadmin . just choose “apache2”  (use space bar and enter key for selecting ) . phpmyadmin on ubuntu 12.04Step 4 » Now the installation will prompt for the mysql database configuration ,As we already configured mysql server manually just choose “No” and hit enter to complete the installation.install phpmyadmin ubuntu 12.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 ubuntu 12.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

  • Ket

    How to make it look like http://15.16.171.819/phpmyadmin/

    Thanks

    • riaz

      IP should be configured in the machine

    • nic

      aaaaaaaaaaaand, ip’s does not by any chance go over 255

  • ketting00

    How to make it look like http://15.16.171.819/phpmyadmin/

    Thanks

    • riaz

      IP should be configured in the machine

    • nic

      aaaaaaaaaaaand, ip’s does not by any chance go over 255

  • naveen

    thanks you

  • naveen

    thanks you

  • cpedraza

    hi, i have a big trouble, in http://localhost/phpmyadmin a see a list of files, but no found well, any idea, thk’s

  • cpedraza

    hi, i have a big trouble, in http://localhost/phpmyadmin a see a list of files, but no found well, any idea, thk’s

  • Patrick

    Alas, any tutorial I come across seems to never get phpmyadmin working properly. I always get Not Found. Any ideas why this is?

    • Patrick

      Nevermind. It seems like you may have missed a step though.
      You need to add this statement to the end of the apache2 conf file.

      Include /etc/phpmyadmin/apache.conf

      and then restart apache2

      • bifflowman

        Thanks man. I would have spent a lot of time trying to figure that out.

  • Patrick

    Alas, any tutorial I come across seems to never get phpmyadmin working properly. I always get Not Found. Any ideas why this is?

    • Patrick

      Nevermind. It seems like you may have missed a step though.
      You need to add this statement to the end of the apache2 conf file.

      Include /etc/phpmyadmin/apache.conf

      and then restart apache2

      • bifflowman

        Thanks man. I would have spent a lot of time trying to figure that out.

  • Pingback: Apache restart error on ubuntu 12.04 - Nginx Solutions - Developers Q & A()