RHEL / CentOS / Fedora 安装 phpMyAdmin

Sam Tang

11 years ago

phpMyAdmin 是一个网页接口的 MySQL 及 MariaDB 管理工具, 它提供给用户一个简单易用的接口管理数据库, 以下是 RHEL, CentOS 及 Fedora 用 Yum 安装 phpMyAdmin 的方法:

1. 安装 Remi Repository

phpMyAdmin 的更新套件放在 remi repository, 用以下指令安装:

RHEL / CentOS 7:
# rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-7.rpm

RHEL / CentOS 6:
# rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm

RHEL / CentOS 5:
# rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm

Fedora 20:
# rpm -Uvh http://rpms.famillecollet.com/remi-release-20.rpm

Fedora 19:
# rpm -Uvh http://rpms.famillecollet.com/remi-release-19.rpm

Fedora 18:
# rpm -Uvh http://rpms.famillecollet.com/remi-release-18.rpm

2. 安装 phpMyAdmin

安装 Remi Repository 后, 用 Yum 安装 phpMyAdmin:

# yum –enablerepo=remi install phpMyAdmin

3. 设定 phpMyAdmin
phpMyAdmin 默认只允许 localhost 连接, 如果想开放给外部使用, 需要修改 phpMyAdmin 的设定, 开启:

/etc/httpd/conf.d/phpMyAdmin.conf

将里面区块下面的 Allow 及 Deny 改成这样:

## Comment below section to allow everyone 
<Directory /usr/share/phpMyAdmin/>
    <IfModule !mod_authz_core.c>
     Order Allow,Deny
     Allow from All
     Deny from None
   </IfModule>
</Directory>

## Comment below section to allow everyone

Order Allow,Deny

Allow from All

Deny from None

</IfModule>

</Directory>

储存盘案后重新启动 Apache:

# service httpd restart

最后便可以透过 http://server-ip/phpMyAdmin 存取 phpMyAdmin, 登入是用 MySQL/MariaDB 的帐号及密码。

你可能感兴趣的内容