¥Ï¡¼¥É¥Ç¥£¥¹¥¯¥á¥ó¥Æ¥Ê¥ó¥¹

¥Ï¡¼¥É¥Ç¥£¥¹¥¯¤Î¿ÇÃÇ¡¢ÊªÍý¥Õ¥©¡¼¥Þ¥Ã¥È¡¢ÀŲ»²½¡¢Linux¡¢¥µ¡¼¥Ð¡¼¡¢MySQL¤Ê¤É¤¬¥á¥¤¥ó¤À¤Ã¤¿¤Î¤Ç¤¹¤¬¡¢¤½¤Î¸å¹­¤¬¤ê¡¢¥«¥á¥é¤ä¥Ï¡¼¥É¥¦¥§¥¢¤ÎÅê¹Æ¤âÁý¤¨¤Æ¤­¤Þ¤·¤¿¡£ ¥â¥Ð¥¤¥ë¥Ç¥Ð¥¤¥¹¤Ï¡¢MacBookAir(13·¿)¡¢iPad Air2¡¢¥Ý¥á¥é DM100(¥­¥ó¥°¥¸¥à)¡¢OLYMPUS STYLUS XZ-2¤Ê¤É¡£ ¤³¤ì¤é¤ò»È¤¤¤Ê¤¬¤é¡¢¥Ö¥í¥°¤ò¹¹¿·¤·¤Æ¤¤¤Þ¤¹¡£

¥¿¥°¡§MySQL



2Ëü±ß°Ê²¼¤Î·ã°Â¥µ¡¼¥Ð¡¼¤ò¾Ò²ð¤·¤è¤¦¡£

ÉÙ»ÎÄÌ PRIMERGY MX130 S2

PRIMERGY MX130 S2

19,800±ß¤¬¡¢2,000±ß°ú¤­¥¯¡¼¥Ý¥ó»ÈÍѤÇ17,800±ß¡ª¡ª

ºß¸Ë¶Ï¾¯¡ª

OS¥ì¥¹¥¿¥¤¥×¤À¤¬¡¢¼«Ê¬¤ÇLinuxÆþ¤ì¤ë¤«¤éÉÔÍפÀ¤·¤Í¡£

CPU¤â¥á¥â¥ê¡¼¤â¥Ï¡¼¥É¥Ç¥£¥¹¥¯(250GB)¤âDVD-ROM¥É¥é¥¤¥Ö¤âºÜ¤Ã¤Æ¤¤¤ë¤«¤é¡¢¤¢¤È¤ÏLinux¤ò¾Æ¤¤¤Æ¥¤¥ó¥¹¥È¡¼¥ë¤¹¤ë¤À¤±¡£

·ã°Â¥µ¡¼¥Ð¡¼¤Ï¥¿¥ï¡¼·¿¤¬ÂçȾ¤À¤¬¡¢¤É¤¦¤·¤Æ¤â¼ÙËâ¤Ë¤Ê¤ë¡£

¤½¤ó¤ÊÃæ¡¢¥¹¥ê¥à·¿½ÄÃÖ¤­²Äǽ¤Ê¥µ¡¼¥Ð¡¼¤Ï¥¤¥¤¤Í¡£

¸«¤¿Ìܤ¬NASÉ÷¤Î¥µ¡¼¥Ð¡¼¤â¤¢¤ë¤è¡£

HP ProLiant MicroServer Turion II NEO N5

HP ProLiant MicroServer Turion II NEO N5

16,980±ß¤¬¡¢1,000±ß°ú¤­¥¯¡¼¥Ý¥ó»ÈÍѤÇ15,980±ß¡ª¡ª

¤³¤Á¤é¤âºß¸Ë¶Ï¾¯¡ª

¤³¤Á¤é¤ÏCPU¡¢¥á¥â¥ê¡¼¡¢¥Ï¡¼¥É¥Ç¥£¥¹¥¯(500GB)¤Ï¤¢¤ë¤¬¡¢¸÷³Ø¥É¥é¥¤¥Ö¤¬¤Ê¤¤¤Î¤ÇÍÑ°Õ¤¹¤ë¤«¡¢USB¥á¥â¥ê¡¼¤«¤é¥¤¥ó¥¹¥È¡¼¥ë¤¹¤ì¤Ð¤è¤¤¡£

Linux¤òÆþ¤ì¤Æ¥Õ¥¡¥¤¥ë¥µ¡¼¥Ð¡¼¤Ë¤·¤Æ¤â¥è¥·¡¢MySQL¤òÆþ¤ì¤ÆDB¤Î³Ø½¬ÍѤˤ·¤Æ¤â¥è¥·¡ª

¥µ¡¼¥Ð¡¼¤Î´ÉÍý¤Ï¡¢¥Ï¡¼¥É¤ò´Þ¤á¤¿Ã챤¬É¬ÍפǤ¢¤ë¤È¡¢»ä¤Ï¹Í¤¨¤Æ¤¤¤ë¡£

¤½¤ì¤Ê¤é¤Ð¡¢¤ä¤Ï¤ê¼Âµ¡¤À¡£



MySQLÁ´µ¡Ç½¥Ð¥¤¥Ö¥ë ~¸½¾ì¤ÇÌòΩ¤ÄAtoZ~
ÎëÌÚ ·¼½¤
µ»½ÑɾÏÀ¼Ò
Çä¤ê¾å¤²¥é¥ó¥­¥ó¥°: 61,578


¼ÂÁ©¥Ï¥¤¥Ñ¥Õ¥©¡¼¥Þ¥ó¥¹MySQL Âè3ÈÇ
Baron Schwartz Peter Zaitsev Vadim Tkachenko
¥ª¥é¥¤¥ê¡¼¥¸¥ã¥Ñ¥ó
Çä¤ê¾å¤²¥é¥ó¥­¥ó¥°: 112,943


[PR] au PAY / au WALLET ¥«¡¼¥É ¾ðÊó

¤³¤Î¥¨¥ó¥È¥ê¡¼¤ò¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯¤ËÄɲà mixi¥Á¥§¥Ã¥¯



¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ç½ÅÍפÊindex¤Ç¤¢¤ë¤¬¡¢Á´¤Æ¤Îfield¤Ëindex¤òÄêµÁ¤¹¤ë¤Î¤Ï¡¢Â¿¤¯¤Î¾ì¹ç¤Ï̵Â̤Ǥ¢¤ë¡£

ÄêµÁ¤·¤Æ¤â¡¢¤½¤ì¤¬»ÈÍѤµ¤ì¤Ê¤±¤ì¤Ð°ÕÌ£¤¬¤Ê¤¤¡£

