{"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":"

yum \u3067 phpMyAdmin \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n

\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

[bash]
\n$ sudo yum install phpmyadmin
\n[\/bash]<\/p>\n

\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

\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
\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

phpMyAdmin\u3000\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/h3>\n

http:\/\/www.phpmyadmin.net\/home_page\/index.php<\/a><\/p>\n

\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

[bash]
\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6e08\u307f\u306ephpmyadmin\u30d5\u30a9\u30eb\u30c0\u3092\u30ea\u30cd\u30fc\u30e0
\n$ sudo mv \/usr\/share\/phpmyadmin \/usr\/share\/phpmyadmin.org\/<\/p>\n

\u6700\u65b0\u7248\u3092\u89e3\u51cd\u3057\u3001\u4e0a\u8a18\u306e\u30d5\u30a9\u30eb\u30c0\u3078\u30b3\u30d4\u30fc
\n$ unzip phpMyAdmin-4.1.4-all-languages.zip
\n$ sudo mv phpMyAdmin-4.1.4-all-languages \/usr\/share\/phpmyadmin <\/p>\n

\u30d5\u30a9\u30eb\u30c0\u6a29\u9650\u306e\u5909\u66f4
\n$ sudo chown apache:apache \/usr\/share\/phpmyadmin -R
\n$ sudo cp \/usr\/share\/phpmyadmin\/config.sample.inc.php \/usr\/share\/phpmyadmin\/config.inc.php<\/p>\n

[\/bash]<\/p>\n

\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

\u3082\u3057 Forbidden \u306e\u30a8\u30e9\u30fc\u304c\u51fa\u308b\u5834\u5408\u306f<\/p>\n

[bash highlight=”10″]
\n$ sudo nano \/etc\/httpd\/conf.d\/phpmyadmin.conf <\/p>\n

#
\n# Web application to manage MySQL
\n#<\/p>\n


\n Order Deny,Allow
\n Deny from all
\n Allow from 127.0.0.1 localhost 192.168.1.0\/24
\n<\/Directory><\/p>\n

Alias \/phpmyadmin \/usr\/share\/phpmyadmin
\nAlias \/phpMyAdmin \/usr\/share\/phpmyadmin
\nAlias \/mysqladmin \/usr\/share\/phpmyadmin<\/p>\n

[\/bash]<\/p>\n

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

[bash]
\n$ sudo service httpd restart
\n[\/bash]<\/p>\n

\"phpMyAdmin<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

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=”10″] $ 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":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t