phpMyAdminのインストール(PHP Ver5.6)

phpMyAdmin というパッケージをインストールして、WebブラウザでMySQLの操作ができるようにします。

１．PHP Ver.5.6に対応したPHPMyAdminのインストールと設定します。

# yum list --enablerepo=remi,remi-php56 phpMyAdmin
読み込んだプラグイン:fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
 * base: ftp.iij.ad.jp
 * epel: ftp.iij.ad.jp
 * extras: ftp.iij.ad.jp
 * remi: mirrors.thzhost.com
 * remi-php56: mirrors.thzhost.com
 * remi-safe: mirrors.thzhost.com
 * updates: ftp.iij.ad.jp
利用可能なパッケージ
phpMyAdmin.noarch             4.4.15.5-1.el6.remi              @remi

# yum --enablerepo=remi,remi-php56 install phpMyAdmin php-mcrypt php-mysqlnd
# vi /etc/httpd/conf.d/phpMyAdmin.conf
     1  # phpMyAdmin - Web based MySQL browser written in php
     2  #
     3  # Allows only localhost by default
     4  #
     5  # But allowing phpMyAdmin to anyone other than localhost should be considered
     6  # dangerous unless properly secured by SSL
     7
     8  Alias /phpMyAdmin /usr/share/phpMyAdmin
     9  Alias /phpmyadmin /usr/share/phpMyAdmin
    10
    11  <Directory /usr/share/phpMyAdmin/>
    12     AddDefaultCharset UTF-8
    13
    14     <IfModule mod_authz_core.c>
    15       # Apache 2.4
    16       Require local
    17     </IfModule>
    18     <IfModule !mod_authz_core.c>
    19       # Apache 2.2
    20       Order Deny,Allow
    21       Deny from All
    22       Allow from 127.0.0.1 192.168.21.0/24
        // # アクセス許可IP追記  
    23       Allow from ::1
    24     </IfModule>
    25  </Directory>
    26
# /etc/rc.d/init.d/httpd reload 
Reloading httpd: [ OK ]

# yum list --enablerepo=remi,remi-php56 phpMyAdmin

読み込んだプラグイン:fastestmirror, refresh-packagekit, security

Loading mirror speeds from cached hostfile

* base: ftp.iij.ad.jp

* epel: ftp.iij.ad.jp

* extras: ftp.iij.ad.jp

* remi: mirrors.thzhost.com

* remi-php56: mirrors.thzhost.com

* remi-safe: mirrors.thzhost.com

* updates: ftp.iij.ad.jp

利用可能なパッケージ

phpMyAdmin.noarch 4.4.15.5-1.el6.remi @remi

# yum --enablerepo=remi,remi-php56 install phpMyAdmin php-mcrypt php-mysqlnd

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

1 # phpMyAdmin - Web based MySQL browser written in php

2 #

3 # Allows only localhost by default

4 #

5 # But allowing phpMyAdmin to anyone other than localhost should be considered

6 # dangerous unless properly secured by SSL

8 Alias /phpMyAdmin /usr/share/phpMyAdmin

9 Alias /phpmyadmin /usr/share/phpMyAdmin

11 <Directory /usr/share/phpMyAdmin/>

12 AddDefaultCharset UTF-8

14 <IfModule mod_authz_core.c>

15 # Apache 2.4

16 Require local

17 </IfModule>

18 <IfModule !mod_authz_core.c>

19 # Apache 2.2

20 Order Deny,Allow

21 Deny from All

22 Allow from 127.0.0.1 192.168.21.0/24

// # アクセス許可IP追記

23 Allow from ::1

24 </IfModule>

25 </Directory>

# /etc/rc.d/init.d/httpd reload

Reloading httpd: [ OK ]

２．php 5.3のphpMyAdmin

# php -v
PHP 5.3.3 (cli) (built: Feb 9 2016 10:36:17)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
# yum --enablerepo=epel list phpMyAdmin
読み込んだプラグイン:fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
epel/metalink                                | 4.5 kB     00:00
 * base: ftp.nara.wide.ad.jp
 * epel: ftp.riken.jp
 * extras: ftp.nara.wide.ad.jp
 * remi-safe: remi.kazukioishi.net
 * updates: ftp.nara.wide.ad.jp
base                                         | 3.7 kB     00:00
epel                                         | 4.3 kB     00:00
epel/primary_db                              | 5.8 MB     00:00
extras                                       | 3.4 kB     00:00
remi-safe                                    | 2.9 kB     00:00
remi-safe/primary_db                         | 242 kB     00:00
updates                                      | 3.4 kB     00:00
updates/primary_db                           | 3.9 MB     00:00
利用可能なパッケージ
phpMyAdmin.noarch               4.0.10.14-1.el6                epel