MySQL administration via command-line in Linux is very difficult job for any newbie system administrator or database administrator, because it contains numerous commands which we cannot remember in our daily life.
To make MySQL administration much easier we’re introducing a web based MySQL administration tool called PhpMyAdmin, with the help of this tool you can control and manage your database administration via a web browser easily.
PhpMyAdmin is a web-based interface for managing MySQL / MariaDB databases that is used as a replacement for command-line utilities.
It was written in PHP language, through this application you can do various MySQL administration tasks such as create, drop, alter, delete, import, export, search, query, repair, optimize and run other database management command via browser.
As other well-known web-based interfaces for managing system services, blog creation tools, or content management systems (CMSs), it is often targeted by malicious attackers who seek to exploit the usual lack of security measures.
In this article we’re going to show you how to install latest stable version of PhpMyAdmin for Apache or Nginx on RHEL, CentOS and Fedora distributions.
Here we’ve provided installation of PhpMyAdmin for both the web server’s Apache or Nginx. So, its up-to you which web server to choose for installation.
But do remember that, you must have working LAMP (Linux, Apache, PHP and MySQL/MariaDB) or LEMP (Linux, Nginx, PHP and MySQL/MariaDB) setup installed on your working system.
Step 1: Install EPEL and Remi Repositories
1. To install most recent version of PhpMyAdmin (i.e. 4.8), you need to install and enable EPEL and Remi repositories on your respective Linux distributions as shown:
On RHEL/CentOS 7
# yum install epel-release # rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-7.rpm
On RHEL/CentOS 6
-------------- On RHEL/CentOS 6 - 32-bit -------------- # yum install epel-release # rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm -------------- On RHEL/CentOS 6 - 64-bit -------------- # yum install epel-release # rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
On Fedora 28-24
# rpm -Uvh http://rpms.famillecollet.com/fedora/remi-release-28.rpm [On Fedora 28] # rpm -Uvh http://rpms.famillecollet.com/fedora/remi-release-27.rpm [On Fedora 27] # rpm -Uvh http://rpms.famillecollet.com/fedora/remi-release-26.rpm [On Fedora 26] # rpm -Uvh http://rpms.famillecollet.com/fedora/remi-release-25.rpm [On Fedora 25] # rpm -Uvh http://rpms.famillecollet.com/fedora/remi-release-24.rpm [On Fedora 24]
Step 2: Installing PhpMyAdmin Web Interface
2. Once you’ve installed above repositories, now its’ time to install PhpMyAdmin with the help of following command as shown.
# yum --enablerepo=remi install phpmyadmin
Note : If your are using PHP 5.4 on RHEL/CentOS/Fedora systems, then you need to run the below command to install it.
# yum --enablerepo=remi,remi-test install phpmyadmin
Step 3: Configuring PhpMyAdmin for Apache or Nginx
Apache you don’t need to configure anything for phpMyAdmin, because you will get working phpMyAdmin automatically at the address
The main configuration file is located under /etc/httpd/conf.d/phpMyAdmin.conf, make sure the Require all granted directive (For Apache 2.4) and Allow from ip address is added inside the Directory
PhpMyAdmin Allow Access
Finally, restart Apache to apply changes.
-------------- On RHEL/CentOS 7 and Fedora 28-24 -------------- # systemctl restart httpd -------------- On RHEL/CentOS 6 -------------- # service httpd restart
Nginx web server, we will create a symbolic link to PhpMyAdmin installation files to our Nginx web document root directory (i.e. /usr/share/nginx/html) by running the following command:
# ln -s /usr/share/phpMyAdmin /usr/share/nginx/html
Finally, restart Nginx and PHP-FPM to apply changes.
-------------- On RHEL/CentOS 7 and Fedora 28-24 -------------- # systemctl restart nginx # systemctl restart php-fpm -------------- On RHEL/CentOS 6 -------------- # service nginx restart # service php-fpm restart
Step 4: Accessing PhpMyAdmin Web Interface
Open your browser and point your browser to
http://<ip address>/phpmyadmin. It should open the phpmyadmin interface (as shown in the image below).
PhpMyAdmin Running on Fedora 24