{"id":65,"date":"2014-01-17T02:45:20","date_gmt":"2014-01-16T17:45:20","guid":{"rendered":"http:\/\/lovelinux.mydns.jp\/?p=65"},"modified":"2014-03-21T18:02:58","modified_gmt":"2014-03-21T09:02:58","slug":"65","status":"publish","type":"post","link":"https:\/\/lovelinux.mydns.jp\/?p=65","title":{"rendered":"CentOS\u306b\u6700\u65b0\u7248\u306ephpMyAdmin\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb"},"content":{"rendered":"<h3>yum \u3067 phpMyAdmin \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n<p>\u307e\u305a\u306f\u3001CentOS\u306e\u30ea\u30dd\u30b8\u30c8\u30ea\u306b\u542b\u307e\u308c\u308bphpMyAdmin\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<\/p>\n<p>[bash]<br \/>\n$ sudo yum install phpmyadmin<br \/>\n[\/bash]<\/p>\n<p>\u3053\u308c\u3067\u3001http:\/\/localhost\/phpmyadmin\u3000\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3068\u3001phpmyadmin\u304c\u8868\u793a\u3055\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p>\u305f\u3060\u3001\u3053\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306f\u304b\u306a\u308a\u53e4\u3044\u3082\u306e\u306a\u306e\u3067\u3001\u6700\u65b0\u7248\u306b\u3057\u307e\u3057\u3087\u3046\u3002<br \/>\nyum \u3067 phpmyadmin\u3092\u5c0e\u5165\u3057\u305f\u3053\u3068\u306b\u3088\u308a\u3001Apache\u306b\u5bfe\u3059\u308bphpmyadmin\u306e\u8a2d\u5b9a\u306f\u5b8c\u4e86\u3057\u3066\u3044\u307e\u3059\u306e\u3067\u3001\u65e2\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3042\u308bphpmyadmin\u306e\u30d5\u30a9\u30eb\u30c0\u3078\u3001\u6700\u65b0\u7248\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3084\u308b\u3053\u3068\u3067\u3001\u3081\u3067\u305f\u304f\u3001\u6700\u65b0\u306ephpmyadmin\u3092\u5229\u7528\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<h3>phpMyAdmin\u3000\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/h3>\n<p><a href=\"http:\/\/www.phpmyadmin.net\/home_page\/index.php\">http:\/\/www.phpmyadmin.net\/home_page\/index.php<\/a><\/p>\n<p>\u3053\u3053\u306b\u3042\u308bDownload\u30ea\u30f3\u30af\u3088\u308a\u3001phpMyAdmin-4.1.4-all-languages.zip\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u3002<\/p>\n<p>[bash]<br \/>\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6e08\u307f\u306ephpmyadmin\u30d5\u30a9\u30eb\u30c0\u3092\u30ea\u30cd\u30fc\u30e0<br \/>\n$ sudo mv \/usr\/share\/phpmyadmin \/usr\/share\/phpmyadmin.org\/<\/p>\n<p>\u6700\u65b0\u7248\u3092\u89e3\u51cd\u3057\u3001\u4e0a\u8a18\u306e\u30d5\u30a9\u30eb\u30c0\u3078\u30b3\u30d4\u30fc<br \/>\n$ unzip phpMyAdmin-4.1.4-all-languages.zip<br \/>\n$ sudo mv phpMyAdmin-4.1.4-all-languages \/usr\/share\/phpmyadmin <\/p>\n<p>\u30d5\u30a9\u30eb\u30c0\u6a29\u9650\u306e\u5909\u66f4<br \/>\n$ sudo chown apache:apache \/usr\/share\/phpmyadmin -R<br \/>\n$ sudo cp \/usr\/share\/phpmyadmin\/config.sample.inc.php \/usr\/share\/phpmyadmin\/config.inc.php<\/p>\n<p>[\/bash]<\/p>\n<p>\u3053\u308c\u3067\u3001http:\/\/localhost\/phpmyadmin\u3000\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3068\u3001\u6700\u65b0\u7248\u306ephpmyadmin\u304c\u8868\u793a\u3055\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p>\u3082\u3057 Forbidden \u306e\u30a8\u30e9\u30fc\u304c\u51fa\u308b\u5834\u5408\u306f<\/p>\n<p>[bash highlight=&#8221;10&#8243;]<br \/>\n$ sudo nano \/etc\/httpd\/conf.d\/phpmyadmin.conf <\/p>\n<p>#<br \/>\n#  Web application to manage MySQL<br \/>\n#<\/p>\n<p><Directory \"\/usr\/share\/phpmyadmin\"><br \/>\n  Order Deny,Allow<br \/>\n  Deny from all<br \/>\n  Allow from 127.0.0.1 localhost 192.168.1.0\/24<br \/>\n<\/Directory><\/p>\n<p>Alias \/phpmyadmin \/usr\/share\/phpmyadmin<br \/>\nAlias \/phpMyAdmin \/usr\/share\/phpmyadmin<br \/>\nAlias \/mysqladmin \/usr\/share\/phpmyadmin<\/p>\n<p>[\/bash]<\/p>\n<p>Allow from \u306e\u884c\u3092\u9069\u5207\u306b\u30bb\u30c3\u30c8\u3057\u3066\u3084\u308a\u3001Apache\u3092\u518d\u8d77\u52d5\u3059\u308b\u3068\u8868\u793a\u3055\u308c\u308b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<p>[bash]<br \/>\n$ sudo service httpd restart<br \/>\n[\/bash]<\/p>\n<p><a href=\"http:\/\/lovelinux.mydns.jp\/wp-content\/uploads\/2014\/01\/phpMyAdmin-Chromium_001.png\"><img decoding=\"async\" src=\"http:\/\/lovelinux.mydns.jp\/wp-content\/uploads\/2014\/01\/phpMyAdmin-Chromium_001.png\" alt=\"phpMyAdmin - Chromium_001\" width=\"500\" class=\"alignnone size-medium wp-image-68\" srcset=\"https:\/\/lovelinux.mydns.jp\/wp-content\/uploads\/2014\/01\/phpMyAdmin-Chromium_001.png 870w, https:\/\/lovelinux.mydns.jp\/wp-content\/uploads\/2014\/01\/phpMyAdmin-Chromium_001-300x197.png 300w\" sizes=\"(max-width: 870px) 100vw, 870px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>yum \u3067 phpMyAdmin \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb \u307e\u305a\u306f\u3001CentOS\u306e\u30ea\u30dd\u30b8\u30c8\u30ea\u306b\u542b\u307e\u308c\u308bphpMyAdmin\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002 [bash] $ sudo yum install phpmyadmin [\/bash] \u3053\u308c\u3067\u3001http:\/\/localhost\/phpmyadmin\u3000\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3068\u3001phpmyadmin\u304c\u8868\u793a\u3055\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002 \u305f\u3060\u3001\u3053\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306f\u304b\u306a\u308a\u53e4\u3044\u3082\u306e\u306a\u306e\u3067\u3001\u6700\u65b0\u7248\u306b\u3057\u307e\u3057\u3087\u3046\u3002 yum \u3067 phpmyadmin\u3092\u5c0e\u5165\u3057\u305f\u3053\u3068\u306b\u3088\u308a\u3001Apache\u306b\u5bfe\u3059\u308bphpmyadmin\u306e\u8a2d\u5b9a\u306f\u5b8c\u4e86\u3057\u3066\u3044\u307e\u3059\u306e\u3067\u3001\u65e2\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3042\u308bphpmyadmin\u306e\u30d5\u30a9\u30eb\u30c0\u3078\u3001\u6700\u65b0\u7248\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3084\u308b\u3053\u3068\u3067\u3001\u3081\u3067\u305f\u304f\u3001\u6700\u65b0\u306ephpmyadmin\u3092\u5229\u7528\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002 phpMyAdmin\u3000\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9 http:\/\/www.phpmyadmin.net\/home_page\/index.php \u3053\u3053\u306b\u3042\u308bDownload\u30ea\u30f3\u30af\u3088\u308a\u3001phpMyAdmin-4.1.4-all-languages.zip\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u3002 [bash] \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6e08\u307f\u306ephpmyadmin\u30d5\u30a9\u30eb\u30c0\u3092\u30ea\u30cd\u30fc\u30e0 $ sudo mv \/usr\/share\/phpmyadmin \/usr\/share\/phpmyadmin.org\/ \u6700\u65b0\u7248\u3092\u89e3\u51cd\u3057\u3001\u4e0a\u8a18\u306e\u30d5\u30a9\u30eb\u30c0\u3078\u30b3\u30d4\u30fc $ unzip phpMyAdmin-4.1.4-all-languages.zip $ sudo mv phpMyAdmin-4.1.4-all-languages \/usr\/share\/phpmyadmin \u30d5\u30a9\u30eb\u30c0\u6a29\u9650\u306e\u5909\u66f4 $ sudo chown apache:apache \/usr\/share\/phpmyadmin -R $ sudo cp \/usr\/share\/phpmyadmin\/config.sample.inc.php \/usr\/share\/phpmyadmin\/config.inc.php [\/bash] \u3053\u308c\u3067\u3001http:\/\/localhost\/phpmyadmin\u3000\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3068\u3001\u6700\u65b0\u7248\u306ephpmyadmin\u304c\u8868\u793a\u3055\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002 \u3082\u3057 Forbidden \u306e\u30a8\u30e9\u30fc\u304c\u51fa\u308b\u5834\u5408\u306f [bash highlight=&#8221;10&#8243;] $ sudo nano \/etc\/httpd\/conf.d\/phpmyadmin.conf # # Web application to manage MySQL # Order Deny,Allow Deny from all Allow from 127.0.0.1 localhost 192.168.1.0\/24 Alias \/phpmyadmin \/usr\/share\/phpmyadmin Alias \/phpMyAdmin \/usr\/share\/phpmyadmin Alias \/mysqladmin \/usr\/share\/phpmyadmin [\/bash] Allow from \u306e\u884c\u3092\u9069\u5207\u306b\u30bb\u30c3\u30c8\u3057\u3066\u3084\u308a\u3001Apache\u3092\u518d\u8d77\u52d5\u3059\u308b\u3068\u8868\u793a\u3055\u308c\u308b\u3068\u601d\u3044\u307e\u3059\u3002 [bash] $ sudo service httpd restart [\/bash]<\/p>\n","protected":false},"author":1,"featured_media":401,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[25],"class_list":{"0":"post-65","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-4","8":"tag-centos"},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=\/wp\/v2\/posts\/65","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=65"}],"version-history":[{"count":7,"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=\/wp\/v2\/posts\/65\/revisions"}],"predecessor-version":[{"id":613,"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=\/wp\/v2\/posts\/65\/revisions\/613"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=\/wp\/v2\/media\/401"}],"wp:attachment":[{"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=65"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=65"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=65"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}