phpMyAdmin allow remote users

Question

I need to modify the file  etc httpd conf d phpMyAdmin conf in order to allow remote users  not only localhost  to login    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

User · Answer

My answer is based on getting a 403 error although I had all of the Apache settings mentioned in the other answers correct.

It was a fresh Centos 7 server and it turned out that the issue was not the Apache settings but the fact that the PhpMyAdmin did not serve at all. The solution was to install php and add the php directive to apache.conf:

sudo yum install php php-mysql
vim /etc/httpd/conf/httpd.conf add something like
DirectoryIndex index.php index.phtml index.html index.htm to serve php index files also and then restart apache

Don't forget to restart Apache server to take effect - systemctl restart httpd.service

I hope this helps. I first thought my issue was Apache directives, so I post my solution here.

User · Answer

Replace the contents of the first  lt directory gt  tag   Remove    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    And place this instead    lt Directory  usr share phpMyAdmin  gt   Order allow deny  Allow from all  lt  Directory gt    Don t forget to restart Apache afterwards

User · Answer

The other answers so far seem to advocate the complete replacement of the  lt Directory  gt  block  this is not needed and may remove extra settings like the  AddDefaultCharset UTF-8  now included   To allow remote access you need to add 1 line to the 2 4 config block or change 2 lines in the 2 2  depending on your apache version     lt Directory  usr share phpMyAdmin  gt     AddDefaultCharset UTF-8      lt IfModule mod authz core c gt         Apache 2 4       lt RequireAny gt          ADD following line         Require all granted        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       CHANGE following 2 lines       Order Allow Deny      Allow from All      Allow from 127 0 0 1      Allow from   1     lt  IfModule gt   lt  Directory gt

User · Answer

Try this  Replace    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    With this    lt Directory   usr share phpMyAdmin   gt      Options Indexes FollowSymLinks MultiViews     AllowOverride all         Order Allow Deny      Allow from all  lt  Directory gt    Add the following line for ease of access   Alias  phpmyadmin  usr share phpMyAdmin

User · Answer

Just comment all lines in first Directory  Or you can remove these lines  but better to keep in case later you want to add some restrictions  you will uncomment     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

User · Answer

use this it got fixed for me  over centOS 7    lt Directory  usr share phpMyAdmin  gt  Options Indexes FollowSymLinks MultiViews AllowOverride all Require all granted  lt  Directory gt

User · Answer

My setup was a little different using XAMPP  in httpd-xampp conf I had to make the following change    Alias  phpmyadmin  C  xampp phpMyAdmin    lt Directory  C  xampp phpMyAdmin  gt      AllowOverride AuthConfig     Require local     ErrorDocument 403  error XAMPP FORBIDDEN html var  lt  Directory gt    change to  Alias  phpmyadmin  C  xampp phpMyAdmin    lt Directory  C  xampp phpMyAdmin  gt      AllowOverride AuthConfig      makes it so I can config the database from anywhere      change the line below     Require all granted     ErrorDocument 403  error XAMPP FORBIDDEN html var  lt  Directory gt    I need to state that I m brand new at this so I m just hacking around but this is how I got it working

[php] phpMyAdmin allow remote users

Examples related to php

Examples related to mysql

Examples related to phpmyadmin

Examples related to mariadb