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 SSL
Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /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的用户名和密码,即可管理数据库。