index¤òÄêµÁ¤¹¤ë¤³¤È¤Ï¡¢field¤Î¥³¥Ô¡¼¤òºî¤ë¤³¤È¤Ë¶á¤¯¡¢¹¹¿·À­Ç½¤ÎÄã²¼¤ò¾·¤¯¡£

Á´¤Æ¤Îfield¤Ëindex¤òÄɲ乤ì¤Ð¡¢¥Æ¡¼¥Ö¥ë¤¬2¤Ä¤¢¤ë¤Î¤ÈƱ¤¸¤À¡£

½ñ¹þ¤¬È¯À¸¤¹¤ë¤È¡¢Î¾Êý¤Ë½ñ¤­¹þ¤Þ¤Í¤Ð¤Ê¤é¤Ê¤¤(¹¹¿·¤âƱÍÍ)¡£

index¤¬ÌòΩ¤Ä¤«Ê¬¤«¤é¤Ê¤¤¤Î¤Ë¡¢Á´¤Æ¤Îfield¤ËÂФ·¤Æindex¤òÀßÄꤹ¤ë¤Î¤Ï̵ÂÌ¡£

Æɼ褬¥á¥¤¥ó¤Î¾ì¹ç¤Ï¡¢¤Ê¤¤¤è¤ê¤Ï¥Þ¥·¤À¤í¤¦¤¬...

index¤òÀßÄꤷ¤Æ¤âÁ´¤¯»È¤ï¤Ê¤¤¤À¤í¤¦field¤Ï¡¢¤½¤ì¤Û¤É¹Í¤¨¤Ê¤¯¤Æ¤âʬ¤«¤ë¤Ï¤º¤À¡£

¤è¤¯¸«¤ë¤Î¤¬¡¢¼ç¥­¡¼¤Ë¤Ï´û¤Ëindex¤¬¤¢¤ë¤Î¤Ë¡¢¤½¤ì¤È¤ÏÊ̤Ëindex¤òÄêµÁ¤·¤Æ¤¤¤ë¥Ñ¥¿¡¼¥ó¡£

¾éŤÇ̵Â̤Ǥ¢¤ë¡£

¤Ê¤ª¡¢SQL¤Ë¤è¤Ã¤Æ¤Ï¡¢index¤¬Ìò¤ËΩ¤¿¤Ê¤¤(»È¤ï¤ì¤Ê¤¤)¾ì¹ç¤â¤¢¤ë¡£

À«Ì¾¤ÎÀ«¤¬¡ü¤Ï¡¢»æ¤ÎÅÅÏÃÄ¢¤Çõ¤»¤ë¡£

»æ¤ÎÅÅÏÃÄ¢¤Ë¤Ï¡¢À«¤Î½ç¤Çʤó¤Ç¤¤¤ë¤«¤é¤À¡£

¤·¤«¤·¡¢Ì¾¤¬¡ü¤Î¾ì¹ç¤Ï¡¢¤³¤ì¤¬»È¤¨¤Ê¤¤¡£

Á´¤Æ¤ÎÀ«¤ËÂФ·¤Æ¡¢Ì¾¤¬¡ü¤Ç¤¢¤ë²ÄǽÀ­¤¬¤¢¤ë¤«¤é¤À¡£

Ê£¹çindex¤òÀ«(sei),̾(mei)¤Î½ç¤ÇÀßÄꤷ¤Æ¤â¡¢Ì¾¤Ç¤ÎSELECT»þ¤Ë¤ÏÌò¤ËΩ¤¿¤Ê¤¤¡£

ƱÍͤˡ¢Ì¾¤òÂè°ì´ð½à¤Ë¤¹¤ëORDER BY»þ¤Ë¤âÌò¤ËΩ¤¿¤Ê¤¤¡£

SELECT * FROM `user` ORDER BY `mei`,`sei` ;

¤Þ¤¿¡¢LIKE¤Ç'%¡ü'¤ÈÁ°¤Ë%¤òÆþ¤ì¤¿¾ì¹ç(¸åÊý°ìÃ×)¤â¡¢Á´¤Æ¤Ë°ìÃפ¹¤ë²ÄǽÀ­¤¬¤¢¤ë¤Î¤Çindex¤¬ÌòΩ¤¿¤Ê¤¤¡£

'%¡ü%'¤È¶´¤ó¤ÀÃæ´Ö°ìÃפâƱÍÍ¡£

±é»»¤·¤Æ¤ÎÈæ³Ó¤Ê¤É¤â¡¢index¤ÏÌò¤ËΩ¤¿¤Ê¤¤¡£

WHERE `price` * 1.08 > 1000 ;

¤Î¤è¤¦¤Ê¾ì¹ç¡£

index¤Ë¤¢¤ë¥Ç¡¼¥¿¤Ï`price`¤Ç¤¢¤Ã¤Æ`price` * 1.08¤Ç¤Ï¤Ê¤¤¤«¤é¤À¡£

¤³¤ì¤Ï¡¢Î¾ÊÕ¤ò1.08¤Ç³ä¤Ã¤Æ

WHERE `price` > 1000/1.08 ;

¤È¤¹¤ë¤È¡¢index¤¬»ÈÍѤǤ­¤ë¤è¤¦¤Ë¤Ê¤ë¡£

ÈÝÄê·Á(¡ã¡ä)¤ä¡¢IS NULL¡¢OR¤â¡¢index¤¬ÍøÍѤǤ­¤Ê¤¤¡£

⤷¡¢OR¤ÏIN¤Ç½ñ¤­´¹¤¨¤ë¤È¡¢index¤ò»ÈÍѤǤ­¤ë¤è¤¦¤Ë¤Ê¤ë¡£

EXPLAIN¤Ç¡¢ÀßÄꤷ¤¿index¤¬possible_keys¤Ë´Þ¤Þ¤ì¤Æ¤ª¤ê¡¢key¤Ç¼ÂºÝ¤·»ÈÍѤµ¤ì¤Æ¤¤¤ë¤«³Îǧ¤·¤Æ¤ª¤¯¡£



°Ê²¼¤ÎSQL¥¢¥ó¥Á¥Ñ¥¿¡¼¥ó¤Ï¤ª¤¹¤¹¤á¡£

°­Îã¤òÄ󼨤·¤Æ²òÀ⤷¤Æ¤¢¤ë¡£

¤¢¡¼¡¢¤³¤ì¤³¤ì¡¢¤¢¤ë¤¢¤ë¡ª¤ß¤¿¤¤¤Ê£÷£÷£÷£÷£÷

ÌäÂê¤Ê¤¯Æ°¤¤¤Æ¤¤¤ë¤«¤é¡¢¤È¤¤¤¦SQL¤Î½ñ¤­Êý¤ò¤·¤Æ¤¤¤ë¤È¡¢¥ì¥³¡¼¥É¤¬Áý¤¨¤ë¤È½Å¤¯¤Ê¤Ã¤¿¤ê¤·¤Ê¤¤¡©

