[B! mysql] monoookiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

monoooki id:monoooki

mysqlã«é–¢ã™ã‚‹monoookiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

${{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}}

MySQL :: MySQL 8.0 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: B.3.3.2 root ã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’ãƒªã‚»ãƒƒãƒˆã™ã‚‹æ–¹æ³•
Windows ã§ã¯ã€æ¬¡ã®æ‰‹é †ã‚’ä½¿ç”¨ã—ã¦ MySQL 'root'@'localhost'ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’ãƒªã‚»ãƒƒãƒˆã—ã¾ã™ã€‚ åˆ¥ã®ãƒ›ã‚¹ãƒˆåéƒ¨åˆ†ã‚’æŒã¤ root ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’å¤‰æ›´ã™ã‚‹ã«ã¯ã€ãã®ãƒ›ã‚¹ãƒˆåã‚’ä½¿ç”¨ã™ã‚‹ã‚ˆã†ã«æŒ‡ç¤ºã‚’å¤‰æ›´ã—ã¾ã™ã€‚ Administrator ã¨ã—ã¦ã‚·ã‚¹ãƒ†ãƒ ã«ãƒã‚°ã‚ªãƒ³ã—ã¾ã™ã€‚ MySQL ã‚µãƒ¼ãƒãƒ¼ãŒå®Ÿè¡Œã•ã‚Œã¦ã„ã‚‹å ´åˆã¯åœæ¢ã—ã¾ã™ã€‚ Windows ã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦å®Ÿè¡Œã•ã‚Œã¦ã„ã‚‹ã‚µãƒ¼ãƒãƒ¼ã®å ´åˆã¯ã€ã‚µãƒ¼ãƒ“ã‚¹ãƒžãƒãƒ¼ã‚¸ãƒ£ãƒ¼ã‚’é–‹ãã¾ã™ (ã€Œã‚¹ã‚¿ãƒ¼ãƒˆã€ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‹ã‚‰ã€ã€Œã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ« ãƒ‘ãƒãƒ«ã€ã€ã€Œç®¡ç†ãƒ„ãƒ¼ãƒ«ã€ã€ã€Œã‚µãƒ¼ãƒ“ã‚¹ã€ã®é †ã«é¸æŠžã—ã¾ã™)ã€‚ ãƒªã‚¹ãƒˆå†…ã§ MySQL ã‚µãƒ¼ãƒ“ã‚¹ã‚’è¦‹ã¤ã‘ã¦ã€ãã‚Œã‚’åœæ¢ã—ã¾ã™ã€‚ ã‚µãƒ¼ãƒãƒ¼ãŒã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦å®Ÿè¡Œã•ã‚Œã¦ã„ãªã„å ´åˆã¯ã€ã‚¿ã‚¹ã‚¯ãƒžãƒãƒ¼ã‚¸ãƒ£ãƒ¼ã‚’ä½¿ç”¨ã—ã¦å¼·åˆ¶çš„ã«åœæ¢ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ å˜ä¸€è¡Œã«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰å‰²å½“ã¦ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚’å«ã‚€ãƒ†ã‚
monoooki 2012/10/10
mysql
ãƒªãƒ³ã‚¯
Mac ã« MacPorts ã‚’ä½¿ã£ã¦ MySQL ã¨ PHPMyAdmin ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ–¹æ³•
Mac ã« MySQL ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã€‚MacPorts ã‚’å…¥ã‚Œã¦ãªã„å ´åˆã¯ Mac OS 10.6 ã« MacPorts ã‚’å…¥ã‚Œã‚‹éš›ã«å½¹ã«ç«‹ã£ãŸã‚µã‚¤ãƒˆã‚’å‚è€ƒã«ã—ã¦å…¥ã‚Œã¦ãã ã•ã„ã€‚ MySQL ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Twitter ã¨ MySQL / Mac OS X ã‚’å‚è€ƒã«é€²ã‚ã¦ã¿ã¾ã—ãŸã€‚ ã»ã¼å¼•ç”¨ã§ã™ãŒã€èº“ã„ãŸã¨ã“ã‚ã«è£œè¶³ã‚³ãƒ¡ãƒ³ãƒˆã—ãŸã‚Šã€é †åºã‚’å¤‰ãˆãŸã‚Šã—ã¦ã„ã¾ã™ã€‚
monoooki 2012/01/14
mysql

