PHP MyAdmin Installation Part-4

Introduction

Part 1 : Installation of Apache Web-Werver with Basic Configuration

Part 2 : Install PHP support for Apache

Part 3 : MariaDB Installation

Part 4 : PHP MyAdmin Installation

EPEL repo is require to install latest phpMyAdmin as follows:

rpm -iUvh http://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm

Sample output:

Retrieving http://dl.fedoraproject.org/pub/epel/beta/7/x86_64/epel-release-7-0.2.noarch.rpm
warning: /var/tmp/rpm-tmp.8ribi5: Header V3 RSA/SHA256 Signature, key ID 352c64e5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:epel-release-7-0.2               ################################# [100%]

Or you can directly install epel repository using below command

yum install epel-release

phpMyAdmin can now be installed by using following yum command:

# yum install phpMyAdmin

Sample output:

Loaded plugins: fastestmirror
epel/x86_64/metalink                                                               | 4.5 kB  00:00:00
epel                                                                               | 3.7 kB  00:00:00
(1/2): epel/x86_64/group_gz                                                        | 163 kB  00:00:03
(2/2): epel/x86_64/primary_db                                                      | 2.2 MB  00:00:13

--> Running transaction check
---> Package fontpackages-filesystem.noarch 0:1.44-8.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==========================================================================================================
 Package                              Arch            Version                         Repository     Size
==========================================================================================================
Installing:
 phpMyAdmin                           noarch          4.2.6-1.el7                     epel          4.0 M
Installing for dependencies:
 dejavu-fonts-common                  noarch          2.33-6.el7                      base           64 k

Downloading packages:
(1/14): fontpackages-filesystem-1.44-8.el7.noarch.rpm                              | 9.9 kB  00:00:01
(2/14): dejavu-fonts-common-2.33-6.el7.noarch.rpm                                  |  64 kB  00:00:01

Installed:
  phpMyAdmin.noarch 0:4.2.6-1.el7

Dependency Installed:
  dejavu-fonts-common.noarch 0:2.33-6.el7                                 dejavu-sans-fonts.noarch 0:2.33-6.el7
  fontpackages-filesystem.noarch 0:1.44-8.el7                             libmcrypt.x86_64 0:2.5.8-13.el7
  libtidy.x86_64 0:0.99.0-31.20091203.el7                                 libxslt.x86_64 0:1.1.28-5.el7
  php-bcmath.x86_64 0:5.4.16-21.el7                                       php-mcrypt.x86_64 0:5.4.16-2.el7
  php-php-gettext.noarch 0:1.0.11-10.el7                                  php-tcpdf.noarch 0:6.0.089-1.el7
  php-tcpdf-dejavu-sans-fonts.noarch 0:6.0.089-1.el7                      php-tidy.x86_64 0:5.4.16-2.el7
  php-xml.x86_64 0:5.4.16-21.el7

Complete!

Now configure phpMyAdmin to accept connection from remote host by commenting some lines in phpmyadmin.conf file, which is located under this path /etc/httpd/conf.d/phpMyAdmin.conf.

# vi /etc/httpd/conf.d/phpMyAdmin.conf

This file should be commenting out like this:

# phpMyAdmin - Web based MySQL browser written in php
#
# Allows only localhost by default
#
# But allowing phpMyAdmin to anyone other than localhost should be considered
# dangerous unless properly secured by SSL

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 127.0.0.1
#     Allow from ::1
#
#

        Options none
        AllowOverride Limit
        Require all granted

Now change the authentication in phpMyAdmin from cookie to http:

# vi /etc/phpMyAdmin/config.inc.php

find below line and change “cookie” to “http”.

$cfg['Servers'][$i]['auth_type']     = 'cookie';    // Authentication method (config, http or cookie based)?

Change into:

$cfg['Servers'][$i]['auth_type']     = 'http';    // Authentication method (config, http or cookie based)?

Save & Exit
Finally restart Apache web-server:

# service httpd restart

Now open browser and point http://192.168.1.200/phpmyadmin, you will ask to provide username and password (MySQL username and password).

phpMyAdmin Authentication
phpMyAdmin Authentication

 

 

 

 

 

 

 

once you provide credentials you will get phpmyadmin nice web-base management page for MySQL DB.

MySQL Web Base Management
MySQL Web Base Management

 

 

 

 

 

 

 

 

 

 

 

 

That’s All we have successfully installed LAMP Stack on Centos 7/RHEL 7.
Please give your feedback in comment section.Thanks :).