¤¢¤È¤Î¤³¤È¤ò¹Í¤¨¤Æ¤¤¤Ê¤¤¤Î¤Í¡£

¤Þ¤¿¡¢Í½ÁÛ¤·¤¿·ë²Ì¤¬SELECT¤µ¤ì¤Æ¤¤¤ë¤«¤éOK¡ª¤ÈȽÃǤ·¤¿¤ê¤·¤Æ¤Ê¤¤¡©

ÍÍ¡¹¤Ê¥ì¥³¡¼¥É¤¬Áý¤¨¤Æ¤­¤¿¾ì¹ç¡¢Í½´ü¤·¤Ê¤¤·ë²Ì¤òÊÖ¤·¤Æ¤³¤Ê¤¤¡©

SQL¥¢¥ó¥Á¥Ñ¥¿¡¼¥ó
Bill Karwin
¥ª¥é¥¤¥ê¡¼¥¸¥ã¥Ñ¥ó
Çä¤ê¾å¤²¥é¥ó¥­¥ó¥°: 7,908


SQLÃæ¤Ç·¿¤ÎÊÑ´¹¤ò¡Ö°Õ¼±¤»¤º¤Ë¡×¤·¤Æ¤·¤Þ¤¤¡¢¤¢¤ì¡©index»ÈÍѤ·¤Æ¤Ê¤¤¡©¤È¤«£÷£÷£÷
[PR] au PAY / au WALLET ¥«¡¼¥É ¾ðÊó

¤³¤Î¥¨¥ó¥È¥ê¡¼¤ò¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯¤ËÄɲà mixi¥Á¥§¥Ã¥¯



¤µ¤¯¤é¥¤¥ó¥¿¡¼¥Í¥Ã¥È¤Î¥ì¥ó¥¿¥ë¥µ¡¼¥Ð¡¼¤ËÉÕ°¤¹¤ë¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ë¿·¤·¤¤¥Ç¡¼¥¿¥Ù¡¼¥¹¤òÄɲ乤ë(CREATE DATABASE)¤Ë¤Ï¡¢¥³¥ó¥È¥í¡¼¥ë¥Ñ¥Í¥ë¤«¤é¤·¤«¤Ç¤­¤Ê¤¤(phpMyAdmin¤«¤é¤Ï¤Ç¤­¤Ê¤¤)¡£

¤³¤ì¤ò¡Ö¿¼¤¯¡×ÃΤäƤª¤«¤Ê¤¤¤È¡¢¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥³¥Ô¡¼¤Ë¤â¼ºÇÔ¤¹¤ë¤³¤È¤Ë¤Ê¤ë¡£

¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥³¥Ô¡¼¤Ï¡¢¤Þ¤º¡¢¥Ç¡¼¥¿¥Ù¡¼¥¹¤òºîÀ®¤·¡¢¤½¤Î¾å¤Ç¥Ç¡¼¥¿¤ò¥³¥Ô¡¼¤¹¤ë¡£

¤Ä¤Þ¤ê¡¢¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎºîÀ®¤¬É¬ÍפȤʤ롣

phpMyAdmin¤«¤é¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥³¥Ô¡¼¤ò¼Â¹Ô¤·¤è¤¦¤È¤¹¤ë¤È¡¢¤½¤ÎºÝ¤Ë CREATE DATABASE ¤ò¼Â¹Ô¤·¤è¤¦¤È¤·¤Æ¼ºÇÔ¤¹¤ë¤Î¤À¡£

# 1044 - Access denied for user 'xxx' to database 'xxx'

# 1044 - Access denied for user 'yyy' to database 'xxx'

(¥æ¡¼¥¶¡¼yyy¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹xxx¤Ø¤Î¥¢¥¯¥»¥¹¤¬µñÈݤµ¤ì¤Þ¤·¤¿)

¤è¤Ã¤Æ¡¢¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò¥³¥Ô¡¼¤¹¤ë¤Ë¤Ï¡¢¤Þ¤º¡¢¥³¥ó¥È¥í¡¼¥ë¥Ñ¥Í¥ë¤«¤é¥Ç¡¼¥¿¥Ù¡¼¥¹¤òºîÀ®¤¹¤ë¡£

¥Ç¡¼¥¿¥Ù¡¼¥¹¤òºîÀ®

¤½¤Î¾å¤Ç¡¢DBÁªÂò¡äÁàºî

¡Ö¥³¥Ô¡¼¤ÎÁ°¤Ë CREATE DATABASE ¤¹¤ë¡×

¤Î¥Á¥§¥Ã¥¯¤ò³°¤·¡¢ºîÀ®¤·¤¿¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ë¸þ¤±¤Æ¼Â¹Ô¤¹¤ì¤Ð¡¢¥³¥Ô¡¼¤¬¤Ç¤­¤ë¡£

¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥³¥Ô¡¼Àè

¥Á¥§¥Ã¥¯¤¬ÉÕ¤¤¤¿¤Þ¤Þ¤À¤È¡¢CREATE DATABASE ¤¬¤Ç¤­¤Ê¤¤¤¿¤á¡¢

# 1007 - Can't create database 'xxx' ; database exists

# 1007 - Can't create database 'xxx' ; database exists

(¥Ç¡¼¥¿¡¼¥Ù¡¼¥¹xxx¤Ï´û¤Ë¸ºß¤¹¤ë¤Î¤ÇºîÀ®¤Ç¤­¤Ê¤¤)

¤È¡¢¥¨¥é¡¼¤È¤Ê¤Ã¤Æ¤·¤Þ¤¦¡£

¤Þ¤¿¡¢ºîÀ®Æ±ÍÍ¡¢¥Ç¡¼¥¿¥Ù¡¼¥¹¤Îºï½ü¤âphpMyAdmin¤«¤é¤Ï¤Ç¤­¤º¡¢¥³¥ó¥È¥í¡¼¥ë¥Ñ¥Í¥ë¤«¤é¹Ô¤¦¡£

¥Ç¡¼¥¿¥Ù¡¼¥¹¤Îºï½ü

¤Ê¤ª¡¢¥³¥ó¥È¥í¡¼¥ë¥Ñ¥Í¥ë¤«¤é¥Ç¡¼¥¿¥Ù¡¼¥¹(MySQL)¤ÏºîÀ®¤Ç¤­¤ë¤¬¡¢ºîÀ®¤Ç¤­¤ë¿ô¤Ë¾å¸Â¤¬¤¢¤ë¡£

