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

ockeghem id:ockeghem

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

${{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 Casual Advent Calendar 2011 ã®18æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ æ˜”ã€å°‚ã‚‰ PostgreSQL ã‚’ä½¿ã£ã¦ã„ãŸé ƒã€MySQL ã®ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã£ã¦ç°¡å˜ã«æ€§èƒ½ä¸ŠãŒã‚‹ã—ã¿ãŸã„ã ã—ç¾¨ã¾ã—ã„ãªã‚ã€ã¨æ€ã£ã¦ã„ã¾ã—ãŸã€‚ãã®ãŸã‚ã€1å¹´ã»ã©å‰ã‹ã‚‰æ¥å‹™ã§ MySQL ã‚’ä½¿ã†ã‚ˆã†ã«ãªã£ã¦ã‚‚ã€ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã¯å½“ç„¶ã®ã”ã¨ãæœ‰åŠ¹ã«ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ ã¨ã“ã‚ãŒå…ˆæ—¥ DSASé–‹ç™ºè€…ã®éƒ¨å±‹:ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã¯åˆ‡ã£ãŸã»ã†ãŒã„ã„ã‚“ã˜ã‚ƒãªã‚¤ã‚«ï¼Ÿ ã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªã‚’èªã¿ã¾ã—ã¦ã€ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã¯ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒã‚¯ã‚’ç²å¾—ã™ã‚‹ã¨ã®ã“ã¨ã€‚ã“ã‚Œã¯ã¡ã‚‡ã£ã¨æ¤œè¨¼ã—ã¦ã¿ãªã‘ã‚Œã°ãªã‚‹ã¾ã„ã€ã¨ã„ã†ã“ã¨ã§ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’ã—ã¦ã¿ã¾ã—ãŸã€‚ ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯çµæžœ çµæžœã¯åˆ¥ãƒšãƒ¼ã‚¸ã«ã¾ã¨ã‚ã¾ã—ãŸ benchmark script ã¨ my.cnf ã–ã£ãã‚Šã¨èª¬æ˜Žã—ã¾ã™ã¨ã€ å¹³å‡ 260 byte/è¡Œã€1
ockeghem 2011/12/18
ã€Žquery cacheãªã‚“ã¦ã„ã‚‰ãªã‹ã£ãŸã‚“ã‚„ï¼ã£ã¦ã‹ã‚“ã˜ã€<èˆˆå‘³æ·±ã„

mysql
ãƒªãƒ³ã‚¯
DBD::mysql 4.020ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸ | ã¸ã¼ã„æ—¥è¨˜
DBD::mysqlã®4.020ãŒæ˜¨æ—¥ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚ ã“ã®ãƒªãƒªãƒ¼ã‚¹ã«ã¯mysql_server_prepare=1ã‚’ä½¿ã£ã¦ã„ã‚‹å ´åˆã®ãƒã‚°ã®ä¿®æ£ãŒ5ä»¶ã»ã©å«ã¾ã‚Œã¦ã„ã¾ã™ã€‚(ChangeLog) DBD::mysql ã§ mysql_server_prepare=1 ã®ã¨ã TEXT åž‹ã®æ¬„ãŒè‡ªå‹• utf8::decode ã•ã‚Œãªããªã‚‹ ã“ã¡ã‚‰ã®ãƒ–ãƒã‚°ã§æŒ‡æ‘˜ã•ã‚Œã¦ã„ãŸä»¶ã‚’ç›´ã—ã¦ãƒ‘ãƒƒãƒã‚’é€ã‚ã†ã¨æ€ã£ã¦ãŠã‚‚ã‚€ã‚ã«mysql_server_prepare=1ã®çŠ¶æ…‹ã§DBD::mysqlã®ãƒ†ã‚¹ãƒˆã‚’å®Ÿè¡Œã—ãŸã‚‰å¤±æ•—ã—ã¾ãã£ãŸãŸã‚ã€ã‚‚ã†é§„ç›®ã‹ã‚‚ã—ã‚Œãªã„ã¨æ€ã£ãŸã®ã§ã™ãŒã€ä½•æ•…ã‹mysql_server_prepareã¨å¿ƒä¸ã™ã‚‹è…¹ã‚’ããã‚Šä¸€å¿œã™ã¹ã¦ã®ãƒ†ã‚¹ãƒˆã‚’é€šã™ã‚ˆã†ã«ãƒ‘ãƒƒãƒã‚’é€ã‚Šã¾ãã£ã¦ã¿ãŸã¨ã“ã‚å–ã‚Šè¾¼ã¾ã‚ŒãŸã¨ã„ã†æ„Ÿã˜ã«ãªã‚Šã¾ã—ãŸã€‚(ãƒªãƒªãƒ¼ã‚¹å¾Œã«2ã¤ã»ã©ã•ã‚‰ã«pull reqã—ã¦ã„ã¾ã™ãŒâ€¦ã€‚) TEXTåž‹
ockeghem 2011/08/22
é‡è¦ãªä¿®æ£ã€‚åƒè‘‰ã•ã‚“å‰ã„ãªã

mysql

dbd
ãƒªãƒ³ã‚¯
CVE-2009-1151 phpMyAdmin Remote Code Execution Proof of Concept
ockeghem 2011/08/08
php

phpmyadmin

mysql
ãƒªãƒ³ã‚¯
phpMyAdminã«ãŠã‘ã‚‹ä»»æ„ã‚¹ã‚¯ãƒªãƒ—ãƒˆå®Ÿè¡Œå¯èƒ½ãªè„†å¼±æ€§ã®æ¤œè¨¼ - ockeghem's blog
phpMyAdminï¼ˆ3.3.10.2æœªæº€ã€3.4.3.1æœªæº€ï¼‰ã«ã¯ã€ãƒªãƒ¢ãƒ¼ãƒˆã‹ã‚‰ä»»æ„ã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆãŒå®Ÿè¡Œå¯èƒ½ãªè„†å¼±æ€§ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã¯ã€ã“ã®è„†å¼±æ€§ãŒç™ºç”Ÿã™ã‚‹ãƒ¡ã‚«ãƒ‹ã‚ºãƒ ã¨å¯¾ç–ã«ã¤ã„ã¦å ±å‘Šã—ã¾ã™ã€‚ æ¦‚è¦ phpMyAdminã«ã¯ä¸‹è¨˜ã®2ç¨®é¡žã®è„†å¼±æ€§ã®çµ„ã¿åˆã‚ã›ã«ã‚ˆã‚Šã€ãƒªãƒ¢ãƒ¼ãƒˆã‹ã‚‰ä»»æ„ã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’å®Ÿè¡Œã•ã›ã‚‰ã‚Œã‚‹è„†å¼±æ€§ãŒã‚ã‚Šã¾ã™ã€‚ CVE-2011-2505 CVE-2011-2506 è©²å½“ã™ã‚‹ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™ã€‚ phpMyAdmin ãƒãƒ¼ã‚¸ãƒ§ãƒ³3.3.10.2æœªæº€ phpMyAdmin ãƒãƒ¼ã‚¸ãƒ§ãƒ³3.4.3.1æœªæº€ å½±éŸ¿ã‚’å—ã‘ã‚‹æ¡ä»¶ã¯ã€ä¸Šè¨˜ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®phpMyAdminã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã“ã¨ã«åŠ ãˆã¦ã€ä»¥ä¸‹ã‚’ã™ã¹ã¦æº€ãŸã™å ´åˆã§ã™ã€‚ setup/index.phpã¨setup/config.phpã‚’å¤–éƒ¨ã‹ã‚‰å®Ÿè¡Œã§ãã‚‹ phpMyAdminã®configãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªãŒå˜åœ¨ã—ã€PHP
ockeghem 2011/08/08
æ—¥è¨˜æ›¸ã„ãŸ

security

php

phpmyadmin

mysql
ãƒªãƒ³ã‚¯
Mundane Life: MySQL ã® Prepared Statement
Sunday, April 10, 2011 MySQL ã® Prepared Statement ã‘ã•ã¯ã€SQL ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚’å°‘ã—ã ã‘å‹‰å¼·ã—ãŸã®ã§ã€ãã‚Œã«é–¢ã—ã¦ã€ã”ãç§çš„ãªãƒ¡ãƒ¢ã‚’æ›¸ãæ®‹ã—ã¦ãŠã“ã†ã¨æ€ã†ã€‚æƒ…å ±å‡¦ç†æŽ¨é€²æ©Ÿæ§‹ (IPA) ã® ã€Œå®‰å…¨ãªã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä½œã‚Šæ–¹ã€ ã§ã¯ã€SQL ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®è„†å¼±æ€§ã‚’äºˆé˜²ã™ã‚‹ãŸã‚ã®æ ¹æœ¬çš„è§£æ±ºã¨ã—ã¦ã€ã¾ãšç¬¬ä¸€ã« ã€ŒSQL æ–‡ã®çµ„ã¿ç«‹ã¦ã¯å…¨ã¦ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã§å®Ÿè£…ã™ã‚‹ã€(æ”¹è¨‚ç¬¬5ç‰ˆ p.9) ã¨è¿°ã¹ã¦ã„ã‚‹ã€‚ ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ãƒ¼ã«ã¯ã€å‹•çš„ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ãƒ¼ã¨é™çš„ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ãƒ¼ãŒã‚ã£ã¦ã€ã“ã‚Œã‚‰ã«ã¤ã„ã¦ã¯ IPA ã® ã€Œå®‰å…¨ãª SQL ã®å‘¼ã³å‡ºã—æ–¹ã€ ãŒè©³ã—ã„ã€‚ ã¾ãŸã€æœ€è¿‘åˆŠè¡Œã•ã‚ŒãŸ ã€Žä½“ç³»çš„ã«å¦ã¶ å®‰å…¨ãª Web ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä½œã‚Šæ–¹ã€(å¾³ä¸¸æµ©è‘— ã‚½ãƒ•ãƒˆãƒãƒ³ã‚¯ã‚¯ãƒªã‚¨ã‚¤ãƒ†ã‚£ãƒ– ISBN978-4-7973-6119-3) ã«ã‚‚è©³ã—ã„è§£èª¬ãŒè¼‰ã£ã¦ã„ã‚‹ã€‚å¤§
ockeghem 2011/04/10
è‰¯ã„è¨˜äº‹ã€‚MySQLã®å‹•çš„/é™çš„ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã‚’ãƒ‘ã‚±ãƒƒãƒˆã‚ãƒ£ãƒ—ãƒãƒ£ã§ç¢ºèªã—ã¦ã„ã‚‹ã€‚ãã®ä»–ãƒã‚¿ã‚‚ã‚ã‚Š

security

sql

mysql
ãƒªãƒ³ã‚¯
MySQLã§å¤–éƒ¨ã‹ã‚‰æŽ¥ç¶šã™ã‚‹ã¨ãã«ãƒã‚§ãƒƒã‚¯ã™ã‚‹é …ç›® - yummy-yummy
ã‚µãƒ¼ãƒãƒ¼ã«MySQLã‚’å…¥ã‚ŒãŸã‘ã©ã€å¤–ã®ãƒžã‚·ãƒ³ï¼ˆãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ï¼‰ã‹ã‚‰æŽ¥ç¶šã§ããªã„ã‚ˆï¼ã£ã¦æ™‚ã¯ä»¥ä¸‹ã®å†…å®¹ã‚’ãƒã‚§ãƒƒã‚¯ã—ã¦ã¿ã‚‹ã€‚ 1. mysqldã®userãƒ†ãƒ¼ãƒ–ãƒ«ã®è¨å®š ä»¥ä¸‹ã‚³ãƒžãƒ³ãƒ‰ã§ãƒ¦ãƒ¼ã‚¶ã®æ¨©é™çŠ¶æ…‹ã‚’ç¢ºèªã€‚ $ mysql -u root mysql mysql> select user, host, password from user;æ¨©é™ãŒç„¡ã„å ´åˆã¯GRANTã‚³ãƒžãƒ³ãƒ‰ã§ã€å¤–éƒ¨ã‹ã‚‰ã®æŽ¥ç¶šã‚’è¨±å¯ã™ã‚‹ã“ã¨ã€‚ mysqlãƒ¦ãƒ¼ã‚¶ã®è¿½åŠ æ–¹æ³•ã€GRANTã®ä½¿ç”¨æ³•ç‰å‚ç…§ã€‚ 2.my.cnfã®bind-addressè¨å®š my.confã®bind-addressã®è¨å®šã‚’ç¢ºèªã—ã¦ã¿ã‚‹ã€‚ $ vi /etc/mysql/my.cnf bind-address = 127.0.0.1 bind-address = (æŽ¥ç¶šã—ãŸã„ãƒžã‚·ãƒ³ã®IPã‚¢ãƒ‰ãƒ¬ã‚¹)è¿½åŠ ã—ãŸã„æŽ¥ç¶šå…ˆã®IPã‚’æ›¸ã„ãŸã€Œbind-addressã€ã‚’è¿½åŠ
ockeghem 2011/03/22
mysql
ãƒªãƒ³ã‚¯
PDOã«ãŠã‘ã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®å±é™ºæ€§ã¨ãã®å›žé¿ã«ã¤ã„ã¦ã¾ã¨ã‚
PHPã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¢ã‚¯ã‚»ã‚¹ãƒ»ãƒ©ã‚¤ãƒ–ãƒ©ãƒªPDOã¯ã€DBæŽ¥ç¶šæ™‚ã®æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°æŒ‡å®šãŒã§ããªã„ãŸã‚ã€æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã®é¸æŠžã«ã‚ˆã£ã¦ã¯ã€ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã‚’ä½¿ã£ã¦ã„ã¦ã‚‚SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³è„†å¼±æ€§ãŒç™ºç”Ÿã—ã†ã‚‹ã¨ã„ã†å¾³ä¸¸æ°ã®ãƒ–ãƒã‚°å†…å®¹ã«å¯¾ã—ã€è˜è€…ãŒãã®å›žé¿æ–¹æ³•ã«ã¤ã„ã¦è©¦ã—ã€å ±å‘Šã—ã¦ã„ã¾ã™ã€‚
ockeghem 2010/07/02
ã¿ãªã•ã¾ã€ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸ

mysql

pdo

php
ãƒªãƒ³ã‚¯
mysqlã§skip-character-set-client-handshakeã¯ã‚‚ã†ä½¿ã‚ãªã„ã»ã†ãŒã„ã„ã¨æ€ã‚ã‚Œ | ã¸ã¼ã„æ—¥è¨˜
ãƒ›ãƒ¼ãƒ > mysql | perl > mysqlã§skip-character-set-client-handshakeã¯ã‚‚ã†ä½¿ã‚ãªã„ã»ã†ãŒã„ã„ã¨æ€ã‚ã‚Œ æ–°ã—ã„ å¤ã„ skip-character-set-client-handshake ã‚’ [mysqld] ã‚»ã‚¯ã‚·ãƒ§ãƒ³ã«è¿½è¨˜ã™ã‚‹ã¨ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãŒã©ã‚“ãªæ–‡å—ã‚³ãƒ¼ãƒ‰è¨å®šã‚’ã‚‚ã£ã¦ã„ã‚ˆã†ãŒå•ç”ç„¡ç”¨ã§ character_set_* ã‚’ (_system ã‚’ã®ãžã„ã¦) ã™ã¹ã¦åŒã˜å€¤ã«çµ±ä¸€ã—ã¦ãã‚Œã‚‹ http://d.hatena.ne.jp/a666666/20090826/1251270979 ãµãƒ¼ã‚€ã€‚ skip-character-set-client-handshakeã‚’è–¦ã‚ã‚‹æ–‡æ›¸ãŒãƒãƒƒãƒˆä¸Šã«ã¯ã‚„ãŸã‚‰è»¢ãŒã£ã¦ã‚‹ã‚“ã ã‘ã©ã€ã“ã‚Œã«ã¯å¤§ããªè½ã¨ã—ç©´ãŒã‚ã‚‹ã€‚ ãŸã—ã‹ã«è¡¨ç¤ºã•ã‚Œã‚‹character_set_*ã¯çµ±ä¸€ã•ã‚Œã‚‹ã‹ã‚‚ã—ã‚Œãªã„ãŒã“ã‚Œã¯ã‚ãã¾
ockeghem 2010/07/02
security

sql

mysql

charset
ãƒªãƒ³ã‚¯
MySQL :: MySQL 5.1 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« (ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒ˜ãƒ«ãƒ—) :: 7.4.1 æ–‡å—åˆ—æ¯”è¼ƒé–¢æ•°
ockeghem 2010/04/06
LIKE

sql

mysql

like
ãƒªãƒ³ã‚¯
ã¯ã¦ãªãƒ–ãƒã‚° | ç„¡æ–™ãƒ–ãƒã‚°ã‚’ä½œæˆã—ã‚ˆã†
ã‚ªãƒ¼ãƒ™ãƒ«ã‚¸ãƒ¼ãƒŒå®Ÿé£Ÿãƒ¬ãƒ é£Ÿã¹ç‰©ã®é¼»å¡©å¡©(æœªã ã«é€šã˜ã‚‹ã®ã‹ãª) ã‚ªãƒ¼ãƒ™ãƒ«ã‚¸ãƒ¼ãƒŒã¨ã„ã†ã‚«ãƒ¬ãƒ¼ã‚’ã”å˜çŸ¥ã ã‚ã†ã‹ éƒ½å†…ã«ã‚ã‚‹ãƒ‡ãƒªãƒãƒªãƒ¼å°‚é–€ã®ã‚«ãƒ¬ãƒ¼å±‹ã§ã€ ãƒã‚±å¼ãªã©ã§å¤§äººæ°—ã®æœ¬æ ¼æ¬§é¢¨ã‚«ãƒ¬ãƒ¼ãŒæ¥½ã—ã‚ã‚‹ã‚‰ã—ã„ ã„ã„ãªã€œ ã„ã„ãªã€œã‚ªãƒ–ã‚¶ã‚¤ãƒ¤ãƒ¼ éƒ½å†…ã®å¥´ã‚‰ã¯ã“ã‚“ãªè‰¯ã„ãƒ¢ãƒ³é£Ÿã£ã¦ã‚“ã®ã‹ è¨±ã›ããˆã‚ˆâ€¦â€¦â€¦
ockeghem 2010/03/16
php

pdo

mysql

charset
ãƒªãƒ³ã‚¯
MySQL Cheat Sheet - cheat-sheet.pdf (application/pdf ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆ)
ockeghem 2009/12/30
ã“ã‚Œã¯ã™ã”ã„

mysql
ãƒªãƒ³ã‚¯
è²·ã£ã¦ã¯ã„ã‘ãªã„æ›¸ç±ã€Œã‚¼ãƒã‹ã‚‰ã§ãã‚‹ PHP+MySQL Webã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ã€ - ã‚ˆãããŸblog
å–ã‚Šæ€¥ãŽä¸‹è¨˜ã¯amazonãƒ¬ãƒ“ãƒ¥ãƒ¼ã«æå‡ºã—ãŸå†…å®¹.å¾Œã«è£œè¶³ã‚’è¿½è¨˜ã™ã‚‹ã‹ã‚‚â€¦ çµè«–ã¨ã—ã¦ã¯ã€Œçµ¶å¯¾è²·ã£ã¦ã¯ã„ã‘ãªã„æœ¬ã€.ãŸã ã—åé¢æ•™å¸«çš„ã«è²·ã†ã®ã¯ãŠå‹§ã‚ã‹ã‚‚ã—ã‚Œãªã„ã§ã™ã.åŸºæœ¬çš„ãªå•é¡ŒãŒãŸãã•ã‚“ç››ã‚Šè¾¼ã¾ã‚Œã¦ã„ã¦é–“é•ã„æŽ¢ã—ã«ã¯ã†ã£ã¦ã¤ã‘ã§ã™. ãƒ»PHP 4ãƒ¬ãƒ™ãƒ«ã®è¨˜è¿°ã§ã®5å¹´ã¯æ˜”ã®å®Ÿè£… â‡’PEARã‚„ADOdbã™ã‚‰ä½¿ã£ã¦ã„ãªã„ç´ ã®MySQLé–¢æ•°ç¾¤.ã‚‚ã†ã›ã‚ã¦ä»Šæ™‚ãªã‚‰mysqliã‹PDOã§ã—ã‚‡. ãƒ»åŸºæº–ã«ãªã‚‹è¨å®šã‚’æ˜Žç¢ºã«ã—ã¦ã„ãªã„ãŸã‚ã‚ã‚„ãµã‚„ãªè¨˜è¿°ãŒã‚ã‚Šã¾ã™ â‡’æ›¸ç±ã‚ªãƒªã‚¸ãƒŠãƒ«ã®ã‚µãƒ³ãƒ—ãƒ«ã‚’ä¾‹é¡Œã«ã—ã¦ã„ã‚‹ã®ã«ã€ŒPHPã®è¨å®šã«ã‚ˆã£ã¦ç”»é¢é·ç§»ä¸Šã§ã€Ž\ã€ãŒå…¥ã‚‹å¯èƒ½æ€§ãŒã‚ã‚‹â€¦ã€ã‚’ã¯ã˜ã‚å‰ææ¡ä»¶ãŒã‚†ã‚‹ã,è§£èª¬ã‚‚å®Ÿè£…ã‚‚ã‚ã‚„ãµã‚„ã«ãªã£ã¦ã„ã‚‹. ãƒ»ãã‚‚ãã‚‚åŸºæœ¬çš„ãªã‚¦ã‚§ãƒ–ã‚„PHPãªã©ã®ç”¨èªžã®é–“é•ã„ã‚„åŸºç¤ŽçŸ¥è˜ãŒä¸ååˆ†ã§ã™ â‡’mbstringã‚’ã€Œ2ãƒã‚¤ãƒˆé–¢æ•°ã€ã£ã¦â€¦ã¨ã‹formè¦ç´ ã®methodå±žæ€§ã®æŒ‡å®šã«ã‚ˆã£ã¦é€ä¿¡å€¤ãŒ$_
ockeghem 2009/12/23
php

mysql

security
ãƒªãƒ³ã‚¯
å½å½å¤œé£Ÿæ—¥è¨˜: MySQLã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆå´ã‹ã‚‰ã®æ£ã—ã„æ–‡å—ã‚³ãƒ¼ãƒ‰ã®æŒ‡å®šæ–¹æ³• (2009-11-30 )
ã‚«ãƒ†ã‚´ãƒª: MySQL å…ˆæ—¥ã¾ã¨ã‚ãŸã‚ˆã†ã«MySQLã®æŽ¥ç¶šæ–‡å—ã‚»ãƒƒãƒˆã‚’è¨å®šã™ã‚‹æ–¹æ³•ã¯ä»¥ä¸‹ã®5é€šã‚Šã®æ–¹æ³•ãŒã‚ã‚‹ã€‚ ã‚°ãƒãƒ¼ãƒãƒ«ãªã‚ªãƒ—ã‚·ãƒ§ãƒ³ãƒ•ã‚¡ã‚¤ãƒ«ã§æŒ‡å®šã™ã‚‹ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç‹¬è‡ªã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãƒ•ã‚¡ã‚¤ãƒ«ã§æŒ‡å®šã™ã‚‹ mysql_options()ã§æ–‡å—ã‚»ãƒƒãƒˆã‚’ç›´æŽ¥æŒ‡å®šã™ã‚‹ mysql_set_character_set()ã§æŒ‡å®šã™ã‚‹ SET NAMESã§æŒ‡å®šã™ã‚‹ ã ãŒã€ã€ŒMySQL/Rubyã«ãŠã‘ã‚‹æ£ã—ã„ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°å¤‰æ›´æ–¹æ³• - ã—ã°ãã‚“ãƒŽãƒ¼ãƒˆã€ã«ã‚ˆã‚‹ã¨ã€mysql_options()ã®MYSQL_SET_CHARSET_NAMEã§ã¯ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆå´ã®çŠ¶æ…‹ã—ã‹å¤‰æ›´ã—ãªã„ã‚‰ã—ã„ã€‚mysql_set_character_set()ã¯mysql->charsetã‚’è¨å®šã—ã¤ã¤SET NAMESã—ã¦ã„ã‚‹ã ã‘ã€mysql_real_connect()ã«ã¯æŽ¥ç¶šæ–‡å—ã‚»ãƒƒãƒˆã‚’ã‚µãƒ¼ãƒã«é€ã‚‹æ©Ÿèƒ½ã¯ç„¡ã„ã¨ã„ã†ã“ã¨ã¯ã€æŽ¥ç¶š
ockeghem 2009/11/30
mysql

charcode
ãƒªãƒ³ã‚¯
å½å½å¤œé£Ÿæ—¥è¨˜: MySQLã®æŽ¥ç¶šæ–‡å—ã‚»ãƒƒãƒˆè¨å®šæ–¹æ³•ã¾ã¨ã‚ (2009-10-05 )
ã‚«ãƒ†ã‚´ãƒª: PHP MySQLã‚’æ£ã—ãä½¿ç”¨ã™ã‚‹ç‚ºã«ã¯ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆå´ã§æŽ¥ç¶šæ–‡å—ã‚»ãƒƒãƒˆã‚’æŒ‡å®šã™ã‚‹ã“ã¨ãŒå¿…è¦ã ã€‚ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãƒ©ã‚¤ãƒ–ãƒ©ãƒªã«å«ã¾ã‚Œã‚‹mysql_real_escape_string()ãªã©ã®é–¢æ•°ãŒã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã®æ–‡å—ã‚»ãƒƒãƒˆã®è¨å®šã‚’å‚ç…§ã—ã¦å‡¦ç†ã‚’è¡Œã†ã‹ã‚‰ã ã€‚æŽ¥ç¶šæ–‡å—ã‚»ãƒƒãƒˆã®æ—¢å®šã®è¨å®šã¯Latin1(ISO-8859-1)ã§ã‚ã‚‹ãŸã‚ã€æ£ã—ãæŒ‡å®šã•ã‚Œã¦ã„ãªã„å ´åˆã€å¤šãƒã‚¤ãƒˆæ–‡å—ã®2ãƒã‚¤ãƒˆç›®ä»¥é™ã«å«ã¾ã‚Œã‚‹ãƒ¡ã‚¿æ–‡å—ã¨åŒã˜ãƒã‚¤ãƒˆå€¤ãŒã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã•ã‚Œã¦ã—ã¾ã„ã€ä¸è¦ãªæ–‡å—ãŒæŒ¿å…¥ã•ã‚ŒãŸã‚ŠSQLã®æ–‡æ³•ã‚¨ãƒ©ãƒ¼ãªã©ã®ä¸å…·åˆãŒç™ºç”Ÿã™ã‚‹ã€‚ å¿…é ˆãªå‰²ã«ã©ã†ã‚„ã£ã¦è¨å®šã™ã‚‹ã®ã‹ãŒã¾ã¨ã¾ã£ã¦ã„ãªã„ã®ã§ã€ã²ã¨ã¾ãšã¾ã¨ã‚ã¦ã¿ã‚‹ã€‚ ã‚°ãƒãƒ¼ãƒãƒ«ãªã‚ªãƒ—ã‚·ãƒ§ãƒ³ãƒ•ã‚¡ã‚¤ãƒ«ã§æŒ‡å®šã™ã‚‹ MySQLã®è¨å®šã¯åŸºæœ¬çš„ã«ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‚ªãƒ—ã‚·ãƒ§ãƒ³çµŒç”±ã§è¡Œã†ãŒã€ãã‚Œã‚‰ã¨åŒã˜å†…å®¹ã‚’my.iniãªã©ã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰æŒ‡å®šã™ã‚‹ã“ã¨ã‚‚ã§ãã‚‹ã€‚ã‚°ãƒãƒ¼ãƒãƒ«ãªã‚ª
ockeghem 2009/11/29
sql

mysql

charcode
ãƒªãƒ³ã‚¯
CentOSã«Mysqlã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã®ãƒ¡ãƒ¢
[root@localhost ~]# vi /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 #aracter-set = utf8<span>←コメントアウト</span>+ default-character-set=utf8<span>←追&#211
ockeghem 2009/11/21
mysql

centos
ãƒªãƒ³ã‚¯
HowFriendFeedUsesMySqlToStoreSchemaLessData - FriendFeed ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹
HowFriendFeedUses MySqlToStoreSchemaLessData - FriendFeed ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ ç›®æ¬¡ ã“ã®è¨˜äº‹ã«ã¤ã„ã¦ FriendFeed? ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ èƒŒæ™¯ æ¦‚è¦³ è©³ç´° ä¸€è²«æ€§ã¨åŽŸåæ€§ æ€§èƒ½ FriendFeed? ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ ã“ã®è¨˜äº‹ã«ã¤ã„ã¦ "How FriendFeed? uses MySQL to store schema-less data" ã®æ—¥æœ¬èªžè¨³ã§ã™ http://bret.appspot.com/entry/how-friendfeed-uses-mysql CC 2.5 ã§ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã•ã‚Œã¦ã„ã¾ã™: http://creativecommons.org/
ockeghem 2009/11/15
mysql

friendfeed
ãƒªãƒ³ã‚¯
ã‚ã‚‹ã‚ã‚‹ãŠãƒãƒžã‚Šå¤§äº‹å…¸ - InnoDBãªã®ã«è¡Œãƒãƒƒã‚¯ã—ãªã„ã® - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
drop table if exists t; create table t ( iid int ,nid int ,bid binary(3) ,msg varchar(69) ,key (iid) ,key (bid) ) ENGINE=InnoDB; insert into t values (1,1,1,"ichi"),(2,2,2,"ni"),(3,3,3,"san") ,(4,4,4,"si"),(5,5,5,"go"),(6,6,6,"roku") ; ãªãƒ†ãƒ¼ãƒ–ãƒ«ã¨ãƒ‡ãƒ¼ã‚¿ã§ã€2ã¤ç«¯æœ«ã‚’ç”¨æ„ã—ã¦ update ã—ã‚ã„ã£ã“ã—ã¦ã¿ã¾ã™ã€‚ ã¾ãšã€ã“ã‚Œâ†“ã¯ä¸¡æ–¹ã¨ã‚‚updateãŒå®Œäº†ã—ã¦ã‚¹ã‚³ã£ã¨è¿”ã£ã¦ãã¾ã™ã€‚è¡Œãƒ¬ãƒ™ãƒ«ãƒãƒƒã‚¯++ begin; update t set msg = "t1" where iid = 1; ã¨ begin; update t set msg = "t2" wh
ockeghem 2009/11/07
ã€Žãƒ•ãƒ«ã‚¹ã‚ãƒ£ãƒ³ã«ãªã‚‹ç†ç”±ã¯ã€æ•°å€¤åž‹â†’binaryåž‹ã¸ã®åž‹å¤‰æ›ãŒã‹ã‹ã‚‹ã›ã„ã‹ãªã¨æ€ã„ã¾ã™ã€<ã‚„ã¯ã‚Šæš—é»™ã®åž‹å¤‰æ›ã®ãƒ¯ãƒŠã§ã™ã

mysql
ãƒªãƒ³ã‚¯
(ç‰¹ã«MyISAMã‚’ä½¿ã£ã¦ã„ãŸ)ã‚¦ã‚§ãƒ–å±‹ã•ã‚“ãŒInnoDBã‚’ä½¿ã†å ´åˆã®è¨å®šé …ç›® - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
InnoDBã¯MyISAMã¨æ¯”è¼ƒã—ã¦å®‰å…¨(OSã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚„é›»æºæ–ãŒç™ºç”Ÿã—ã¦ã‚‚ãƒ†ãƒ¼ãƒ–ãƒ«ãŒå£Šã‚Œãªã„)åˆ†ã€æ›¸ãè¾¼ã¿ãŒé…ã„ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å±‹ã•ã‚“ã‹ã‚‰ã™ã‚‹ã¨ã€ãã‚Œã¯å½“ç„¶ã®ã“ã¨ã§MyISAMãŒãŠã‹ã—ã„ã‚“ã ã€ã¨ã„ã†ã“ã¨ã«ãªã‚Šã€ã ã‹ã‚‰ãƒãƒƒãƒ†ãƒªãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ©Ÿèƒ½ã®ã¤ã„ãŸRAIDã‚«ãƒ¼ãƒ‰ã‚’ä½¿ã†ã‚“ã ã€ã¨ã„ã†è©±ã«ãªã‚‹ã€‚ã§ã‚‚ã€MyISAMã‚’ä½¿ã£ã¦ã„ã‚‹ã‚¦ã‚§ãƒ–å±‹ã•ã‚“ã®ç¾å ´ã§ã¯ã€å ´åˆã«ã‚ˆã£ã¦å¤šå°‘ãƒ‡ãƒ¼ã‚¿ãŒæ¶ˆãˆã¦ã‚‚ã‹ã¾ã‚ãªã„ã‹ã‚‰ã€å®‰ã„ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã§å¤§é‡ã®ã‚¢ã‚¯ã‚»ã‚¹ã‚’æŒããŸã„... ã£ã¦ä¹–é›¢ãŒã‚ã‚‹ã‚“ã˜ã‚ƒãªã„ã‹ãªãƒ¼ã¨æ€ã£ã¦ã‚‹ã€‚ ãã®ã‚ˆã†ãªå ´åˆã«ã¯ã€my.cnf ã® innodb_flush_log_at_trx_commit ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’èª¿æ•´ã™ã‚‹ã“ã¨ã§ã€MyISAMã«æ¯”è‚©ã™ã‚‹æ›¸ãè¾¼ã¿é€Ÿåº¦ã‚’å¾—ã‚‹ã“ã¨ãŒã§ãã‚‹(ãã®ã‹ã‚ã‚Šã€ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚„é›»æºæ–ã®å ´åˆã¯ã€è¨å®šã«ã‚ˆã£ã¦ç›´è¿‘ï¼‘ç§’ä»¥å†…ã®å¤‰æ›´ãŒå¤±ã‚ã‚Œã‚‹)ã€‚ ä»–ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚‚å«ã‚ã¦æ›¸ã„ã¦ãŠãã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼
ockeghem 2009/10/29
mysql

kazuho
ãƒªãƒ³ã‚¯
MySQL/Rubyçµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
2. è‡ªå·±ç´¹ä»‹ âœ“ ã¨ã¿ãŸ ã¾ã•ã²ã‚ âœ“ [email protected] âœ“ ID: tommy ã¨ã‹ tmtm ã¨ã‹ tmtms ã¨ã‹ âœ“ Rubyæ´ åæ•°å¹´ âœ“ MySQLæ´ åæ•°å¹´ 1/72 Powered by Rabbit 0.6.1
ockeghem 2009/10/29
å¾Œã§è¦‹ã‚‹

event

ruby

mysql
ãƒªãƒ³ã‚¯
MySQL/Rubyã«ãŠã‘ã‚‹æ£ã—ã„ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°å¤‰æ›´æ–¹æ³• - ã—ã°ãã‚“ãƒŽãƒ¼ãƒˆ
MySQLã®æ–‡å—åŒ–ã‘ã‚’ç›´ã—ãŸã„ï¼ ç™ºç«¯ã¯Sequelã‚’ä½¿ã£ã¦MySQLã®ãƒ‡ãƒ¼ã‚¿ã‚’æ“ä½œã™ã‚‹Rubyã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’æ›¸ã„ã¦ã„ãŸã¨ãã§ã—ãŸã€‚ UTF-8ã§ä¿å˜ã—ãŸã¯ãšã®æ–‡å—åˆ—ãŒã€å¦™ã«æ–‡å—åŒ–ã‘ã—ã¦ã„ã¾ã™ã€‚ mysqlã‚³ãƒžãƒ³ãƒ‰ã§ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã®ç¢ºèªã‚’ã—ã¦ã¿ã‚‹ã¨ã€ $ mysql -h host -u user -p database ...(ç•¥)... Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> \s -------------- mysql Ver 14.14 Distrib 5.1.30, for portbld-freebsd7.1 (i386) using 5.2 ...(ç•¥)... Server characterset: ujis Db characterset: utf8 Client char
ockeghem 2009/10/19
å‚è€ƒã«ãªã‚‹

mysql

æ–‡å—ã‚³ãƒ¼ãƒ‰

ruby
ãƒªãƒ³ã‚¯
1 2 3 4 æ¬¡ã®ãƒšãƒ¼ã‚¸