mac
ãƒªãƒ³ã‚¯
ERROR 1045 (28000) : MySQL ã§ã„ã“ã†ï¼
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) ã“ã®ã‚¨ãƒ©ãƒ¼ã¯ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒè¨å®šã•ã‚Œã¦ã„ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚’ä½¿ç”¨ã—ã¦ MySQL ã‚µãƒ¼ãƒã«æŽ¥ç¶šã™ã‚‹éš›ã«ã€ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’é€ä¿¡ã—ãªã‹ã£ãŸå ´åˆã«ã“ã®ã‚¨ãƒ©ãƒ¼ãŒè¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ C:\Documents and Settings\test>mysql -u root -D test ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) ã“ã®å ´åˆã€ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’é€ä¿¡ã™ã‚‹ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã€Œ-pã€ã‚’ã¤ã‘ã‚‹ã¨ MySQL ã‚µãƒ¼ãƒã«æŽ¥ç¶šã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ C:\Documents and Settings\test>mysql -u root -D tes
monoooki 2012/01/14
mysql
ãƒªãƒ³ã‚¯
Macã«LAMPç’°å¢ƒã‚’æ§‹ç¯‰ã—ã¦WordPressã‚’å°Žå…¥ã™ã‚‹æ‰‹é †ã®ãƒ¡ãƒ¢ | Macã¨ã‹ã®é›‘è¨˜å¸³
Macã«æœ€åˆã‹ã‚‰å…¥ã£ã¦ã„ã‚‹Apacheã‚„PHPã‚’ä½¿ã£ã¦LAMPç’°å¢ƒã‚’æ§‹ç¯‰ã—ã€WordPressã‚’å°Žå…¥ã™ã‚‹ã¾ã§ã®æ‰‹é †ã§ã™ã€‚ä»¥å‰ã«ã‚‚åŒã˜æ§˜ãªã“ã¨ã‚’æ›¸ã„ã¦ã„ã‚‹ã®ã§ã™ãŒã€ç’°å¢ƒæ§‹ç¯‰ã«å¿…è¦ãªæœ€ä½Žé™ã®æ‰‹é †ã‚’ã¾ã¨ã‚ã¦ãŠããŸã‹ã£ãŸã®ã§æ”¹ã‚ã¦è¨˜äº‹ã«ã—ã¾ã—ãŸã€‚ Lionã§ã®å†…å®¹ã«ãªã‚Šã¾ã™ãŒã€SnowLeopardã§æ§‹ç¯‰ã™ã‚‹å ´åˆã‚‚åŒã˜ã§ã™ã€‚ãã‚Œä»¥å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚‚ãã‚“ãªã«å¤‰ã‚ã‚‰ãªã„ã¨æ€ã„ã¾ã™ã€‚ æœ€åˆã«â€¦ Lionã®å ´åˆã¯ã€ã¾ãšæœ€åˆã«ã€Œã‚·ã‚¹ãƒ†ãƒ ç’°å¢ƒè¨å®šã€â†’ã€Œå…±æœ‰ã€â†’ã€ŒWebå…±æœ‰ã€ã‚’ONã«å‡ºæ¥ã‚‹ã‹ã©ã†ã‹ç¢ºèªã—ã¦ãã ã•ã„ã€‚ ã‚‚ã—ONã«ã§ããªã‹ã£ãŸã‚‰ä¸‹ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã—ã¦Apacheã®è¨å®šãƒ•ã‚¡ã‚¤ãƒ«httpd.confã‚’åˆæœŸçŠ¶æ…‹ã«ã—ã¦ã¿ã¦ãã ã•ã„ã€‚ 1. MySQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Apacheã‚„phpã¯æœ€åˆã‹ã‚‰å…¥ã£ã¦ã„ã¾ã™ãŒã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯å…¥ã£ã¦ã„ãªã„ã®ã§MySQLã‚’å°Žå…¥ã—ã¾ã™ã€‚ ã¾ã Lionç”¨ã®MySQLã¯ç„¡ã„ã®ã§ã€10
monoooki 2012/01/14
mysql

lion

apache

