phpMyAdmin允许远程用户

我需要修改文件/etc/httpd/conf.d/phpMyAdmin.conf为了允许远程用户(不仅仅是本地主机)登录

# 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
<Directory /usr/share/phpMyAdmin/>
   <IfModule mod_authz_core.c>
     # Apache 2.4
     <RequireAny>
       Require ip 127.0.0.1
       Require ip ::1
     </RequireAny>
   </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>
<Directory /usr/share/phpMyAdmin/setup/>
   <IfModule mod_authz_core.c>
     # Apache 2.4
     <RequireAny>
       Require ip 127.0.0.1
       Require ip ::1
     </RequireAny>
   </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>
# These directories do not require access over HTTP - taken from the original
# phpMyAdmin upstream tarball
#
<Directory /usr/share/phpMyAdmin/libraries/>
    Order Deny,Allow
    Deny from All
    Allow from None
</Directory>
<Directory /usr/share/phpMyAdmin/setup/lib/>
    Order Deny,Allow
    Deny from All
    Allow from None
</Directory>
<Directory /usr/share/phpMyAdmin/setup/frames/>
    Order Deny,Allow
    Deny from All
    Allow from None
</Directory>
# 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>

到目前为止，其他答案似乎主张完全替换块，这是不需要的，可能会删除额外的设置，如'AddDefaultCharset UTF-8'现在包含。

2021

更新

配置文件现在简化了，只需要添加一行:

<Directory /usr/share/phpMyAdmin/>
   AddDefaultCharset UTF-8
   Require local
   # ADD following line:
   Require all granted
</Directory>

原始回答

要允许远程访问，您需要在2.4配置块中添加1行或在2.2中更改2行(取决于您的apache版本):

<Directory /usr/share/phpMyAdmin/>
   AddDefaultCharset UTF-8
   <IfModule mod_authz_core.c>
     # Apache 2.4
     <RequireAny>
       # ADD following line:
       Require all granted
       Require ip 127.0.0.1
       Require ip ::1
     </RequireAny>
   </IfModule>
   <IfModule !mod_authz_core.c>
     # Apache 2.2
     # CHANGE following 2 lines:
     Order Allow,Deny
     Allow from All
     Allow from 127.0.0.1
     Allow from ::1
   </IfModule>
</Directory>

使用这个，它为我修复了，在centOS 7

<Directory /usr/share/phpMyAdmin/>
Options Indexes FollowSymLinks MultiViews
AllowOverride all
Require all granted
</Directory>

替换第一个<directory>标签的内容

删除:

<Directory /usr/share/phpMyAdmin/>
 <IfModule mod_authz_core.c>
  # Apache 2.4
  <RequireAny>
    Require ip 127.0.0.1
    Require ip ::1
  </RequireAny>
 </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>

并将此替换为:

<Directory /usr/share/phpMyAdmin/>
 Order allow,deny
 Allow from all
</Directory>

试试这个

代替

<Directory /usr/share/phpMyAdmin/>
    <IfModule mod_authz_core.c>
        # Apache 2.4
        <RequireAny>
            Require ip 127.0.0.1
            Require ip ::1
        </RequireAny>
    </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>

与这个:

<Directory "/usr/share/phpMyAdmin/">
    Options Indexes FollowSymLinks MultiViews
    AllowOverride all
        Order Allow,Deny 
    Allow from all
</Directory>

为方便访问添加以下行:

Alias /phpmyadmin /usr/share/phpMyAdmin

使用XAMPP时，我的设置略有不同。在httpd-xampp.conf中，我必须做以下更改。

Alias /phpmyadmin "C:/xampp/phpMyAdmin/"
<Directory "C:/xampp/phpMyAdmin">
    AllowOverride AuthConfig
    Require local
    ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var
</Directory>

改变

Alias /phpmyadmin "C:/xampp/phpMyAdmin/"
<Directory "C:/xampp/phpMyAdmin">
    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
</Directory>

我需要说明的是，我在这方面是全新的，所以我只是在摸索，但这就是我如何让它工作的

注释第一个目录中的所有行。或者您可以删除这些行，但最好保留，以防以后您想添加一些限制，您将取消注释。

#<Directory /usr/share/phpMyAdmin/>
#   <IfModule mod_authz_core.c>
#     # Apache 2.4
#     <RequireAny>
#       Require ip 127.0.0.1
#       Require ip ::1
#     </RequireAny>
#   </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>

我的答案是基于得到403错误，尽管我在其他答案中提到的所有Apache设置都是正确的。

这是一个新的Centos 7服务器，结果发现问题不是Apache设置，而是PhpMyAdmin根本没有服务。解决方案是安装php并将php指令添加到apache.conf:

vim/etc/httpd/conf/httpd.conf添加像
DirectoryIndex index.php索引。索引。html索引。htm提供PHP索引文件然后重新启动apache

不要忘记重启Apache服务器使其生效- systemctl restart httpd.service

我希望这对你有帮助。我首先认为我的问题是Apache的指令，所以我张贴我的解决方案在这里。

phpMyAdmin allow remote users

更新配置文件现在简化了，只需要添加一行: <Directory /usr/share/phpMyAdmin/> AddDefaultCharset UTF-8 Require local # ADD following line: Require all granted </Directory>

原始回答

更新
配置文件现在简化了，只需要添加一行:

`<Directory /usr/share/phpMyAdmin/> AddDefaultCharset UTF-8 Require local # ADD following line: Require all granted </Directory>`