¡¦¥é¥¤¥È¡§¤Ê¤·
¡¦¥¹¥¿¥ó¥À¡¼¥É¡§20¸Ä
¡¦¥×¥ì¥ß¥¢¥à¡§50¸Ä
¡¦¥Ó¥¸¥Í¥¹¡§100¸Ä
¡¦¥Ó¥¸¥Í¥¹¥×¥í¡§200¸Ä
¡¦¥Þ¥Í¡¼¥¸¥É¥µ¡¼¥Ð(ÀìÍ­)¡§ÌµÀ©¸Â

¥é¥¤¥È¤ÏMySQL¤¬»È¤¨¤Ê¤¤¤Î¤Ç¡¢MySQL¤ò»È¤¤¤¿¤¤¤Ê¤é¥¹¥¿¥ó¥À¡¼¥É°Ê¾å¤Ë¤·¤è¤¦¡£

¥¹¥¿¥ó¥À¡¼¥È¤Ç¤Ï¾å¸Â20¸Ä¤À¤¬¡¢20¸Ä¤â¤¢¤ì¤Ð½½Ê¬¡©

¥Æ¡¼¥Ö¥ë¤Ï¿¿ôºî¤ì¤ë¤Î¤Ç¤Í¡£

°ÊÁ°¤â½ñ¤¤¤¿¤¬¡¢¤µ¤¯¤é¥¤¥ó¥¿¡¼¥Í¥Ã¥È¤Î(WEB)¥µ¡¼¥Ð¡¼¤ÈDB¥µ¡¼¥Ð¡¼¤Ï¡¢Ê̤Υµ¡¼¥Ð¡¼¤Ç¤¢¤ë¡£

¤µ¤¯¤é¥¤¥ó¥¿¡¼¥Í¥Ã¥È¤Î(WEB)¥µ¡¼¥Ð¡¼¤«¤é¤·¤«¡¢DB¥µ¡¼¥Ð¡¼¤Ë¤ÏÀܳ¤Ç¤­¤Ê¤¤¡£

¾¼Ò¤Î¥ì¥ó¥¿¥ë¥µ¡¼¥Ð¡¼¤«¤é¡¢¤µ¤¯¤é¤ÎDB¥µ¡¼¥Ð¡¼¤Ë¤ÏÀܳ¤Ç¤­¤Ê¤¤¤Î¤À¡£

¥»¥­¥å¥ê¡¼¥Æ¥£¡¼¤ÎÌäÂê¤À¤í¤¦¤Í¡£

ÉÔÌÀ¤Ê²Õ½ê¤«¤é¤ÎÉÔ¿³¤Ê¥¢¥¯¥»¥¹¤Ï¼×ÃǤǤ­¤ë¤·¡¢ÉÔ¿³¤Ê¥¢¥¯¥»¥¹¤¬¤¢¤Ã¤¿¤È¤·¤Æ¤â¡¢¤½¤ì¤Ï¤µ¤¯¤é¤Î´ÉÍýÆâ¤Ç¤¢¤ë¤«¤é(¤µ¤¯¤é¤Ï)¼ê¤ÏÂǤƤ롣
[PR] au PAY / au WALLET ¥«¡¼¥É ¾ðÊó

¤³¤Î¥¨¥ó¥È¥ê¡¼¤ò¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯¤ËÄɲà mixi¥Á¥§¥Ã¥¯



Debian¤ËMySQL¤òÆþ¤ì¤ÆDB¥µ¡¼¥Ð¡¼¤È¤·¡¢¥í¡¼¥«¥ë´Ä¶­¤ËÃÖ¤¯¡£

»î¸³¥µ¡¼¥Ð¡¼¤ò¥í¡¼¥«¥ë¤ËΩ¤Æ¤Æ¡¢ºî¶ÈÍÑüËö¤«¤é¥¢¥¯¥»¥¹¤¹¤ë¤³¤È¤Ï¤è¤¯¤¢¤ë¤³¤È¤À¡£

¤¬¡¢¥Ç¥Õ¥©¥ë¥È¤Ç¤Ï¡¢MySQL¤ÎÆþ¤Ã¤¿Ã¼Ëö¤«¤é¤ÏÅöÁ³¥¢¥¯¥»¥¹¤Ç¤­¤ë¤¬(¼«¸ÊÆâ)¡¢¥í¡¼¥«¥ëÆâ¤Î¾¤ÎüËö¤«¤é¤Ï¥¢¥¯¥»¥¹¤Ç¤­¤Ê¤¤¡£

¤³¤ì¤ò²Äǽ¤Ë¤¹¤ë¤Ë¤Ï¡¢MySQL¤ÎÆþ¤Ã¤¿Ã¼Ëö(DB¥µ¡¼¥Ð¡¼)¤Î

/etc/mysql/my.cnf (MySQL¤ÎÀßÄê¥Õ¥¡¥¤¥ë)

¤òÊÔ½¸¤¹¤ë¡£

¤Ê¤ª¡¢Debian¤Ë¸Â¤é¤ºLinux¤Ç¤Ï¡¢/etc¤ÏÀßÄê¥Õ¥¡¥¤¥ë¤ò³ÊǼ¤¹¤ë¥Ç¥£¥ì¥¯¥È¥ê¤Ç¤¢¤ë¡£

/etc/mysql/my.cnf

¤Ë

bind-address = 127.0.0.1

¤È¤¤¤¦µ­½Ò¤¬¤¢¤ë¤Î¤Ç¡¢¤³¤ì¤òºï½ü¤¹¤ë¤«¡¢ÀèƬ¤Ë#(¥³¥á¥ó¥È¹Ô)¤òÉÕ¤±¤Æ¡¢

# bind-address = 127.0.0.1

¤È¤·¡¢

/etc/init.d/mysql restart

¤Ç¡¢MySQL¤ÎºÆµ¯Æ°¡£

ºÆµ¯Æ°¸å¡¢DB¥µ¡¼¥Ð¡¼¤ËÀܳ¤Ç¤­¤ë¤«¤ò³Îǧ¤¹¤ë¡£

¤³¤ì¤Ç²ò·è¤Ï¤¹¤ë¤Î¤À¤¬¡¢¤³¤Îbind-address¤Ï¡¢Àܳ¤·¤¿¤¤MySQL¤¬Æ°¤¤¤Æ¤¤¤ëüËö¤ÎIP¥¢¥É¥ì¥¹¤Ç¤¢¤ê¡¢Àܳ¤òµö²Ä¤¹¤ëIP¥¢¥É¥ì¥¹¤Ç¤Ï¤Ê¤¤¤Î¤À¡£

½¾¤Ã¤Æ¡¢Àܳ¤Ç¤­¤ëüËö¤òÁý¤ä¤½¤¦¤È¤·¤Æ

bind-address = 127.0.0.1

bind-address = 192.168.0.10

bind-address = 192.168.0.20

¤ÈÊ»µ­¤·¤Æ¤â°ÕÌ£¤¬¤Ê¤¤¡¢¤È¤¤¤¦¤«¡¢¤½¤â¤½¤â̵¸ú¡£

