Forbidden You don t have permission to access phpmyadmin on this server

Question

Hi I have installed phpmyadmin on my centos machine and when I try to hit phpmyadmin through my browser I get this error    Forbidden You don t have permission to access  phpmyadmin  on this server    My phpmyadmin conf file has following content     phpMyAdmin - Web based MySQL browser written in php      Allows only localhost by default     But allowing phpMyAdmin to anyone other than localhost should be considered   dangerous unless properly secured by SSL  Alias  phpMyAdmin  usr share phpMyAdmin Alias  phpmyadmin  usr share phpMyAdmin    lt Directory  usr share phpMyAdmin  gt      lt IfModule mod authz core c gt         Apache 2 4       lt RequireAny gt         Require ip 127 0 0 1        Require ip   1       lt  RequireAny gt      lt  IfModule gt      lt IfModule  mod authz core c gt         Apache 2 2      Order Deny Allow      Deny from All      Allow from 127 0 0 1      Allow from   1     lt  IfModule gt   lt  Directory gt    lt Directory  usr share phpMyAdmin setup  gt      lt IfModule mod authz core c gt         Apache 2 4       lt RequireAny gt         Require ip 127 0 0 1        Require ip   1       lt  RequireAny gt      lt  IfModule gt      lt IfModule  mod authz core c gt         Apache 2 2      Order Deny Allow      Deny from All      Allow from 127 0 0 1      Allow from   1     lt  IfModule gt   lt  Directory gt     These directories do not require access over HTTP - taken from the original   phpMyAdmin upstream tarball    lt Directory  usr share phpMyAdmin libraries  gt      Order Deny Allow     Deny from All     Allow from None  lt  Directory gt    lt Directory  usr share phpMyAdmin setup lib  gt      Order Deny Allow     Deny from All     Allow from None  lt  Directory gt    lt Directory  usr share phpMyAdmin setup frames  gt      Order Deny Allow     Deny from All     Allow from None  lt  Directory gt     This configuration prevents mod security at phpMyAdmin directories from   filtering SQL etc   This may break your mod security implementation      lt IfModule mod security c gt        lt Directory  usr share phpMyAdmin  gt           SecRuleInheritance Off       lt  Directory gt    lt  IfModule gt    Kindly help me resolve this issue  Any lead is appreciated   Thanks

User · Answer

Centos 7 php install comes with the ModSecurity package installed and enabled which prevents web access to phpMyAdmin. At the end of phpMyAdmin.conf, you should find

# This configuration prevents mod_security at phpMyAdmin directories from
# filtering SQL etc.  This may break your mod_security implementation.
#
#<IfModule mod_security.c>
#    <Directory /usr/share/phpMyAdmin/>
#        SecRuleInheritance Off
#    </Directory>
#</IfModule>

which gives you the answer to the problem. By adding

    SecRuleEngine Off

in the block "Directory /usr/share/phpMyAdmin/", you can solve the 'denied access' to phpmyadmin, but you may create security issues.

User · Answer

With the latest version of phpmyadmin 5 0 2  at least   Check that the actual installation was completed correctly   Mine had been copied over into a sub folder on a linux machine rather that being at the    usr share phpmyadmin

User · Answer

Find your IP address  and replace where ever you see 127 0 0 1 with your workstation IP address you get from the link above         Require ip your workstation IP address       Allow from your workstation IP address       Require ip your workstation IP address       Allow from your workstation IP address         and in the end don t forget to restart the server  sudo systemctl restart httpd service

User · Answer

You need to follow the following steps   Find line that read follows  Require ip 127 0 0 1   Replace with your workstation IP address   Require ip 10 1 3 53   Again find the following line   Allow from 127 0 0 1   Replace as follows   Allow from 10 1 3 53   Also find deny from all and comment it in the entire file   Save and close the file Restart Apache httpd server     service httpd restart   Edit  Since this is the selected answer and gets best visibility     please also make sure that PHP is installed  otherwise you get same Forbidden error

User · Answer

On a fresh install on CENTOS7 I have tried the above methods  edit phpMyAdmin conf and add Require all granted   it still does nt work  Here is the solution   install the mod php module      sudo yum install php   then restart httpd      sudo systemctl restart httpd   and voila

User · Answer

To allow from all    Require ip 127 0 0 1  Require ip   1 Require all granted

User · Answer

First edit the file  etc httpd conf d phpMyAdmin conf and add the additional line to the directory settings    lt Directory  usr share phpMyAdmin  gt  order deny allow deny from all allow from 127 0 0 1 allow from 192 168 1 0 15  lt  Directory gt    If you wanted to allow access to everybody then you could just change it to    lt Directory  usr share phpMyAdmin  gt  order allow deny allow from all  lt  Directory gt    Allow in all sections of the file   A restart  service httpd restart  is enough to pick this up    I found this after 2 days rigorous research   find it here  and worked just right for me

User · Answer

Edit file  sudo nano  etc httpd conf d phpMyAdmin conf and replace yours with following    lt Directory  usr share phpMyAdmin  gt     AddDefaultCharset UTF-8     lt IfModule mod authz core c gt         Apache 2 4     lt  IfModule gt      lt IfModule  mod authz core c gt         Apache 2 2     lt  IfModule gt   lt  Directory gt    Restart Apache  service httpd restart   phpMyAdmin v4 0 10 8

User · Answer

None of the configuration above worked for me on my CentOS 7 server  After hours of searching  that what worked for me   Edit file phpMyAdmin conf  sudo nano  etc httpd conf d phpMyAdmin conf  And replace the existing  lt Directory gt       lt  Directory gt  node with the following    lt Directory  usr share phpMyAdmin  gt     AddDefaultCharset UTF-8      lt IfModule mod authz core c gt         Apache 2 4       lt RequireAny gt          Require ip 127 0 0 1         Require ip   1        Require all granted       lt  RequireAny gt      lt  IfModule gt      lt IfModule  mod authz core c gt         Apache 2 2      Order Deny Allow      Deny from All      Allow from 127 0 0 1      Allow from   1     lt  IfModule gt   lt  Directory gt

User · Answer

You could simply go to phpmyadmin conf file and change  deny from all  to  allow from all   Well it worked for me  hope it works for you as well

User · Answer

The problem with the answer with the most votes is it doesn t explain the reasoning for the solution   For the lines Require ip 127 0 0 1  you should instead add the ip address of the host that plans to access phpMyAdmin from a browser  For example Require ip 192 168 0 100  The Require ip 127 0 0 1 allows localhost access to phpMyAdmin   Restart apache  httpd  after making changes  I would suggest testing on localhost  or using command line tools like curl to very a http GET works  and there is no other configuration issue

[php] Forbidden :You don't have permission to access /phpmyadmin on this server

Examples related to php

Examples related to mysql

Examples related to phpmyadmin