MySQL�ｿｽpGUI�ｿｽﾝ抵ｿｽc�ｿｽ[�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ(phpMyAdmin)

�ｿｽﾅ終�ｿｽX�ｿｽV�ｿｽ�ｿｽ�ｿｽF 2020.12.29

�ｿｽ�ｿｽ�ｿｽT�ｿｽv

phpMyAdmin�ｿｽｱ難ｿｽ�ｿｽ�ｿｽ�ｿｽﾄ、MySQL�ｿｽﾌ托ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽWeb�ｿｽu�ｿｽ�ｿｽ�ｿｽE�ｿｽU�ｿｽ繧ｩ�ｿｽ�ｿｽs�ｿｽﾈゑｿｽ�ｿｽ�ｿｽ謔､�ｿｽﾉゑｿｽ�ｿｽ�ｿｽB

�ｿｽ�ｿｽWeb�ｿｽT�ｿｽ[�ｿｽo�ｿｽ[+PHP�ｿｽAMySQL�ｿｽf�ｿｽ[�ｿｽ^�ｿｽx�ｿｽ[�ｿｽX�ｿｽ�ｿｽ�ｿｽ\�ｿｽz�ｿｽﾏでゑｿｽ�ｿｽ驍ｱ�ｿｽ�ｿｽ



�ｿｽ�ｿｽphpMyAdmin�ｿｽC�ｿｽ�ｿｽ�ｿｽX�ｿｽg�ｿｽ[�ｿｽ�ｿｽ

EPEL�ｿｽ�ｿｽ�ｿｽ|�ｿｽW�ｿｽg�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ(EPEL)�ｿｽ�ｿｽ�ｿｽQ�ｿｽﾆゑｿｽ�ｿｽ�ｿｽEPEL�ｿｽ�ｿｽ�ｿｽ|�ｿｽW�ｿｽg�ｿｽ�ｿｽ�ｿｽｱ難ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽCentOS7�ｿｽﾌ場合

[root@centos ~]# yum -y install phpMyAdmin�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@phpMyAdmin�ｿｽC�ｿｽ�ｿｽ�ｿｽX�ｿｽg�ｿｽ[�ｿｽ�ｿｽ

�ｿｽ�ｿｽApache�ｿｽﾝ抵ｿｽ

[root@centos ~]# vi /etc/httpd/conf.d/phpMyAdmin.conf�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@phpMyAdmin�ｿｽpApache�ｿｽﾝ抵ｿｽt�ｿｽ@�ｿｽC�ｿｽ�ｿｽ�ｿｽﾒ集
<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 ip 192.168.1.0/24�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽﾇ会ｿｽ(�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽl�ｿｽb�ｿｽg�ｿｽ�ｿｽ�ｿｽ[�ｿｽN(�ｿｽ�ｿｽ:192.168.1.0/24)�ｿｽ�ｿｽ�ｿｽ�ｿｽﾌア�ｿｽN�ｿｽZ�ｿｽX�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ)
     </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
     Allow from 192.168.1.0/24�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽﾇ会ｿｽ(�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽl�ｿｽb�ｿｽg�ｿｽ�ｿｽ�ｿｽ[�ｿｽN(�ｿｽ�ｿｽ:192.168.1.0/24)�ｿｽ�ｿｽ�ｿｽ�ｿｽﾌア�ｿｽN�ｿｽZ�ｿｽX�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ)
   </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 ip 192.168.1.0/24�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽﾇ会ｿｽ(�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽl�ｿｽb�ｿｽg�ｿｽ�ｿｽ�ｿｽ[�ｿｽN(�ｿｽ�ｿｽ:192.168.1.0/24)�ｿｽ�ｿｽ�ｿｽ�ｿｽﾌア�ｿｽN�ｿｽZ�ｿｽX�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ)
     </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
     Allow from 192.168.1.0/24�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽﾇ会ｿｽ(�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽl�ｿｽb�ｿｽg�ｿｽ�ｿｽ�ｿｽ[�ｿｽN(�ｿｽ�ｿｽ:192.168.1.0/24)�ｿｽ�ｿｽ�ｿｽ�ｿｽﾌア�ｿｽN�ｿｽZ�ｿｽX�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ)
   </IfModule>
</Directory>

[root@centos ~]# systemctl reload httpd�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@Apache�ｿｽﾝ定反�ｿｽf�ｿｽ�ｿｽCentOS7�ｿｽﾌ場合


�ｿｽ�ｿｽphpMyAdmin�ｿｽm�ｿｽF

http://�ｿｽT�ｿｽ[�ｿｽo�ｿｽ[�ｿｽ�ｿｽ/phpmyadmin/�ｿｽﾖア�ｿｽN�ｿｽZ�ｿｽX�ｿｽ�ｿｽ�ｿｽﾄ、phpMyAdmin�ｿｽﾌ��ｿｽ�ｿｽO�ｿｽC�ｿｽ�ｿｽ�ｿｽ�ｿｽﾊゑｿｽ�ｿｽ\�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ驍ｱ�ｿｽ�ｿｽ
MySQL�ｿｽﾉ登�ｿｽ^�ｿｽ�ｿｽ�ｿｽ�ｿｽﾄゑｿｽ�ｿｽ�ｿｽA�ｿｽJ�ｿｽE�ｿｽ�ｿｽ�ｿｽg�ｿｽﾅ��ｿｽ�ｿｽO�ｿｽC�ｿｽ�ｿｽ�ｿｽﾅゑｿｽ�ｿｽ驍ｱ�ｿｽ�ｿｽ

�ｿｽ�ｿｽWeb�ｿｽu�ｿｽ�ｿｽ�ｿｽE�ｿｽU�ｿｽﾌク�ｿｽb�ｿｽL�ｿｽ[�ｿｽ@�ｿｽ\�ｿｽ�ｿｽL�ｿｽ�ｿｽ�ｿｽﾉゑｿｽ�ｿｽﾄゑｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ

�ｿｽ�ｿｽmcrypt �ｿｽg�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ[�ｿｽh�ｿｽs�ｿｽﾂ対擾ｿｽ

phpMyAdmin�ｿｽﾌ��ｿｽ�ｿｽO�ｿｽC�ｿｽ�ｿｽ�ｿｽ�ｿｽﾊで「mcrypt �ｿｽg�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ[�ｿｽh�ｿｽﾅゑｿｽ�ｿｽﾜゑｿｽ�ｿｽ�ｿｽBPHP �ｿｽﾌ設抵ｿｽ�ｿｽ�ｿｽm�ｿｽF�ｿｽ�ｿｽ�ｿｽﾄゑｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽv�ｿｽﾆゑｿｽ�ｿｽ�ｿｽ�ｿｽx�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽb�ｿｽZ�ｿｽ[�ｿｽW�ｿｽ�ｿｽ�ｿｽ\�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ鼾��ｿｽﾌ対擾ｿｽ�ｿｽB 
EPEL�ｿｽ�ｿｽ�ｿｽ|�ｿｽW�ｿｽg�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ(EPEL)�ｿｽ�ｿｽ�ｿｽQ�ｿｽﾆゑｿｽ�ｿｽ�ｿｽEPEL�ｿｽ�ｿｽ�ｿｽ|�ｿｽW�ｿｽg�ｿｽ�ｿｽ�ｿｽｱ難ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽCentOS7�ｿｽﾌ場合

[root@centos ~]# yum -y install php-mcrypt�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@php-mcrypt�ｿｽC�ｿｽ�ｿｽ�ｿｽX�ｿｽg�ｿｽ[�ｿｽ�ｿｽ

[root@centos ~]# systemctl reload httpd�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@Apache�ｿｽﾝ定反�ｿｽf�ｿｽ�ｿｽCentOS7�ｿｽﾌ場合
http://�ｿｽT�ｿｽ[�ｿｽo�ｿｽ[�ｿｽ�ｿｽ/phpmyadmin/�ｿｽﾖア�ｿｽN�ｿｽZ�ｿｽX�ｿｽ�ｿｽ�ｿｽﾄ、�ｿｽumcrypt �ｿｽg�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ[�ｿｽh�ｿｽﾅゑｿｽ�ｿｽﾜゑｿｽ�ｿｽ�ｿｽBPHP �ｿｽﾌ設抵ｿｽ�ｿｽ�ｿｽm�ｿｽF�ｿｽ�ｿｽ�ｿｽﾄゑｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽv�ｿｽﾆゑｿｽ�ｿｽ�ｿｽ�ｿｽx�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽb�ｿｽZ�ｿｽ[�ｿｽW�ｿｽ�ｿｽ�ｿｽ\�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾈゑｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ


�ｿｽ�ｿｽ�ｿｽﾖ連�ｿｽR�ｿｽ�ｿｽ�ｿｽe�ｿｽ�ｿｽ�ｿｽc

<!�ｿｽ\�ｿｽe�ｿｽL�ｿｽX�ｿｽg�ｿｽﾌみゑｿｽ4�ｿｽs�ｿｽ\�ｿｽ�ｿｽ�ｿｽﾉ追会ｿｽ�ｿｽ�ｿｽC�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ\>



�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾌペ�ｿｽ[�ｿｽW�ｿｽﾌト�ｿｽb�ｿｽv�ｿｽﾖ戻ゑｿｽ
�ｿｽv�ｿｽ�ｿｽ�ｿｽC�ｿｽo�ｿｽV�ｿｽ[�ｿｽ|�ｿｽ�ｿｽ�ｿｽV�ｿｽ[
centossrv.com