·«¤êÊÖ¤¹¤¬¡¢bind-address¤ÏÀܳ¤òµö²Ä¤¹¤ëIP¥¢¥É¥ì¥¹¤Ç¤Ï¤Ê¤¯¡¢¤³¤ì¤ÇÀܳ¤·¤Æ¤¯¤ëüËö¤ÎIP¤òÀ©¸Â¤¹¤ë¤â¤Î¤Ç¤Ï¤Ê¤¤¡£

¤Ê¤ª¡¢MySQL¤ÎÆþ¤Ã¤¿Ã¼Ëö(DB¥µ¡¼¥Ð¡¼)¤ËApacheÅù¤ÎWEB¥µ¡¼¥Ð¡¼¤¬Æþ¤Ã¤Æ¤ª¤ê¡¢¤½¤ÎWEB¥µ¡¼¥Ð¡¼¤«¤éMySQL¤Ë¥¢¥¯¥»¥¹¤¹¤ë¾ì¹ç¤Ï¡¢¼«¸ÊÆâ¤Ê¤Î¤Ç²¿¤â¤¹¤ëɬÍפϤʤ¤¡£

MySQL¤ÎÆþ¤Ã¤¿Ã¼Ëö(DB¥µ¡¼¥Ð¡¼)¤¬Ê£¿ôÂ椢¤ê¡¢³Æ¡¹Â¾Êý¤Ø¥¢¥¯¥»¥¹¤¹¤ë¤è¤¦¤Ê¾ì¹ç¤â¡¢¾åµ­¤ÎÀßÄêÊѹ¹¤¬É¬Íס£

MySQLÁ´µ¡Ç½¥Ð¥¤¥Ö¥ë ~¸½¾ì¤ÇÌòΩ¤ÄAtoZ~
ÎëÌÚ ·¼½¤
µ»½ÑɾÏÀ¼Ò
Çä¤ê¾å¤²¥é¥ó¥­¥ó¥°: 199,175


[PR] au PAY / au WALLET ¥«¡¼¥É ¾ðÊó

¤³¤Î¥¨¥ó¥È¥ê¡¼¤ò¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯¤ËÄɲà mixi¥Á¥§¥Ã¥¯



¼«»ª(¼«Í³ÅÙ¹â)¤ò»È¤¦¤³¤È¤¬Â¿¤¤¤¬¡¢¤µ¤¯¤é¥¤¥ó¥¿¡¼¥Í¥Ã¥È¤Î¥æ¡¼¥¶¡¼¤«¤é¼ÁÌä¤ò¼õ¤±¤¿¤Î¤Ç¥á¥â¡£





WEB¥µ¡¼¥Ð¡¼Æâ¤Ëcsv¥Õ¥¡¥¤¥ë¤òÃÖ¤¤¤Æ¡¢¤½¤ì¤òDB(MySQL)¤Ë¥¤¥ó¥Ý¡¼¥È¤¹¤ë¡£

phpMyAdmin¤Î¥¤¥ó¥Ý¡¼¥Èµ¡Ç½¤ò»È¤¨¤Ð²Äǽ¤À¤¬¡¢php¥×¥í¥°¥é¥à¤Ç¼Â¹Ô¤·¤¿¤¤¡£

¤È¤Ê¤ë¤È¡¢LOAD DATA LOCAL INFILE¤¬¹Í¤¨¤é¤ì¤ë¡£

­¡ LOAD DATA INFILE
¥¤¥ó¥Ý¡¼¥ÈÀè¤ÎDB¤¬¤¢¤ë¥µ¡¼¥Ð¡¼¤Ëcsv¥Õ¥¡¥¤¥ë¤¬¤¢¤ë¾ì¹ç

­¢ LOAD DATA LOCAL INFILE
¥¯¥é¥¤¥¢¥ó¥È¤Ë¤¢¤ëcsv¥Õ¥¡¥¤¥ë¤ò¥µ¡¼¥Ð¡¼¤ÎDB¤Ø

MySQLÁ´µ¡Ç½¥Ð¥¤¥Ö¥ë¤Î381¥Ú¡¼¥¸

¤³¤Î¾ì¹ç¤Ï­¡¤¬»ÈÍѲÄǽ¤È»×¤¨¤ë¤¬¡¢csv¥Õ¥¡¥¤¥ë¤Î¤¢¤ë¥µ¡¼¥Ð¡¼(WEB¥µ¡¼¥Ð¡¼)¤ÈMySQL¤Î¤¢¤ë¥µ¡¼¥Ð¡¼(DB¥µ¡¼¥Ð¡¼)¤¬Ê̤ξì¹ç(¤µ¤¯¤é¥¤¥ó¥¿¡¼¥Í¥Ã¥ÈÅù)¤Ï¡¢¤³¤ÎÊýË¡¤Ç¤ÏÉÔ²Äǽ¤Ç¤Ï¡©

¥Í¥Ã¥È¤ÇÄ´¤Ù¤ë¤È¡¢À®¸ù¤·¤¿¤È¤«¤·¤Ê¤«¤Ã¤¿¤È¤«¡¢mysqlimport¤ÇÀ®¸ù¤·¤¿Åù¤Î¾ðÊ󤬤¢¤ë¤¬¡¢Æ±¤¸¥ì¥ó¥¿¥ë¥µ¡¼¥Ð¡¼¶È¼Ô¤Ç¤â¡¢DB¤Î¥Ð¡¼¥¸¥ç¥ó¤äÀßÄ꤬°Û¤Ê¤ë¤Î¤Ç¡¢¼ÂºÝ¤Ï¼«Ê¬¤Ç»î¤·¤Æ¤ß¤Ê¤¤¤È¤Ê¤é¤Ê¤¤¡£

¤Þ¤¿¡¢¾ðÊó¤Î»þ´ü¤ËÃí°Õ¡£

°ÊÁ°¤ÏÍ­¸ú¤Ç¤â¡¢º£¤Ï̵¸ú¤È¤¤¤¦¤³¤È¤¬¤¢¤ë¤«¤é¤À¡£

phpMyAdmin¤Ç¤Î¥¤¥ó¥Ý¡¼¥È¤Ç¤Ï¡¢ºÇÂ祵¥¤¥º¤ÎÀ©¸Â¤¬¤¢¤ë(ºÇĹ¡§16MiB)¡£

¼«¸Ê´ÉÍý¤Î¥í¡¼¥«¥ë¥µ¡¼¥Ð¡¼Åù¡¢¼«Í³Å٤Τ¢¤ë¾ì¹ç¤Ï¾å¸ÂÃͤòÊѹ¹¤Ç¤­¤ë¤¬¡¢¥ì¥ó¥¿¥ë¥µ¡¼¥Ð¡¼¤Î¾ì¹ç¤Ïº¤Æñ¤À¤í¤¦¡£

