[B! phpmyadmin] teddy-gã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

teddy-g id:teddy-g

phpmyadminã«é–¢ã™ã‚‹teddy-gã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (8)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

AWSã«Apache+PHP+MySQLã¨phpMyAdmin,vsftpdã‚’å°Žå…¥ã™ã‚‹æ‰‹é † ï½œhttps://wp.yat-net.com/name
ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ãŒç«‹ã¡ä¸ŠãŒã£ãŸã‚‰SSHã§ã‚µãƒ¼ãƒãƒ¼ã«ãƒã‚°ã‚¤ãƒ³ã—ã€ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã„ãã¾ã™ã€‚SSHã§ãƒã‚°ã‚¤ãƒ³ã™ã‚‹ã«ã¯Macãªã‚‰æ¨™æº–ã§æè¼‰ã®ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã€Windowsãªã‚‰TeraTermã®ã‚ˆã†ãªãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã‚’åˆ©ç”¨ã—ã¾ã™ã€‚ ã¾ãšã¯ã‚µãƒ¼ãƒãƒ¼ã¸æŽ¥ç¶šã—ã¾ã—ã‚‡ã† ssh -i ï¼ˆéµã®ãƒ‘ã‚¹) ec2-user@(Public DNS) éµã®ãƒ‘ã‚¹ã¯ã€KeyPairsã‚’ä½œæˆã—ãŸéš›ã«ä¿å˜ã—ãŸ***.pemã¨ã„ã†ãƒ•ã‚¡ã‚¤ãƒ«ã§ã™ã€‚ãã‚ŒãŒä¿å˜ã•ã‚Œã¦ã„ã‚‹å ´æ‰€ã‚’æŒ‡å®šã—ã¾ã™ã€‚ ec2-userã¯ãƒ¦ãƒ¼ã‚¶ãƒ¼IDã§ã€AWSã«ã¦SSHæŽ¥ç¶šã™ã‚‹éš›ã¯å¤§ä½“ã“ã®IDã§æŽ¥ç¶šã—ã¾ã™ã€‚ Public DNSã¯ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ç«‹ã¡ä¸Šã’ãŸéš›ã«å‰²ã‚Šå½“ã¦ã‚‰ã‚Œã‚‹è¨€ã‚ã°URLã«å½“ãŸã‚Šã¾ã™ã€‚ ã‚‚ã—æŽ¥ç¶šã—ãŸéš›ã«ä¸‹è¨˜ã®ã‚ˆã†ãªã‚¨ãƒ©ãƒ¼ãŒå‡ºãŸå ´åˆã¯éµã®ãƒ‘ãƒ¼ãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚’å¤‰æ›´ã—ãªã„ã¨è¡Œã‘ã¾ã›ã‚“ã€‚ chmod 600 (éµã®ãƒ‘ã‚¹) æŽ¥ç¶šã§ããŸã‚‰suã‚’åˆ©ç”¨ã—ã¦rootæ¨©é™ã«
teddy-g 2014/11/04
ã“ã“å‚è€ƒã«ã—ãŸã‹ã©ã†ã‹å¿˜ã‚ŒãŸã‘ã©å‚™å¿˜ã¾ã§ã€‚

aws

amazon

AmazonEC2

apache

php

mysql

phpmyadmin
ãƒªãƒ³ã‚¯
Apacheã§ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆèªè¨¼ã—ã¦ã¿ã‚‹
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
teddy-g 2014/10/05
ã‚ã¨ã§ã‚„ã£ã¦ã¿ã‚‹

amazon

AmazonEC2

mysql

php

