PhpMyadmin is used to administrate MySQL server. It is an open source tool. Using phpMyAdmin you can perform administration task such as creating, editing, or deleting databases and managing users permission. You can also export or import your database or table. It provides a graphical user interface to perform these task. It helps to developer to perform database related task.
In this article I will show you how to install and configure phpMyAdmin on CentOS 7.
Install and Configure phpMyAdmin on CentOS 7
First of all you have to login into your server as a root user. secondly LAMP Linux, Apache, MySQL and PHP must be installed on your Linux system. You can installed LAMP stack on your system following my previous article.
Now follow the below steps to install and configure phpMyAdmin on CentOS 7.
Download and Install EPEL Repository
phpMyAdmin is the part of the extra package to download and install it you will need to install Enterprise Linux (EPEL ). Follow the below link to install EPEL repository on your system.
After installing and enabling EPEL repository make sure your system must be up to date before installing any third party package. Follow the below command to update the system,
# yum update -y
Now install phpMyAdmin typing below command:
# yum -y install phpmyadmin
phpMyAdmin Basic Configuration
After installing phpMyAdmin on your system you should lock down access to a specific IP address to secure it. Edit the /etc/httpd/conf.d/phpMyAdmin.conf. By default the configuration for phpMyAdmin only allows access from localhost on which it is installed. For example my remote IP is 220.127.116.11.
# Apache 2.4 Require ip 18.104.22.168 Require ip 127.0.0.1 Require ip ::1 # Apache 2.2 Order Deny,Allow Deny from All Allow from 22.214.171.124 Allow from 127.0.0.1 Allow from ::1
Find your IP Address and that will be connecting to phpMyAdmin remotely.