¤½¤Î¤è¤¦¤Ê¾ì¹ç¡¢FTP¤Çcsv¥Õ¥¡¥¤¥ë¤ò¾å¤²¤Æ¤ª¤¤¤Æ¡¢°Ê²¼¤ÎÊýË¡¤ÇDB¤Ë¥¤¥ó¥Ý¡¼¥È¤¹¤ë¤È¤è¤¤¤À¤í¤¦¡£

php¤Ç¥×¥í¥°¥é¥à¤ò½ñ¤¤¤Æ¤ª¤¯¤È¡¢¥³¥Þ¥ó¥ÉÂǤ¿¤Ê¤¯¤Æ¤â¤¤¤¤¤·¤Í¡£

°Ê²¼¡¢¼ê½ç¡£

csv¥Õ¥¡¥¤¥ë¤Î½àÈ÷



WEB¥µ¡¼¥Ð¡¼¾å¤Î /home/aaa/www/ ¤Ë test.csv ¤òÃÖ¤¯¡£

aaa¤Ï¡¢¤µ¤¯¤é¥¤¥ó¥¿¡¼¥Í¥Ã¥È¤Ç¤Î¥¢¥«¥¦¥ó¥È̾¡£

test.csv¤ÎÃæ¿È¤Ï

1,first
2,second
3,third
4,forth
5,fifth

¤È¤¤¤¦¡¢¥«¥ó¥Þ¶èÀÚ¤ê¤Î´Êñ¤Ê¤â¤Î¡£

DB¤Î½àÈ÷



mysql***.db.sakura.ne.jp - aaa_xxx - test

¤Ë¡¢°Ê²¼¤Î¤è¤¦¤Ê¥Æ¡¼¥Ö¥ë(test)¤òºîÀ®¤·¤Æ¤ª¤¯¡£

¥Æ¡¼¥Ö¥ë

¡¦id int
¡¦name text

***¤Ï¡¢¤µ¤¯¤é¥¤¥ó¥¿¡¼¥Í¥Ã¥È¤«¤é³ä¤êÅö¤Æ¤é¤ì¤¿DB¤ÎÈֹ档

aaa_xxx¤ÏDB̾¤À¤¬¡¢É¬¤ºaaa_¤¬Éղ䵤ì¤ë¤Î¤Ï¡¢¤µ¤¯¤é¥¤¥ó¥¿¡¼¥Í¥Ã¥È¤Î»ÅÍÍ¡£

¥³¥Þ¥ó¥É¤òµ­¤·¤¿php¥Õ¥¡¥¤¥ë¤òºîÀ®¡¢¼Â¹Ô



WEB¥µ¡¼¥Ð¡¼¤Îtest.csv¤ÈƱ¤¸¥Ç¥£¥ì¥¯¥È¥ê¤Ë

¡ã?PHP

$import = "mysqlimport -h mysql***.db.sakura.ne.jp -u aaa -p(¥Ñ¥¹¥ï¡¼¥É) -L --fields-terminated-by=',' aaa_xxx /home/aaa/www/test.csv" ;

system($import) ;

?¡ä


¤È¤¤¤¦php¥Õ¥¡¥¤¥ë(import.php¤È¤¹¤ë)¤òÃÖ¤­¡¢¤³¤ì¤ò¼Â¹Ô¡£

¡¦-h mysql***.db.sakura.ne.jp¡¡¥Û¥¹¥È
¡¦-u aaa¡¡DB¥¢¥¯¥»¥¹ÍѤΥ桼¥¶Ì¾
¡¦-p(¥Ñ¥¹¥ï¡¼¥É)¡¡DB¥¢¥¯¥»¥¹ÍѤΥѥ¹¥ï¡¼¥É¡¢-p¤Ë³¤±¤Æ(¥¹¥Ú¡¼¥¹¤Ê¤·¤Ë)½ñ¤¯¤³¤È
¡¦-L¡¡¥í¡¼¥«¥ë¥Õ¥¡¥¤¥ë¤«¤éÆɤ߹þ¤à¥ª¥×¥·¥ç¥ó
¡¦--fields-terminated-by=','¡¡csv¥Õ¥¡¥¤¥ë¤Î¶èÀÚʸ»ú¡¢º£²ó¤Ï¡Ö,(Ⱦ³Ñ¥«¥ó¥Þ)¡×
¡¦aaa_xxx¡¡DB̾
¡¦/home/aaa/www/test.csv¡¡csv¥Õ¥¡¥¤¥ë¤Î¾ì½ê

¤¹¤ë¤È¡¢

aaa_xxx.test: Records: 5 Deleted: 0 Skipped: 0 Warnings: 0

¤Èɽ¼¨¤µ¤ì¡¢°Ê²¼¤Î¤è¤¦¤Ë¥Ç¡¼¥¿¤¬³ÊǼ¤µ¤ì¤ë¡£

csv¤ÎÆâÍƤ¬³ÊǼ¤µ¤ì¤Æ¤¤¤ë
csv¤ÎÆâÍƤ¬³ÊǼ¤µ¤ì¤Æ¤¤¤ë

¤µ¤Æ¡¢¾å¤Îmysqlimport¡Á¤Ë¤Æ¡¢DB̾¤Î»ØÄê¤Ï¤¢¤ë¤¬¡¢¥Æ¡¼¥Ö¥ë̾¤Î»ØÄê¤Ï¤Ê¤¤¤Î¤«¡©

¤Èµ¿Ìä¤Ë»×¤¦¤¬¡¢test.csv¤Î³ÈÄ¥»Ò¤ò¼è¤Ã¤¿¤â¤Î¤¬¡¢¥Æ¡¼¥Ö¥ë̾¤Ê¤Î¤À¡£

¤Ä¤Þ¤ê¡¢¥Õ¥¡¥¤¥ë¤¬test.txt¤Î¾ì¹ç¤â¡¢test¤¬¥Æ¡¼¥Ö¥ë̾¡£

¥Õ¥¡¥¤¥ë̾¤È¥Æ¡¼¥Ö¥ë̾¤¬°Û¤Ê¤ë¾ì¹ç¤Ï¡©

import.php¤ò¥ê¥í¡¼¥É¤¹¤ë¤È¡¢¥Ç¡¼¥¿¤¬¡ÖÄɵ­¡×¤µ¤ì¤Æ¤·¤Þ¤¦¡£

2²ó³ÊǼ¤µ¤ì¤Æ¤¤¤ë
2²ó³ÊǼ¤µ¤ì¤Æ¤¤¤ë

¤³¤ì¤òËɤ°¤Ë¤Ï¡¢