phpmyadmin
ãƒªãƒ³ã‚¯
Amazon Linux ã« phpmyadmin ã‚’å…¥ã‚Œã¦ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆèªè¨¼ã™ã‚‹ - vimtaku blog
TOC TOC æ¦‚è¦ ä¸‹æº–å‚™ DB ã®è¨å®šã‚’ã‚ã‚Œã“ã‚Œã™ã‚‹ phpmyadmin ã®ã‚¢ã‚¯ã‚»ã‚¹åˆ¶é™,ä»Šå›žã¯ ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆèªè¨¼ã™ã‚‹å‰æãªã®ã§å…¨é–‹æ”¾ ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆèªè¨¼ p12 ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã«ã¤ã„ã¦ å‚è€ƒæ–‡çŒ® æ¦‚è¦ amazon linux ã§ phpmyadmin(httpd) ã‚’å…¥ã‚Œã¦ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆèªè¨¼ã™ã‚‹ãƒ‘ã‚¿ãƒ¼ãƒ³ã«ãªã£ãŸã®ã§ã‚„ã£ã¦ã¿ãŸã€‚ ä¸‹æº–å‚™ ## apache ã¨ phpmyadmin ãŒå…¥ã‚‹ sudo yum --enablerepo=epel install phpmyadmin ## mod_ssl sudo yum install mod24_ssl sudo yum install openssl-devel
teddy-g 2014/10/05
ã‚ã¨ã§ã‚„ã£ã¦ã¿ã‚‹

amazon

AmazonEC2

php

mysql

phpmyadmin
ãƒªãƒ³ã‚¯
phpMyAdminã‚’ä½¿ã† | æœªæ¥æŒ‡å‘ miraishikou
æœªæ¥ã«èª‡ã‚Œã‚‹ä»•äº‹Read the rest of this entry Â»è©¦é¨“ã‚’å—ã‘ã¦ã„ãŸã®ã§ä¼‘ã‚“ã§ã„ã¾ã—ãŸã€‚ ä»Šæ—¥ã¯phpMyAdminã‚’ä½¿ã£ã¦ã¿ã¾ã™ã€‚ ï½žï½žï½žï½žï½žï½žï½žï½žï½žï½žï½žï½žï½žï½žï½žï½ž phpMyAdmin ã®è¨å®šã‚’å§‹ã‚ã‚‹å‰ã«ã€ã‚µãƒ¼ãƒãƒ¼ã®ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã€ ec2-userã¨rootã«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’è¨å®šã—ã¦ãŠãã¾ã™ã€‚ SSHæŽ¥ç¶šã—ã€sudo passwd ec2-user ã¨æ‰“ã¡ã€ ãã®å¾Œã€æ–°ã—ã„ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’ç¢ºèªå«ã‚ã¦2å›žå…¥åŠ›ã—ã¾ã™ã€‚ phpMyAdmin ã®URLã¯ã€http://ipã‚¢ãƒ‰ãƒ¬ã‚¹/phpmyadmin/ ã§ã™ã€‚ ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ãƒ¦ãƒ¼ã‚¶ãƒ¼åec2-userã€ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã¯ç©ºæ¬„ã§ãƒã‚°ã‚¤ãƒ³ã—ã‚ˆã†ã¨ã™ã‚‹ã¨ã€ #2002 â€“ ã‚µãƒ¼ãƒãŒå¿œç”ã—ã¾ã›ã‚“ï¼ˆã‚ã‚‹ã„ã¯ãƒãƒ¼ã‚«ãƒ«ã®MySQLã‚µãƒ¼ãƒã®ã‚½ã‚±ãƒƒãƒˆãŒæ£ã—ãè¨å®šã•ã‚Œã¦ã„ã¾ã›ã‚“ï¼‰ ã¨ã„ã†ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãŒå‡ºã¦ãƒã‚°ã‚¤ãƒ³ã§ãã¾ã›ã‚“ã€‚ SSH
teddy-g 2014/10/05
phpMyAdminã®è¨å®šã§ã¡ã‚‡ã£ã¨ã¯ã¾ã£ãŸã®ã§ã€‚

amazon

AmazonEC2

php

mysql

