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:

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

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

Step:5 Now Set the phpmyadmin password

Retype the phpmyadmin password and select Ok.

Step:6 Now Access the phpMyAdmin , using the url :

http://localhost/phpmyadmin/

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

 

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

source