CentOS6/7上phpmyadmin安装和配置总结 配合apache2.4

epel库里面包含了@L_637_0@myAdmin，可直接yum安装使用。

#yum install epel-release 
#yum install @L_637_0@myAdmin  PHP-mbString PHP-mcrypt

@L_637_0@myAdmin默认的安装目录:/usr/share/@L_637_0@myAdmin
创建的配置文件:/etc/httpd/conf.d/@L_637_0@myAdmin.conf

配置@L_637_0@myAdmin

1. 设置cookie加密字符串

#vi /usr/share/@L_637_0@myAdmin/libraries/config.default.PHP

加密字符串推荐设置成32位，太短的话@L_637_0@myAdmin仍然有警告。

2. 设置session文件夹权限

不设置权限，会有错误提示。

#chmod -R apache:apache /var/lib/PHP/session

其中apache是httpd服务器的用户。

3. 放开IP限制（适用于apache 2.4）

#vi /etc/httpd/conf.d/@L_637_0@myAdmin.conf

注释这两行
require ip 127.0.0.1
require ip ::1
加上require all granted

[root@localhost @L_637_0@myAdmin]# cat /etc/httpd/conf.d/@L_637_0@myAdmin.conf
# @L_637_0@myAdmin - Web based MysqL browser written in PHP
#
# Allows only localhost by default
#
# But allowing @L_637_0@myAdmin to anyone other than localhost should be considered
# dangerous unless properly secured by SSL

Alias /@L_637_0@myAdmin /usr/share/@L_637_0@myAdmin
Alias /@L_637_0@myadmin /usr/share/@L_637_0@myAdmin

<Directory /usr/share/@L_637_0@myAdmin/>
   AddDefaultCharset UTF-8

   <IfModule mod_authz_core.c>
     # Apache 2.4
     <requireAny>
       #require ip 127.0.0.1
       #require ip ::1
        require all granted
     </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/@L_637_0@myAdmin/setup/>
   <IfModule mod_authz_core.c>
     # Apache 2.4
     <requireAny>
       #require ip 127.0.0.1
       #require ip ::1
        require all granted
     </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>

# @R_618_8270@ directories do not require access over http - taken from the original
# @L_637_0@myAdmin upstream tarball
#
<Directory /usr/share/@L_637_0@myAdmin/libraries/>
    Order Deny,Allow
    Deny from All
    Allow from None
</Directory>

<Directory /usr/share/@L_637_0@myAdmin/setup/lib/>
    Order Deny,Allow
    Deny from All
    Allow from None
</Directory>

<Directory /usr/share/@L_637_0@myAdmin/setup/frames/>
    Order Deny,Allow
    Deny from All
    Allow from None
</Directory>

# This configuration prevents mod_security at @L_637_0@myAdmin directories from
# filtering sql etc. This may break your mod_security implementation.
#
#<IfModule mod_security.c>
# <Directory /usr/share/@L_637_0@myAdmin/>
# SecruleInheritance Off
# </Directory>
#</IfModule>

设置后，就可以远程打开@L_637_0@myadmin的网址，输入MysqL/mariadb的用户名和密码，即可管理数据库。