phpmyadmin
ãƒªãƒ³ã‚¯
Amazon EC2ã«phpMyAdminã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸå¾Œã®ä½œæ¥ãƒ¡ãƒ¢ * R4 * Webã‚µãƒ¼ãƒ“ã‚¹ãƒ¬ãƒ“ãƒ¥ãƒ¼ã‚µã‚¤ãƒˆ
Amazon EC2ã«phpMyAdminã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã¨Forbiddenã¨ãªã£ãŸã®ã§ã€ãã“ã‹ã‚‰ã®ä½œæ¥ã‚’ä»¥ä¸‹ã«ãƒ¡ãƒ¢ã—ã¦ãŠãã¾ã™ã€‚â€»äº‹å‰ã«apacheã€phpã€MySQLã€php-mysqlã€phpMyAdminã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ¸ˆã¿ã§ã™ã€‚OSã¯CentOSã€‚ èª¿ã¹ã¦ã¿ã‚‹ã¨phpmyadmin.confã¨config.inc.phpã‚’ç·¨é›†ã—ãªã„ã¨ã„ã‘ãªã„æ¨¡æ§˜ã€‚ ã¾ãšã€è‡ªåˆ†ãŒã‚¢ã‚¯ã‚»ã‚¹ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ãŸã‚ã« /etc/httpd/conf.d/phpmyadmin.conf ã‚’ç·¨é›†ã€‚ <Directory "/usr/share/phpmyadmin"> Order Deny,Allow Deny from all Allow from 127.0.0.1 </Directory> ä»Šã¯127.0.0.1ã‹ã‚‰ã—ã‹ã‚¢ã‚¯ã‚»ã‚¹ã§ãã¾ã›ã‚“ã‚ˆã¨ã„ã†ã“ã¨ãªã®ã§ã€ã“ã“ã®ã€ŒAllow from 1
teddy-g 2014/10/05
ã“ã®å†…å®¹é€šã‚Šã§ã ã„ãŸã„ã§ããŸã€‚RDSã®ã‚¨ãƒ³ãƒ‰ãƒã‚¤ãƒ³ãƒˆã¯æŒ‡å®šã—ãªãã¦ã‚‚å‹•ãã€‚

amazon

AmazonEC2

phpmyadmin

mysql

php
ãƒªãƒ³ã‚¯
MAMPã€€phpMyAdminã‚’æœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ | ä½œæ¥ãƒ¡ãƒ¢
MAMP3.0ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã‚‚ã®ã®ã€phpMyAdminã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒæœ€æ–°ã§ãªã„ã¨ã®ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãŒå‡ºã‚‹ã®ã§ã€ ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã™ã‚‹ã“ã¨ã«ã€‚ ã“ã®æ™‚ç‚¹ã§ã€æœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 4.1.9 ã§ã€2014-03-06 ã«ãƒªãƒªãƒ¼ã‚¹ 1.phpMyAdminã®ã‚µã‚¤ãƒˆã‚ˆã‚Šã€æœ€æ–°ç‰ˆã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ phpMyAdmin-4.1.9-all-languages.zip ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¦ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ 2.MAMPã¯åœæ¢ã—ã¦ãŠãã€‚ 3./Applications/MAMP/bin/phpMyAdminãƒ•ã‚©ãƒ«ãƒ€ã‚’å·®ã—æ›¿ãˆã‚‹ã®ã ã‘ã©ã€ä¸€å¿œãƒªãƒãƒ¼ãƒ ã—ã¦ã¨ã£ã¦ãŠã 4.ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸzipã‚’è§£å‡ã—ã€åå‰ã‚’ã€ŒphpMyAdminã€ã«ãƒªãƒãƒ¼ãƒ ã—ã¦ã€ /Applications/MAMP/bin/é…ä¸‹ã«ãŠãã€‚ 5.MAMPã‚’èµ·å‹•ã—ã€phpMyAdminã‚’èµ·å‹• ï¼ˆã‚¹ã‚¿ãƒ¼ãƒˆãƒšãƒ¼ã‚¸ã®MySQLã®ä¸èº«ãŒè¡¨ç¤ºã•ã‚Œãªããªã£ã¦ãŸã‘ã©
teddy-g 2014/10/05
ã„ã¤ã‚‚XAMPPã§æ¥½ã—ã¦ãŸã®ã§åˆæœŸè¨å®šãªã‚“ã¦æ°—ã«ã—ã¦ãªã‹ã£ãŸã®ã§å‚™å¿˜ã¾ã§ã€‚ã¡ã‚ƒã‚“ã¨Mysqldã®è¨å®šã¨åˆã‚ã›ãªã„ã¨ã„ã‘ã¾ã›ã‚“ã€‚