mac
ãƒªãƒ³ã‚¯
WordPressã‚’100å€é€Ÿãã™ã‚‹ï¼ MySQLã®èª¿æ•´ã‚„nginx proxy cache | KRAY Inc
[è¿½è¨˜ï¼‘] æœ€å¾Œã§èª¬æ˜Žã—ã¦ã„ã‚‹proxy cacheã®è¨å®šã‚’ä¿®æ£ã—ã¾ã—ãŸã€‚ [è¿½è¨˜ï¼’] nginx proxy cacheã§ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ãªã„å ´åˆã®å‡¦ç†ã‚’å¤‰æ›´ã—ã¾ã—ãŸã€‚ [è¿½è¨˜ï¼“] ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³ã‚„æºå¸¯ã§é–²è¦§ã—ãŸæ™‚ã«ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ãªã„è¨å®šã‚’è¿½åŠ ã—ã¾ã—ãŸã€‚ ã¯ã˜ã‚ã« å¤§ã’ã•ãªé¡Œåã§ã™ãŒã€ä»Šå›žã¯WordPresså˜ä½“ã‚’é€Ÿãã™ã‚‹ã®ã§ã¯ãªãã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„Webã‚µãƒ¼ãƒãªã©ã®èª¿æ•´ã€ã¾ãŸnginxã®proxy cacheæ©Ÿèƒ½ã‚’ä½¿ã£ã¦é€Ÿãã™ã‚‹è©±ã«ãªã‚Šã¾ã™ã€‚ ã‚µã‚¤ãƒˆã®æ§‹æˆã«ã‚ˆã£ã¦ã¯ã€proxy cacheã¯ä½¿ãˆãªã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€ä½¿ã‚ãªãã¦ã‚‚5å€ç¨‹åº¦é€Ÿãã™ã‚‹ã“ã¨ã¯ã§ãã¾ã—ãŸã®ã§ã€å‚è€ƒã«ã—ã¦ã„ãŸã ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ ä»Šå›žè¡Œã†ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ä¸€è¦§ DBã‚’æœ€é©åŒ–ã™ã‚‹ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã‚’å°Žå…¥ã™ã‚‹ APCã‚’å°Žå…¥ã—ã¦PHPã‚’é€Ÿãã™ã‚‹ MySQLã‚’é€Ÿãã™ã‚‹ é‡ã„WordPressãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã‚’å¤–ã™ nginx+FastCGIã«ã™ã‚‹ W
monoooki 2011/01/26
ä½“æ„Ÿã§ã‚‚é€Ÿããªã£ã¦ã¾ã—ãŸã€‚

nginx

mysql

wordpress
ãƒªãƒ³ã‚¯
ã€Œå–«èŒ¶åº—ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã€ã®ãŸã‚ã®ç’°å¢ƒæ§‹ç¯‰(VMwarePlayer + CentOS5.5+Apache2.2.3+MySQL5.5.8+PHP5.3.5+Ruby1.8.7+ãŠã¾ã‘) - [email protected]
ã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ Windows 7 Home Premium (64bit)VMware Player 3.1.3 build-324285Tera Term 4.67 ä½œã‚‹ç‰© CentOS # cat /etc/redhat-release CentOS release 5.5 (Final) # uname -a Linux localhost.localdomain 2.6.18-194.32.1.el5 #1 SMP Wed Jan 5 17:52:25 EST 2011 x86_64 x86_64 x86_64 GNU/Linux Apache # /usr/sbin/httpd -v Server version: Apache/2.2.3 Server built: Aug 30 2010 12:28:40 MySQL # mysql --version mysql Ver 1
monoooki 2011/01/20
ruby

mysql

apache

php
ãƒªãƒ³ã‚¯
Microsoft â€“ ã‚¯ãƒ©ã‚¦ãƒ‰ã€ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ãƒ¼ã€ã‚¢ãƒ—ãƒª & ã‚²ãƒ¼ãƒ
æœŸé–“é™å®šã§ Surface Pro 8 ã”è³¼å…¥ã§å¯¾è±¡ã®ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ãŒç„¡æ–™ã«ãªã‚Šã€æœ¬ä½“ã«ã‚‚ç‰¹åˆ¥ä¾¡æ ¼ãŒé©ç”¨ã•ã‚Œã¾ã™ã€‚
monoooki 2008/05/15
ã‚¸ãƒ¼ãƒ‘ãƒ³å±‹ã¿ãŸã„ãªã‚µã‚¤ãƒˆã€‚

php

mysql

windows
ãƒªãƒ³ã‚¯
1