--delete¡¡¥¤¥ó¥Ý¡¼¥È¤¹¤ëÁ°¤Ë¥Æ¡¼¥Ö¥ë¤ò¶õ¤Ë¤¹¤ë

¤Î¥ª¥×¥·¥ç¥ó¤òÄɲ乤롣

¤³¤ì¤Ç¡¢³ÊǼÁ°¤Ë¶õ¤Ë¤·¤Æ¤¯¤ì¤ë¤Î¤Ç¡¢Äɵ­¤Ï²óÈò¤Ç¤­¤ë¡£

¤Ê¤ª¡¢¸¶°ø¤ÏÉÔÌÀ¤À¤¬ -D ¤Ç¤Ï¥¨¥é¡¼¤È¤Ê¤ë(¥¨¥é¡¼É½¼¨¤Ï¤Ê¤¤¤¬³ÊǼ¤µ¤ì¤Ê¤¤)¡£

--delete ¤Ê¤éÌäÂê¤Ê¤·¡£

--¥ª¥×¥·¥ç¥ó¤ËÂФ·¡¢-¾Êά·Á¡¢¤Ä¤Þ¤ê¡¢

--delete ¤È -D ¤ÏƱ°Õ¤È¤¤¤¦Íý²ò¤Ï´Ö°ã¤Ã¤Æ¤¤¤ë¤Î¤«¡©

´ØÏ¢¡§mysqlimport --help¤ÎÆâÍÆ csv¥Õ¥¡¥¤¥ë¤ÎÆâÍƤò¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ë¥¤¥ó¥Ý¡¼¥È¤¹¤ë

¥ì¥³¡¼¥É¤Î¶èÀÚ¤ê



¹àÌܤζèÀÚ¤ê¤Ï¡Ö,(¥«¥ó¥Þ)¡×¤Ç»ØÄꤷ¤Æ¤¤¤ë¤¬¡¢¥ì¥³¡¼¥É¤Î¶èÀÚ¤ê¤Ï¡Ö--lines-terminated-by="¡ü"¡×¤Ç¹Ô¤¦¡£

Î㤨¤Ð¡¢¹ÔƬ¤Ë¡Ö^¡×¤¬Æþ¤Ã¤Æ¤¤¤ë(¹ÔËö¤Ç¤â¤è¤¤)¡¢°Ê²¼¤Î¤è¤¦¤Ê¥Ç¡¼¥¿¤Î¾ì¹ç¡¢

^1,aaa,xxx
^2,bbb,yyy
^3,ccc,ddd

¡Ö--lines-terminated-by="^"¡×¤È¤¹¤ë¤³¤È¤Ç¡¢²þ¹ÔÉ÷¤Ë°·¤¨¤ë¡£

¤Ä¤Þ¤ê¡¢°Ê²¼¤Î¤è¤¦¤Ë²þ¹Ô¤¬¤Ê¤¤¾ì¹ç¤Ç¤â¡¢

^1,aaa,xxx^2,bbb,yyy^3,ccc,ddd

¡Ö--lines-terminated-by="^"¡×¤ÇÀڤ뤳¤È¤¬²Äǽ¤À¡£

1·ï¤Î¥ì¥³¡¼¥É¤¬Ã»¤¤¾ì¹ç¤Ï¡¢²þ¹Ô¤Ë¤è¤Ã¤Æ¥ì¥³¡¼¥É¤Î½ªÃ¼¤¬¸«¤¨¤ë¤¬¡¢1·ï¤Î¥ì¥³¡¼¥É¤¬Èó¾ï¤ËŤ¤¾ì¹ç¡¢¤É¤³¤Þ¤Ç¤¬¥ì¥³¡¼¥É¤Î¶èÀڤ꤫ʬ¤«¤é¤Ê¤¯¤Ê¤ë¤Î¤Ç¡¢¶èÀÚ¤êʸ»ú¤òÆþ¤ì¤Æ¤ª¤¯¤È¡¢Æ°ºî³Îǧ¤ÎºÝ¤Ë¤âÌòΩ¤Ä¡£

¥ª¥×¥·¥ç¥ó¤Ë´Ø¤·¤Æ¤Ï¡¢°Ê²¼¤ò»²¾È¤Î¥³¥È¡£

´ØÏ¢¡§mysqlimport --help¤ÎÆâÍÆ csv¥Õ¥¡¥¤¥ë¤ÎÆâÍƤò¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ë¥¤¥ó¥Ý¡¼¥È¤¹¤ë

cron¤ËÅÐÏ¿¡¢¼«Æ°¼Â¹Ô



¤³¤Îphp¥Õ¥¡¥¤¥ë¤òÄê´üŪ¤Ë¼Â¹Ô¤¹¤ë¤Ë¤Ï¡¢cron¤ËÅÐÏ¿¤¹¤ì¤Ð¤è¤¤¡£

cd /home/aaa/www ; /usr/local/bin/php test.php > /dev/null

test.php¤Î¤¢¤ë¥Ç¥£¥ì¥¯¥È¥ê ; PHP¤Î¥³¥Þ¥ó¥É¥Ñ¥¹ ¥×¥í¥°¥é¥à¤òµ­¤·¤¿php¥Õ¥¡¥¤¥ë ¥á¡¼¥ëÀßÄê

ºÇ¸å¤Î ¡ä/dev/null ¤Ï postmaster@aaa.sakura.ne.jp ¤Ø¥á¡¼¥ë¤òÁ÷¤é¤Ê¤¤¾ì¹ç¤Ë½ñ¤¯¡£

¤½¤·¤Æ¡¢cron¤¬¼Â¹Ô¤Ç¤­¤ë¤è¤¦¤Ë¡¢test.php¤Î¥Ñ¡¼¥ß¥Ã¥·¥ç¥ó¤ò755¤ËÀßÄê¡£

ÀßÄê¸å¤Ï¡¢»ØÄꤷ¤¿´Ö³Ö¤ä»þ´Ö¤Ë¡¢ÌäÂê¤Ê¤¯DB¤Ë³ÊǼ¤µ¤ì¤ë¤«¤ò³Îǧ¤¹¤ë¡£

¥á¡¼¥ë¤òÁ÷¤ëÀßÄê¤Ç¤¢¤ì¤Ð Permission denied Åù¤Î¥¨¥é¡¼¤¬ postmaster@aaa.sakura.ne.jp ¤ËÁ÷¤é¤ì¤ë¤Î¤Ç¡¢³Î¼Â¤ËÆ°¤¯¤³¤È¤ò³Îǧ¤¹¤ë¤Þ¤Ç¤Ï ¡ä/dev/null ¤òÉÕ¤±¤Ê¤¤Êý¤¬¤¤¤¤¡£

