Allow all IP to access my Secured PhpmyAdmin

September 10, 2015 19.9k views
MySQL DigitalOcean

Hey I set up my /etc/httpd/conf.d/phpMyAdmin.conf to allow only specific IP to access my phpMyAdmin now my C# application requires that I should allow all the I.P. How will do it? any suggestion is much appreciated. Im using Centos 6.5 and MySQL 5.6xx

1 Answer

It's unlikely that you need to allow all IP addresses access to phpMyAdmin. Instead it is more secure to whitelist the specific IP addresses that may need access in your phpMyAdmin.conf You can use more than one address. For instance:

   <IfModule mod_authz_core.c>
     # Apache 2.4
      Require ip your.local.IP.address
      Require ip
      Require ip
      Require ip ::1
   <IfModule !mod_authz_core.c>
     # Apache 2.2
     Order Deny,Allow
     Deny from All
     Allow from your.local.IP.address
     Allow from
     Allow from
     Allow from ::1

If you really need to allow all all IP addresses to access it, you can comment out the entire RequireAny section and change Deny from All to Allow from All

Remember to restart Apache after making any changes:

  • sudo service httpd restart
  • Hello-

    I am facing a strange issue that I am unable to figure out; my phpMyAdmin URL in the browser just gives the phpMyAdmin logo plus a welcome message and nothing else !

    I tried to change phpMyAdmin.conf several times and in the last version I only wrote in it the following lines and I still see the same issue, any ideas?

    Alias /phpMyAdmin /usr/share/phpMyAdmin
    Alias /phpmyadmin /usr/share/phpMyAdmin
    <Directory /usr/share/phpMyAdmin>
    AllowOverride None
    Options None
    Allow from All
    Require all granted


Have another answer? Share your knowledge.