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

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

<<�ｿｽg�ｿｽb�ｿｽv�ｿｽy�ｿｽ[�ｿｽW <<�ｿｽV�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ <<�ｿｽT�ｿｽC�ｿｽg�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ <<CentOS�ｿｽﾅ趣ｿｽ�ｿｽ�ｿｽT�ｿｽ[�ｿｽo�ｿｽ[�ｿｽ\�ｿｽz <<Scientific Linux�ｿｽﾅ趣ｿｽ�ｿｽ�ｿｽT�ｿｽ[�ｿｽo�ｿｽ[�ｿｽ\�ｿｽz

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

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

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



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

�ｿｽi�ｿｽP�ｿｽjphpMyAdmin�ｿｽC�ｿｽ�ｿｽ�ｿｽX�ｿｽg�ｿｽ[�ｿｽ�ｿｽ 
[root@fedora ~]# svn checkout https://phpmyadmin.svn.sourceforge.net/svnroot/phpmyadmin/tags/STABLE/phpMyAdmin phpmyadmin
�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@phpMyAdmin�ｿｽ_�ｿｽE�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ[�ｿｽh

[root@fedora ~]# mv phpmyadmin/ /var/www/�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽ_�ｿｽE�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ[�ｿｽh�ｿｽ�ｿｽ�ｿｽ�ｿｽphpMyAdmin�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾌ場所�ｿｽﾖ移難ｿｽ

�ｿｽi�ｿｽQ�ｿｽjphp-mysql�ｿｽC�ｿｽ�ｿｽ�ｿｽX�ｿｽg�ｿｽ[�ｿｽ�ｿｽ
phpMyAdmin�ｿｽ�ｿｽPHP�ｿｽﾅ難ｿｽ�ｿｽ�す�ｿｽ驍ｽ�ｿｽﾟ、PHP�ｿｽ�ｿｽ�ｿｽ�ｿｽMySQL�ｿｽf�ｿｽ[�ｿｽ^�ｿｽx�ｿｽ[�ｿｽX�ｿｽﾖア�ｿｽN�ｿｽZ�ｿｽX�ｿｽ�ｿｽ�ｿｽ驍ｽ�ｿｽﾟのパ�ｿｽb�ｿｽP�ｿｽ[�ｿｽW�ｿｽﾅゑｿｽ�ｿｽ�ｿｽphp-mysql�ｿｽ�ｿｽ�ｿｽC�ｿｽ�ｿｽ�ｿｽX�ｿｽg�ｿｽ[�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ
[root@fedora ~]# rpm -q php-mysql�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@php-mysql�ｿｽC�ｿｽ�ｿｽ�ｿｽX�ｿｽg�ｿｽ[�ｿｽ�ｿｽ�ｿｽm�ｿｽF
�ｿｽp�ｿｽb�ｿｽP�ｿｽ[�ｿｽW php-mysql �ｿｽﾍイ�ｿｽ�ｿｽ�ｿｽX�ｿｽg�ｿｽ[�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾄゑｿｽ�ｿｽﾜゑｿｽ�ｿｽ�ｿｽB

[root@fedora ~]# yum -y install php-mysql�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@php-mysql�ｿｽC�ｿｽ�ｿｽ�ｿｽX�ｿｽg�ｿｽ[�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽC�ｿｽ�ｿｽ�ｿｽX�ｿｽg�ｿｽ[�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾄゑｿｽ�ｿｽﾈゑｿｽ�ｿｽ鼾��ｿｽﾌゑｿｽ

�ｿｽ�ｿｽphpMyAdmin�ｿｽﾝ抵ｿｽ

�ｿｽi�ｿｽP�ｿｽjphpMyAdmin�ｿｽﾝ抵ｿｽ 
[root@fedora ~]# cp /var/www/phpmyadmin/libraries/config.default.php /var/www/phpmyadmin/config.inc.php
�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽf�ｿｽt�ｿｽH�ｿｽ�ｿｽ�ｿｽg�ｿｽﾝ抵ｿｽt�ｿｽ@�ｿｽC�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽR�ｿｽs�ｿｽ[

[root@fedora ~]# chmod 660 /var/www/phpmyadmin/config.inc.php�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽﾝ抵ｿｽt�ｿｽ@�ｿｽC�ｿｽ�ｿｽ�ｿｽﾌパ�ｿｽ[�ｿｽ~�ｿｽb�ｿｽV�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾏ更

[root@fedora ~]# mkpasswd -l 46�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@mkpasswd�ｿｽR�ｿｽ}�ｿｽ�ｿｽ�ｿｽh�ｿｽﾅ��ｿｽ�ｿｽ�ｿｽ�ｿｽ_�ｿｽ�ｿｽ�ｿｽ�ｿｽ46�ｿｽ�ｿｽ�ｿｽﾌ包ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ謫ｾ
�ｿｽ�ｿｽmkpasswd�ｿｽR�ｿｽ}�ｿｽ�ｿｽ�ｿｽh�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽQ�ｿｽ�ｿｽ
ojwelolk6gmsswpgqosameeBmtxswelzamM4wdfcfolbz>�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ_�ｿｽ�ｿｽ�ｿｽ�ｿｽ46�ｿｽ�ｿｽ�ｿｽﾌ包ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾝ抵ｿｽt�ｿｽ@�ｿｽC�ｿｽ�ｿｽ�ｿｽﾒ集�ｿｽﾅ使�ｿｽp�ｿｽ�ｿｽ�ｿｽ�ｿｽ

[root@fedora ~]# vi /var/www/phpmyadmin/config.inc.php�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽﾝ抵ｿｽt�ｿｽ@�ｿｽC�ｿｽ�ｿｽ�ｿｽﾒ集
$cfg['blowfish_secret'] = 'ojwelolk6gmsswpgqosameeBmtxswelzamM4wdfcfolbz>';�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@mkpasswd�ｿｽR�ｿｽ}�ｿｽ�ｿｽ�ｿｽh�ｿｽﾅ取得�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ_�ｿｽ�ｿｽ�ｿｽ�ｿｽ46�ｿｽ�ｿｽ�ｿｽﾌ包ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽw�ｿｽ�ｿｽ
�ｿｽ�ｿｽ�ｿｽ�ｿｽL�ｿｽﾍ��ｿｽ�ｿｽO�ｿｽC�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾌパ�ｿｽX�ｿｽ�ｿｽ�ｿｽ[�ｿｽh�ｿｽﾃ搾ｿｽ�ｿｽ�ｿｽ�ｿｽﾌ際に難ｿｽ�ｿｽ�ｿｽ�ｿｽI�ｿｽﾉ暦ｿｽ�ｿｽp�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽp�ｿｽX�ｿｽt�ｿｽ�ｿｽ�ｿｽ[�ｿｽY�ｿｽﾅゑｿｽ�ｿｽ�ｿｽA�ｿｽ�ｿｽ�ｿｽ[�ｿｽU�ｿｽﾉ難ｿｽ�ｿｽﾍ要�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾌではなゑｿｽ

$cfg['Servers'][$i]['auth_type']     = 'cookie';�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽF�ｿｽﾘ��ｿｽ�ｿｽ[�ｿｽh�ｿｽ�ｿｽN�ｿｽb�ｿｽL�ｿｽ[�ｿｽ�ｿｽﾉゑｿｽ�ｿｽ�ｿｽ

[root@fedora ~]# chown -R root.apache /var/www/phpmyadmin/�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@phpMyAdmin�ｿｽﾌ擾ｿｽ�ｿｽL�ｿｽﾒゑｿｽﾏ更

�ｿｽi�ｿｽQ�ｿｽjApache�ｿｽﾝ抵ｿｽ 
[root@fedora ~]# vi /etc/httpd/conf.d/phpmyadmin.conf�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@phpMyAdmin�ｿｽpApache�ｿｽﾝ抵ｿｽt�ｿｽ@�ｿｽC�ｿｽ�ｿｽ�ｿｽ�成
Alias /phpmyadmin /var/www/phpmyadmin

�ｿｽﾈ会ｿｽ�ｿｽﾍ難ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾌみア�ｿｽN�ｿｽZ�ｿｽX�ｿｽﾅゑｿｽ�ｿｽ�ｿｽ謔､�ｿｽﾉゑｿｽ�ｿｽ�ｿｽ鼾��ｿｽﾌみ指�ｿｽ閧ｷ�ｿｽ�ｿｽ
<Location /phpmyadmin>
    Order deny,allow
    Deny from all
    Allow from 127.0.0.1
    Allow from 192.168.1.0/24�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽl�ｿｽb�ｿｽg�ｿｽ�ｿｽ�ｿｽ[�ｿｽN�ｿｽA�ｿｽh�ｿｽ�ｿｽ�ｿｽX(�ｿｽ�ｿｽ:192.168.1.0/24)�ｿｽ�ｿｽ�ｿｽw�ｿｽ�ｿｽ
</Location>

[root@fedora ~]# /etc/rc.d/init.d/httpd reload�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@Apache�ｿｽﾝ定反�ｿｽf
httpd �ｿｽ�ｿｽ�ｿｽﾄ読み搾ｿｽ�ｿｽﾝ抵ｿｽ:                                      [  OK  ]

�ｿｽ�ｿｽ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�ｿｽ�ｿｽ�ｿｽﾉゑｿｽ�ｿｽﾄゑｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ


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

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



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