How To Install phpMyAdmin in Linux(Ubuntu/CentOS/RHEL)

phpMyAdmin is a free and opensource web tool to manage mysql database. It provides a GUI(graphical user interface) to perform MySql administration task. Before installing phpMyAdmin you need to make sure that LAMP(Linux,Apache,Mysql,PHP) is installed on your machine.
In this tutorial we will discuss how to install phpMyAdmin on Ubuntu 13.10 & RHEL 6.X / CentOS 6.X.
 
phpMyAdmin Installation Steps in Ubuntu 13.10
 
Step:1 Open the Terminal Type the below Command
# sudo apt-get install phpmyadmin
 
Step:2 You will be asked to specify Web Server , while installing the phpMyAdmin as shown below:

Select Apache Webserver while installing phpmyadmin

Step:3 Create database for phpMyAdmin. Click on 'Yes' , it will create the required database for phpmyadmin.

Configure phpMyAdmin

Step:4 You will also asked to specify mysql root password which you have set during Mysql installation .

mysql root password in phpmyadmin installation

Step:5 Now Set the phpmyadmin password

phpmyadmin password during installation

Retype the phpmyadmin password and select Ok.

retypr phpmyadmin password

Step:6 Now Access the phpMyAdmin , using the url :
http://localhost/phpmyadmin/

phpmyadmin Login Screen

Use Root as a user & Password which you have set in above step and Will get the below interface after entering the credentials :

phpadmin dashboard
 


PhpMyAdmin Installation Steps in CentOS 6.X / RHEL 6.X
To install phpMyAdmin using yum command , first we have to set EPEL(Extra Packages for Enterprise Linux) Repository.
 
Step:1 Enable EPEL Repository
For 32 bit(i386) CentOS 6.X / RHEL 6.X
# rpm -ivh http://epel.mirror.net.in/epel/6/i386/epel-release-6-8.noarch.rpm
For 64 bit(x86_64) CentOS 6.X / RHEL 6.X
# rpm -ivh http://epel.mirror.net.in/epel/6/x86_64/epel-release-6-8.noarch.rpm
 
Step:2 Now Install phpMyAdmin Package using below Command
# yum install phpmyadmin
 
Step:3 Enable Remote Access
By default access of phpmyadmin is allowed from the localhost, so to allow remote access , edit the file
/etc/httpd/conf.d/phpMyAdmin.conf and replace the localhost ip(127.0.0.1) with your Network IP.
 
Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin


  
     # Apache 2.4
    
       Require ip 127.0.0.1
       Require ip ::1
    

  

  
     # Apache 2.2
     Order Deny,Allow
     Deny from All
     Allow from 192.168.1.0/24
     Allow from ::1
  

 
Step:4 Now Restart the Apache Service
# service httpd restart
 
Step:5 Now Access the phpMyAdmin from your Browser. Use MySQL username and password.
http:///phpmyadmin


PhpMyAdmin Dashboard