amazon

AmazonEC2

mysql

phpmyadmin

php
ãƒªãƒ³ã‚¯
phpMyAdmin ã®ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚ºã‚’å¤‰æ›´ã™ã‚‹
MySQL + phpMyAdmin ã«ã‚ˆã‚‹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã§ã€ŒphpMyAdmin ã«ã‚ˆã‚‹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã‚µã‚¤ã‚ºã«åˆ¶é™ãŒã‚ã‚‹ã€ã¨æ›¸ãã¾ã—ãŸãŒã€è‡ªå®…ã‚µãƒ¼ãƒï¼ˆApacheï¼‰ç‰ã€ç®¡ç†è€…æ¨©é™ãŒã‚ã‚Œã°ã€ã“ã®ã‚µã‚¤ã‚ºã‚’ç°¡å˜ã«å¤‰æ›´ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ å¤‰æ›´å‰ã®ã‚µã‚¤ã‚ºã¯2048KBã§ã™ã€‚ ã“ã®æœ€å¤§ã‚µã‚¤ã‚ºã‚’å¤‰æ›´ã™ã‚‹ã«ã¯ã€php.ini ã«ã‚ã‚‹ä¸‹è¨˜ã®è¡Œ php_value upload_max_filesize 2M ã®èµ¤è‰²éƒ¨åˆ†ã‚’æ¬¡ã®ã‚ˆã†ã«ä¿®æ£ã—ã¾ã™ã€‚ php_value upload_max_filesize 8M ã“ã‚Œã§ Apache ã‚’å†èµ·å‹•ã™ã‚‹ã¨ã€æœ€å¤§ã‚µã‚¤ã‚ºãŒå¤‰æ›´ã•ã‚Œã¾ã™ï¼ˆä¾‹ã¯8192KBï¼‰ã€‚ ã•ã‚‰ã«ã‚µã‚¤ã‚ºã‚’æ‹¡å¤§ã™ã‚‹å ´åˆã¯ã€php.ini ã® memory_limit post_max_size upload_max_filesize ã®é–¢ä¿‚ãŒ memory_limit > post_m
teddy-g 2014/10/05
ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚ºã¯ç¢ºã‹ã«å¤‰æ›´ã§ããŸã€‚è‹¥å¹²ã®ä¸å®‰ãŒä½•ã¨ãªãæ®‹ã‚‹ã€‚

php

phpmyadmin

mysql

tips

hacks
ãƒªãƒ³ã‚¯
Amazon EC2 (Amazon Linux) ã§ã® phpMyAdmin ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨è¨å®š
æ¨™æº–ã®ãƒªãƒã‚¸ãƒˆãƒªã®ã¾ã¾ã§ã¯yumã‚’ä½¿ã£ã¦phpMyAdminãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ããªã„ã®ã§ã€RPMForgeã®ãƒªãƒã‚¸ãƒˆãƒªã‚’å°Žå…¥ã—ã¾ã™ã€‚ #cd /usr/local/src #wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.3.6-1.el5.rf.i386.rpm #rpm -Uvh rpmforge-release-0.3.6-1.el5.rf.i386.rpm
teddy-g 2014/09/25
Amazon EC2ã«phpMyAdminã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‚æ¨©é™è¨å®šã¨ã‹ã›ã‚“ã¨ã„ã‹ã‚“ã€‚

aws

AmazonEC2

amazon

webservices

php

mysql

phpmyadmin
ãƒªãƒ³ã‚¯
1