How to install PHPMyAdmin on CentOS 7.3

CentOS Tutorial – This short tutorial is going to show you how to install PHPMyAdmin on CentOS 7.3 Server. As you know, PHPMyAdmin is a web based MySQL Server administration tool. With this tool we can easily manage our MySQL Server anywhere via web browser. Installing PHPMyAdmin on CentOS 7 is pretty easy and straight forward. Please follow these steps to get started

Prerequisites

• LAMP Server on CentOS 7.3
• EPEL Repository installed on CentOS

Steps to install PHPMyAdmin on CentOS 7.3

Step 1. Install LAMP Server

In order to work, PHPMyAdmin needs a working LAMP Server. Please refers to my previous tutorial on how to install LAMP Server on CentOS 7.3 Server.

Step 2. Install EPEL Repository

We need to install EPEL repository first prior to phpmyadmin installation.

yum install epel-release

Step 3. Install phpmyadmin

Use this command to install phpmyadmin package

yum install phpmyadmin

Step 4. Configure phpmyadmin

Before we can use phpmyadmin, we need to configure some other things. Edit the phpmyadmin.conf under /etc/httpd/conf.d/

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

Now find any lines that say:

Require ip 127.0.0.1
Require ip ::1

And change them to this one. This will enable access from any IP addresses.

Require all granted

So it should looks like this:

<IfModule mod_authz_core.c>
     # Apache 2.4
     <RequireAny>
       Require all granted
     </RequireAny>
   </IfModule>

Now restart Apache web server

systemctl restart httpd

Now we can open PHPMyAdmin via web browser. Type the CentOS Ip address with the following format

http://ip-address/phpmyadmin

Example: