Menu

How to Install PhpMyAdmin 4.8 on CentOS/RHEL 7/6

Written by , Updated on July 13, 2018
Databases , , ,

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.

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.

phpMyAdmin-Login-Screen

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
Rahul
Connect on Facebook Connect on Twitter Connect on Google+

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..

Related Posts

31 Comments

  1. 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

  2. nitin Reply to nitin
    December 21, 2014 at 5:15 pm

    Hi,
    Thanks its very useful for me ………

  3. 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

  4. 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

  5. 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

  6. Phil Reply to Phil
    October 11, 2014 at 11:40 am

    Works perfect!

    Thanks a lot on this article.

    PS: how to setup to access from anywhere?

  7. satya Reply to satya
    September 30, 2014 at 1:14 pm

    I am getting this error
    phpMyAdmin – Error
    The json extension is missing. Please check your PHP configuration.

    I am using centOs.

  8. Aleksey Reply to Aleksey
    September 25, 2014 at 11:40 am

    I have a 404 erorr on page /phpMyAdmin/

  9. james Reply to james
    September 1, 2014 at 8:02 am

    Thank you.

  10. Daniel Reply to Daniel
    July 1, 2014 at 10:29 am

    When I attemp to install Remi it says that it could not ressolve the host, HELP

  11. CentOS_Guru Reply to CentOS_Guru
    July 1, 2014 at 4:50 am

    Hi!
    I have successfully installed it and when I try to login. I enter my credentials. It loads and still stay at the login page.

    It never change the page.

  12. mjdj1999 Reply to mjdj1999
    June 28, 2014 at 5:50 pm

    I just installed on Centos 6 on a dedicated server. The install following these instructions went flawlessly without errors. I also followed the directions for PHP and Apache. THANK YOU! However, I cannot view phpMyAdmin in my browser. I have tried going to it via “FQDN/phpMyAdmin/” and by “http://my.IP/phpMyAdmin/” and neither works. I know its probably something I did in Step. 3 but not sure how to configure this file for web access.

    Can anyone provide a phpMyAdmin.conf scenario that will allow me to access via web??

    Thank you in advance!

    This is a great article and is laid out for a very easy installation. Thank you!

    • Rahul Rahul Reply to Rahul
      June 30, 2014 at 3:49 am

      HI mjdj1999,

      Please change “Allow from 192.168.1.0/24” in phpMyAdmin.conf file with your LAN ip or system ip. If you have any confustion about which ip to use. You can open it publicly like “Allow from all“

  13. tom Reply to tom
    June 25, 2014 at 5:23 am

    please how can I know mysql user and password?

  14. Fahad Tariq Reply to Fahad
    June 2, 2014 at 7:00 am

    When I do the first step, I get this
    Retrieving http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
    warning: /var/tmp/rpm-tmp.9YYBPo: Header V3 DSA/SHA1 Signature, key ID 00f97f56: NOKEY
    error: Failed dependencies:
    epel-release >= 6 is needed by remi-release-6.5-1.el6.remi.noarch

    So I dont continue. Please tell me how to fix it?

  15. Crs Reply to Crs
    May 23, 2014 at 7:49 am

    Thanks for the tutorial, it was very simple and worked great for me.

  16. sj Reply to sj
    April 9, 2014 at 7:37 am

    nice to read your article it insatll sucessfully but what will be the user name & password to login it??? please reply

  17. Smithd178 Reply to Smithd178
    March 31, 2014 at 6:27 am

    Very nice!

  18. Namrata Reply to Namrata
    March 18, 2014 at 7:35 am

    Thanks for providing steps to configure PHPMyAdmin… its work for me without any hurdles.
    Cheers…

  19. dana Reply to dana
    March 4, 2014 at 8:00 am

    thx, it works.

  20. Kern Reply to Kern
    February 18, 2014 at 5:40 am

    I’m running into a problem in step #2 : yum install phpMyAdmin
    Where “conflicts” are found!!!
    Please help.
    Thanks
    Kern —

    Transaction Check Error:
    file /usr/share/mysql/charsets/README from install of mysql-libs-5.1.73-3.el6_5.i686 conflicts with file from package MySQL-server-5.5.35-1.linux2.6.i386
    file /usr/share/mysql/charsets/Index.xml from install of mysql-libs-5.1.73-3.el6_5.i686 conflicts with file from package MySQL-server-5.5.35-1.linux2.6.i386
    file /usr/share/mysql/charsets/armscii8.xml from install of mysql-libs-5.1.73-3.el6_5.i686 conflicts with file from package MySQL-server-5.5.35-1.linux2.6.i386
    file /usr/share/mysql/charsets/ascii.xml from install of mysql-libs-5.1.73-3.el6_5.i686 conflicts with file from package MySQL-server-5.5.35-1.linux2.6.i386
    …

  21. Brad Reply to Brad
    November 18, 2013 at 11:39 am

    Thank you for sharing this article…..

  22. Ahmed Shaaban Elgendy Reply to Ahmed
    October 29, 2013 at 8:48 am

    really, very good

  23. Daniel Reply to Daniel
    September 18, 2013 at 12:26 pm

    THANKS!

  24. Sahil Singh Reply to Sahil
    September 13, 2013 at 3:59 pm

    Hello admin

    I have followed above steps, but I m getting 403 access denied error…… please help me

    Thanks in advance

  25. Petrus Reply to Petrus
    September 9, 2013 at 6:22 pm

    Dear Rahul:

    Thank you for getting this up I was in a big hurry and found it comprehensive and useful.

    Best,

    P.

Leave a Reply

All rights reserved. © 2013-2018 TecAdmin.net. This site uses cookies. By using this website you agree our term and services