install phpmyadmin on centos 6

Step 1: Add EPEL Repository in System

First step is to install EPEL repository in your system, Install package using one of below urls.

CentOS/RHEL 6, 32 Bit (i386):
# rpm -Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm

CentOS/RHEL 6, 64 Bit x86_64):
# rpm -Uvh http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm

CentOS/RHEL 5, 32 Bit (i386):
# rpm -Uvh http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm

CentOS/RHEL 5, 64 Bit (x86_64):
# rpm -Uvh http://dl.fedoraproject.org/pub/epel/5/x86_64/epel-release-5-4.noarch.rpm
Step 2: Install Package using Yum

Install phpMyAdmin package using yum command line tool.

# yum install phpMyAdmin

Sample Output

Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
 * base: mirror.nbrc.ac.in
 * epel: epel.mirror.net.in
 * extras: mirror.nbrc.ac.in
 * updates: mirror.nbrc.ac.in
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package phpMyAdmin.noarch 0:3.5.8-1.el6 will be installed
--> Processing Dependency: php-mbstring >= 5.2.0 for package: phpMyAdmin-3.5.8-1.el6.noarch
--> Processing Dependency: php-php-gettext for package: phpMyAdmin-3.5.8-1.el6.noarch
--> Running transaction check
---> Package php-mbstring.i686 0:5.3.23-1.el6 will be installed
---> Package php-php-gettext.noarch 0:1.0.11-3.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

============================================================================================
 Package                   Arch             Version                 Repository         Size
============================================================================================
Installing:
 phpMyAdmin                noarch           3.5.8-1.el6             epel              4.3 M
Installing for dependencies:
 php-mbstring              i686             5.3.23-1.el6            CentALT           893 k
 php-php-gettext           noarch           1.0.11-3.el6            epel               21 k

Transaction Summary
============================================================================================
Install       3 Package(s)

Total download size: 5.2 M
Installed size: 22 M
Is this ok [y/N]: y
Downloading Packages:
(1/3): php-mbstring-5.3.23-1.el6.i686.rpm                            | 893 kB     00:18
(2/3): php-php-gettext-1.0.11-3.el6.noarch.rpm                       |  21 kB     00:00
(3/3): phpMyAdmin-3.5.8-1.el6.noarch.rpm                             | 4.3 MB     00:08
--------------------------------------------------------------------------------------------
Total                                                       156 kB/s | 5.2 MB     00:34
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : php-mbstring-5.3.23-1.el6.i686                                           1/3
  Installing : php-php-gettext-1.0.11-3.el6.noarch                                      2/3
  Installing : phpMyAdmin-3.5.8-1.el6.noarch                                            3/3

Installed:
  phpMyAdmin.noarch 0:3.5.8-1.el6

Dependency Installed:
  php-mbstring.i686 0:5.3.23-1.el6           php-php-gettext.noarch 0:1.0.11-3.el6

Complete!
Step 3: Configure phpMyAdmin to Access Remotly

phpMyAdmin bye default all allowed to access from localhost only. If you want to make it accessible from remote computers edit /etc/httpd/conf.d/phpMyAdmin.conf and update all 127.0.0.1 with your ip.

Step 4: Restart Apache Service.

Restart apache service to reload new settings.

# service httpd restart
Step 5: Access phpMyAdmin in Browser

Now you can access phpMyAdmin in browser using following url. ChangeĀ 10.0.10.50 with your server ip.

URL: http://10.0.10.50/phpMyAdmin/
Login: Use MySQL user and password.

phpMyAdmin-Home

Leave a Reply