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

phpmyadmin是mysql/mariadb的网页版管理工具。

安装phpMyAdmin

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

#yum install epel-release #yum install phpMyAdmin  php-mbstring php-mcrypt

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

配置phpMyAdmin

1. 设置cookie加密字符串

#vi /usr/share/phpMyAdmin/libraries/config.default.PHP

$cfg[‘blowfish_secret’] = ‘blog.csdn.net.blog.csdn.net.blog.csdn.net.blog.csdn.net’;

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

2. 设置session文件夹权限

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

#chmod -R 777 /var/lib/php/session

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

#vi /etc/httpd/conf.d/phpMyAdmin.conf

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

[root@localhost phpMyAdmin]# cat /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 SSLAlias /phpMyAdmin /usr/share/phpMyAdminAlias /phpmyadmin /usr/share/phpMyAdmin<Directory /usr/share/phpMyAdmin/>   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/phpMyAdmin/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># 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>

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