How to Install PhpMyAdmin on CentOS/RHEL 7/6

Written by Rahul, Updated on February 15, 2020

phpMyAdmin is a well most popular web-based client for managing MySQL server. PHPMyAdmin is written in PHP programming language. It provides a user-friendly web interface to access and manage your databases. To ease usage to a wide range of people, phpMyAdmin is being translated into 72 languages and supports both LTR and RTL languages. This article will help you to install phpMyAdmin on CentOS/RedHat System.

Prerequsities

In order to use PHPMyAdmin, you must have PHP, MySQL and Apache installed on your system. Also, you need PHP-MySQL or PHP-MySQLi module enabled in PHP configuration. For the current version of PHPMyAdmin 4.7.2, the requirements are as follows.

Apache >= 2.2
PHP >= 5.5
MySQL/MariaDB >= 5.5

Use the tutorial: Installing Apache MySQL PHP on CentOS and RedHat

Step 1 – Enable Remi Repository

phpMyAdmin most updated package is available in Remi repository. Install it in your system using the following commands.

### CentOS/RHEL 7 ###
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-7.rpm

### CentOS/RHEL 6 ###
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm

Step 2 – Install PhpMyAdmin on CentOS

After enabling Remi repository on your system, let’s start the with the installation of phpMyAdmin using yum package manager. All the dependencies will automatically be installed.

yum --enablerepo=remi,remi-test  install phpMyAdmin

Step 3 – Configure PhpMyAdmin

phpMyAdmin by default allowed to access from localhost only. If you want to make it accessible from remote computers edit Apache configuration file of phpMyAdmin.

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

Now check for below section. Change Require local to Require all granted, This will disable local restriction access and phpMyAdmin will be accessible from the network.

Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin

<Directory /usr/share/phpMyAdmin/>
   AddDefaultCharset UTF-8

   <IfModule mod_authz_core.c>
     # Apache 2.4
     Require all granted
   </IfModule>
   <IfModule !mod_authz_core.c>
     # Apache 2.2
     Order Deny,Allow
     Deny from All
     Allow from 127.0.0.1
     Allow from ::1
   </IfModule>
</Directory>

Alias /phpMyAdmin /usr/share/phpMyAdmin

Alias /phpmyadmin /usr/share/phpMyAdmin

AddDefaultCharset UTF-8

# Apache 2.4

Require all granted

</IfModule>

# Apache 2.2

Order Deny,Allow

Deny from All

Allow from 127.0.0.1

Allow from ::1

</IfModule>

</Directory>

After updating phpMyAdmin Apache configuration file, restart Apache service to reload new settings.

service httpd restart

Step 4 – Access phpMyAdmin in Browser

Now you can access phpMyAdmin in a browser using the following URL. Change svr1.tecadmin.net with your server IP/FQDN.

http://svr1.tecadmin.net/phpMyAdmin/

Login Details: Use MySQL username and password.

Congratulation’s You have successfully installed phpMyAdmin. Using single phpMyAdmin we can manage multiple MySQL servers by adding multiple remote MySQL server. Use this article to add multiple MySQL hosts in phpMyAdmin.

Rahul

I, Rahul Kumar am the founder and chief editor of TecAdmin.net. I am a Red Hat Certified Engineer (RHCE) and working as an IT professional since 2009..

34 Comments

Ganesh Reply to Ganesh
May 5, 2019 at 12:33 am
Cannot log in to the MySQL server
I have used mysql user and password, getting above error
please help me out rahul
Mahdy Reply to Mahdy
February 6, 2019 at 1:26 pm
How to install PHPmyadmin for PHP 7.3?
Error: Package: php-tidy-5.4.16-7.el7.x86_64 (epel)
Requires: php(zend-abi) = 20100525-64
Installed: php-common-7.3.2-1.el7.remi.x86_64 (@remi-php73)
php(zend-abi) = 20180731-64
Available: php-common-5.4.16-46.el7.x86_64 (base)
php(zend-abi) = 20100525-64
Error: Package: php-tidy-5.4.16-7.el7.x86_64 (epel)
Requires: php(api) = 20100412-64
Installed: php-common-7.3.2-1.el7.remi.x86_64 (@remi-php73)
php(api) = 20180731-64
Available: php-common-5.4.16-46.el7.x86_64 (base)
php(api) = 20100412-64
Error: Package: php-mbstring-5.4.16-46.el7.x86_64 (base)
Requires: php-common(x86-64) = 5.4.16-46.el7
Installed: php-common-7.3.2-1.el7.remi.x86_64 (@remi-php73)
php-common(x86-64) = 7.3.2-1.el7.remi
Available: php-common-5.4.16-46.el7.x86_64 (base)
php-common(x86-64) = 5.4.16-46.el7
Error: Package: php-bcmath-5.4.16-46.el7.x86_64 (base)
Requires: php-common(x86-64) = 5.4.16-46.el7
Installed: php-common-7.3.2-1.el7.remi.x86_64 (@remi-php73)
php-common(x86-64) = 7.3.2-1.el7.remi
Available: php-common-5.4.16-46.el7.x86_64 (base)
php-common(x86-64) = 5.4.16-46.el7
You could try using –skip-broken to work around the problem
You could try running: rpm -Va –nofiles –nodigest
- asvns Reply to asvns
  September 5, 2019 at 4:13 pm
  Hello, have you a solution? I have same issue
- ASVNS Reply to ASVNS
  September 5, 2019 at 4:24 pm
  Hi find solution
  yum install -y –enablerepo=remi-php73 phpmyadmin
nitin Reply to nitin
December 21, 2014 at 5:15 pm
Hi,
Thanks its very useful for me ………
Kuldip Reply to Kuldip
November 7, 2014 at 7:54 am
@ PHIL
:: TO ALLOW FROM EVERY WHERE ::
## Comment below section to allow everyone
Order Allow,Deny ( Change # 1)
Allow from All (Change # 2)
Allow from 192.168.1.0/24
Allow from ::1
Hadi Reply to Hadi
October 21, 2014 at 9:53 pm
Hello
Useful article and I have translated to persian in following link
http://www.irwebhost.com/blog/
Thank you
david tobi Reply to david
October 14, 2014 at 12:01 pm
please some one should send me test on how and procedure on how i can install my phpmy on my computer have been finding it difficult please

« Previous 1 2 3

Prerequsities

Step 1 – Enable Remi Repository

Step 2 – Install PhpMyAdmin on CentOS

Step 3 – Configure PhpMyAdmin

Step 4 – Access phpMyAdmin in Browser

Rahul

Related Posts

34 Comments

Leave a Reply