cron¤Ï5¸Ä¤Þ¤Ç¤·¤«ÀßÄê¤Ç¤­¤Ê¤¤¤è¤¦¤À¤¬¡¢¥³¥ó¥È¥í¡¼¥ë¥Ñ¥Í¥ë¤«¤é¤Ç¤Ï¤Ê¤¯¡¢¥µ¡¼¥Ð¡¼¤ËÀܳ¤·¥³¥Þ¥ó¥É¤Ç¤ä¤ì¤Ð¡¢5¸Ä°Ê¾å²Äǽ¡©

insecure(°ÂÁ´¤Ç¤Ï¤Ê¤¤)¤È¸À¤ï¤ì¤ë¾ì¹ç



¾åµ­¤òcron¤Ç¼Â¹Ô¤·¤¿»þ¡¢Æ°ºî¤ÏÀ®¸ù¤¹¤ë¤¬¡¢

mysqlimport: [Warning] Using a password on the command line interface can be insecure.

¤È¤¤¤¦¥á¡¼¥ë¤¬¡¢´ÉÍý¼Ô°¸¤ËÆϤ¯¤³¤È¤¬¤¢¤ë¡£

cron¤Ë¡Ö1> /dev/null¡×¤òÉÕ¤±¤Æ¤¤¤¿¤È¤·¤Æ¤â¤À¡£

¥³¥Þ¥ó¥É¥é¥¤¥ó¤Ë¥Ñ¥¹¥ï¡¼¥É¤ò´Þ¤ó¤Ç¤¤¤ë¤Î¤Ç¡¢°ÂÁ´¤Ç¤Ï¤Ê¤¤¤È¤¤¤¦¥³¥È¤À¡£

¤³¤ì¤ò²óÈò¤¹¤ë¤Ë¤Ï¡¢¥Ñ¥¹¥ï¡¼¥É¤òÊÌ¥Õ¥¡¥¤¥ë¤Ëµ­¤·¤ÆÃÖ¤­¡¢¥³¥Þ¥ó¥É¥é¥¤¥ó¤Ç¥½¥ì¤òÆɤ߼è¤ì¤Ð¤è¤¤¡£

¥Ñ¥¹¥ï¡¼¥É¤À¤±¤òÊÌ¥Õ¥¡¥¤¥ë¤Ë¤¹¤ì¤Ð¡Ö°ÂÁ´¤Ç¤Ï¤Ê¤¤¡×¤È¤Ï¸À¤ï¤ì¤Ê¤¯¤Ê¤ë¤¬¡¢¤É¤¦¤»¤Ê¤é¡¢¥æ¡¼¥¶¡¼Ì¾¤È¥Û¥¹¥È¤âÊÌ¥Õ¥¡¥¤¥ë¤Ë¤·¤¿Êý¤¬¡¢¤è¤ê°ÂÁ´¤À¤í¤¦¡£

¤Þ¤º¡¢°Ê²¼¤Î¥í¥°¥¤¥ó¾ðÊó¤òµ­¤·¤¿¥Õ¥¡¥¤¥ë¤ò¡¢login.conf(̾¾Î¤ÏǤ°Õ)¤È¤·¤ÆÊݸ¤¹¤ë¡£

¡Ý¡Ý¡Ý¡Ý¡Ý

[client]
user = ¥æ¡¼¥¶¡¼Ì¾
password = ¥Ñ¥¹¥ï¡¼¥É
host = ¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥Û¥¹¥È

¡Ý¡Ý¡Ý¡Ý¡Ý

ÅöÁ³¡¢login.conf¤Ï°ÂÁ´¤Ê¾ì½ê¤ËÀßÃÖ¤¹¤ëɬÍפ¬¤¢¤ë¡£

¤µ¤¯¤é¥¤¥ó¥¿¡¼¥Í¥Ã¥È¤Ê¤é¡¢

/home/¥æ¡¼¥¶¡¼Ì¾/www

¤Îwww¤ÎÃ椬¸ø³«¥Ç¥£¥ì¥¯¥È¥ê¤À¤¬¡¢¤½¤Î¾å(www¤ÎÃæ¤Ç¤Ï¤Ê¤¯Æ±³¬ÁØ)¤ËÃÖ¤±¤Ð°ÂÁ´¤À¤í¤¦¡£

¤µ¤é¤Ë¡¢¥Õ¥¡¥¤¥ë¤Î¥Ñ¡¼¥ß¥Ã¥·¥ç¥ó¤ò400(½êÍ­¼Ô¤ÎÆɤ߼è¤ê¤Î¤ß)¤Ë¥·¥Æ¥ª¥¯¡£

¤½¤·¤Æ¡¢¾å½Ò¤Î¥³¥Þ¥ó¥É¥é¥¤¥ó¤«¤é¡Ö-h(¥Û¥¹¥È) -u(¥æ¡¼¥¶¡¼) -p(¥Ñ¥¹¥ï¡¼¥É)¡×¤òºï½ü¤·¡¢Âå¤ï¤ê¤Ë

--defaults-extra-file=/home/¥æ¡¼¥¶¡¼Ì¾/login.conf

¤òÄɲ乤롣

¤½¤¦¤¹¤ì¤Ð¡¢¥³¥Þ¥ó¥É¥é¥¤¥ó¤Ë¥í¥°¥¤¥ó¾ðÊó¤ò´Þ¤Þ¤Ê¤¤¤Î¤Ç¡¢°ÂÁ´¤Ç¤Ï¤Ê¤¤¤È¤Ï¥¤¥ï¥ì¥Ê¤¯¤Ê¤ë¡£

´ØÏ¢¡§¤µ¤¯¤é¥¤¥ó¥¿¡¼¥Í¥Ã¥È¤ÎCRON¤ÎÀßÄê²èÌÌ(1.CRON¤ÎÀßÄê)

´ØÏ¢¡§¤µ¤¯¤é¥¤¥ó¥¿¡¼¥Í¥Ã¥È¤ÎCRON¤ÎÀßÄê²èÌÌ(2.CRON¥¹¥±¥¸¥å¡¼¥ëÀßÄê)





MySQLÁ´µ¡Ç½¥Ð¥¤¥Ö¥ë ~¸½¾ì¤ÇÌòΩ¤ÄAtoZ~
ÎëÌÚ ·¼½¤
µ»½ÑɾÏÀ¼Ò
Çä¤ê¾å¤²¥é¥ó¥­¥ó¥°: 170,416
[PR] au PAY / au WALLET ¥«¡¼¥É ¾ðÊó

¤³¤Î¥¨¥ó¥È¥ê¡¼¤ò¤Ï¤Æ¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯¤ËÄɲà mixi¥Á¥§¥Ã¥¯

¤³¤Î¥Ú¡¼¥¸¤Î¥È¥Ã¥×¥Ø