How to Install PHPMyAdmin on CentOS 6?- CloudsDial



  • Introduction

    PHPMyAdmin is an open source tool used in place of MySQL command with graphical and more intuitive way of performing administration tasks like creating,editing, or deleting databases, and managing users with permissions. In the below article lets see how to install PHPMyAdmin on CentOS server.

    Prerequisites

    I will be working on a Fastwebhost managed CentOS 6.6 server.

    Initially for your CentOS 6.6 server to run PHPMyAdmin it needs LAMP (Linux, Apache, MySQL, PHP) stack installed.

    Now our server is ready for PHPMyAdmin installation. So, all you need to do is follow the below steps.

    Step 1 : Get EPEL Repository

    First, we'll install the EPEL repository. The EPEL repo (Extra Packages for Enterprise Linux) contains many additional packages, including the phpMyAdmin package we are looking for.

    ==============================================

    rpm -iUvh http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm

    ==============================================

    Step 2 : Installing PHPMyAdmin on CentOS

    Before doing anything, the best practice is to ensure all the packages in the server are up to date.

    ============

    yum -y update

    =============

    Now our installation is one command away.

    ========================

    yum -y install phpmyadmin

    ========================

    Step 3 : Know your IP address

    To access your PHPMyAdmin we need to know the IP address of our Machine.

    Step 4 : Open PHP MyAdmin configuration file

    Check for PHPMyAdmin configuration file with any of the text editor. You can find that at

    =====================================

    nano /etc/httpd/conf.d/phpMyAdmin.conf

    ======================================

    This present setup is configured to deny access to any connection not being made from the server itself.

    Since we are working on our server remotely, we need to modify some lines to specify the IP address of your home connection.

    Change any lines that read Requireip 127.0.0.1 or Allow from 127.0.0.1 to refer to your home connection's IP address.

    Requireip Machine IP
    Allow from Machine IP
    Requireip Machine IP
    Allow from Machine IP

    Now restart Apache

    ====================

    service httpd restart

    ====================

    With this our PHPMyAdmin is in operational mode.

    We can access our interface with the domain name or public IP address followed by /phpMyAdmin, in your web browser and it should look like below image.

    =======================================

    http://server_domain_or_IP/phpMyAdmin

    ======================================

    You can login to it with your any MySQL user or MySQL root logins which you gave when installing LAMP.

    Step 5 : Securing PHPMyAdmin

    This step is optional unless you want to really secure it.

    Go to the PHPMyAdmin configuration file again.

    =====================================

    vim /etc/httpd/conf.d/phpMyAdmin.conf

    =====================================

    Toward the top of the file, you will see two lines that look like the below line, there will be a case sensitive. As both the lines looks similar, one with /PHPMyAdmin and other is /phpmyadmin.

    Alias /phpmyadmin /usr/share/phpMyAdmin

    These are alias, means we access our site's domain name or IP address, followed by either /phpMyAdmin or /phpmyadmin.

    We need to disable these specific aliases and put our custom examples -securelink in that place by removing or commenting out the existing lines.

    Alias /phpmyadmin /usr/share/phpMyAdmin

    Alias /securelink /usr/share/phpMyAdmin

    Now restart Apache.

    ============================

    service httpd restart

    =======================

    Thanks for reading our content. to know more about our services, kindly visit our website:

    CloudsDial Solutions Pvt Ltd

    https://cloudsdial.com/

    Mail: [email protected]

    Skype ID: sivakumar.s07

    Youtube Link: https://youtu.be/n1M9rpi2dHw

    VISIT US DIRECTLY:

    NO:85 3rd FLOOR,

    EGAMBARAM STREET,

    UDHAYA NAGAR EXTENSION,

    PORUR, CHENNAI 600116.

    Contact-No: 8608522333