[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

mysql:11834

From: tateyan <tateyan <tateyan@xxxxxxxxxx>>
Date: Sat, 30 Jul 2005 22:59:38 +0900
Subject: [mysql 11834] Re: Ä´ºº·ë²Ì

¤¿¤Æ¤ä¤ó¤Ã¤¹

iptables ¤ÇÀܳµñÈݤ·¤Æ¤ë¤Ã¤Æ¤³¤È¤Ï¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡©
(¾ì¹ç¤Ë¤è¤Ã¤Æ¤Ïipchains¤«...)

telnet ¤Ç¥µ¡¼¥Ð¾å¤Î¡¡3306 ¤Ë¤Ä¤Ê¤²¤ì¤Ê¤¤¤È¤¤¤¦¤³¤È¤À¤È...

iptables -L -n 
¤Ç¥Á¥§¥Ã¥¯¤·¤Æ¤ß¤ë¤È¤«É¬Íפ«¤â¤·¤ì¤Þ¤»¤ó

»ä¤Î¾ì¹ç¤À¤Ã¤¿¤é¡¡¥µ¡¼¥Ð¦¤Ç¡¡tcpdump¤ò»È¤Ã¤Æ¥Ñ¥±¥Ã¥È¤¬Èô¤ó¤Ç¤­¤Æ¤ë¤«
¤ò¥Á¥§¥Ã¥¯¤·¤¿¤ê¤·¤Þ¤¹

tcpdump port 3306
¤Ç¡¡ack ¤¬Èô¤Ð¤Ê¤¤¾ì¹ç¥Ñ¥±¥Ã¥È¤¬¤É¤³¤«¤Ç¥Õ¥£¥ë¥¿¤µ¤ì¤Æ¤ë¤È¤«Ê¬¤«¤ê¤Þ¤¹


H M¤µ¤ó¤Î
Âê̾¡Ö[mysql 11833] Ä´ºº·ë²Ì¡×¤Î¥á¡¼¥ë¤«¤é¤Î°úÍѤǤ¹
> > /etc/my.cnf
> > bind-address = 127.0.0.1
> > ¡¡¢¬
> > ¤³¤Î¹Ô¤ò¥³¥á¥ó¥È¥¢¥¦¥È¤·¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£
> ¤³¤Îµ­½Ò¤¬¤¢¤ê¤Þ¤»¤ó^^;
> 
> #netstat -anp |grep 3306
> tcp   0  0 0.0.0.0:3306   0.0.0.0:*  LISTEN 7174/mysqld
> tcp   0  0 127.0.0.1:3306 127.0.0.1:1027   TIME_WAIT  -
> ¤Ç¤·¤¿¡£
> 
> ¤½¤ì¤Ë¤·¤Æ¤â¡¢PHPMyAdmin¤Ç¤â¤Á¤ã¤ó¤ÈÆ°¤¤¤Æ¤¤¤ë¤³¤È¤Ï³Îǧ
> ½ÐÍè¤Æ¤¤¤ë¤Î¤Ç¤¹¤¬¤Í¡¦¡¦¡¦
PHPMyAdmin ¤Ï¡¡ÀßÄê¤Ë¤è¤Ã¤Æ¤Ï¡¡unix domain socket »È¤¤¤Þ¤¹
¡Ê¥í¡¼¥«¥ë¤«¤é¤È¤¤¤¦¤³¤È¤À¤Èunix domain socket¤ÎÊý¤¬°ÂÁ´¤Ê¥±¡¼¥¹¤â¤¢¤ê¤Þ
¤¹¤·¤Í¡Ë


--
  ×Ä×Äк        ¤¿¤Æ¤ä¤ó¤Ã¤¹
 d¢¢/¢¢-£â      <tateyan@xxxxxxxxxx>
 ¡³"¡¼"Ш

Key fingerprint = 5D56 8EA3 B9FE A721 4866  FB4A 0041 672C 08DD C33A



[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

     11815 2005-07-29 12:29 [H M <hassy_94@xxxxxx] ³°Éô¥¯¥é¥¤¥¢¥ó¥È¤«¤é¤ÎÀܳ              
     11816 2005-07-29 14:17 ¨²["T.Sasaki" <papasan2]                                       
     11818 2005-07-29 15:41 ¨­¨±[H M <hassy_94@xxxxxx]                                     
     11820 2005-07-29 16:15 ¨­¡¡¨²["T.Sasaki" <papasan2]                                   
     11822 2005-07-29 16:29 ¨­¡¡¨­¨²[H M <hassy_94@xxxxxx]                                 
     11824 2005-07-29 16:37 ¨­¡¡¨­¨­¨±["T.Sasaki" <papasan2]                               
     11825 2005-07-29 16:35 ¨­¡¡¨­¨±[±óÆ£ ½Ó͵ <endo@xxxx]                                 
     11826 2005-07-29 16:39 ¨­¡¡¨­¡¡¨²[±óÆ£ ½Ó͵ <endo@xxxx]                               
     11827 2005-07-29 16:54 ¨­¡¡¨­¡¡¨±["T.Sasaki" <papasan2]                               
     11830 2005-07-29 18:19 ¨­¡¡¨­¡¡¡¡¨±[±óÆ£ ½Ó͵ <endo@xxxx]                             
     11831 2005-07-29 19:00 ¨­¡¡¨­¡¡¡¡¡¡¨±["T.Sasaki" <papasan2]                           
     11821 2005-07-29 16:17 ¨­¡¡¨±[toki <toki@xxxxxxxxx]                                   
     11823 2005-07-29 16:32 ¨­¡¡¡¡¨±["T.Sasaki" <papasan2]                                 
     11817 2005-07-29 14:25 ¨²[SUGIMURA Takashi ¿ùÂ]                                       
     11819 2005-07-29 16:06 ¨­¨±[H M <hassy_94@xxxxxx]                                     
     11828 2005-07-29 17:03 ¨²[SATOH Fumiyasu <fumi]                                       
     11829 2005-07-29 18:16 ¨­¨±[±óÆ£ ½Ó͵ <endo@xxxx]                                     
     11832 2005-07-29 23:00 ¨±[seidai hirota <seida]                                       
     11833 2005-07-30 15:25 ¡¡¨±[H M <hassy_94@xxxxxx] Ä´ºº·ë²Ì                            
->   11834 2005-07-30 22:59 ¡¡¡¡¨²[tateyan <tateyan@xxx]                                   
     11835 2005-07-31 14:56 ¡¡¡¡¨±["T.Sasaki" <papasan2]                                   
     11836 2005-07-31 20:03 ¡¡¡¡¡¡¨±[H M <hassy_94@xxxxxx]                                 
     11837 2005-07-31 20:09 ¡¡¡¡¡¡¡¡¨±[Kazuhiro Yoshida <mo]                               
     11838 2005-07-31 20:16 ¡¡¡¡¡¡¡¡¡¡¨²[H M <hassy_94@xxxxxx]                             
     11840 2005-07-31 20:47 ¡¡¡¡¡¡¡¡¡¡¨­¨²["T.Sasaki" <papasan2]                           
     11841 2005-07-31 22:15 ¡¡¡¡¡¡¡¡¡¡¨­¨±[iida_yuichi <y_iida@]                           
     11842 2005-08-01 09:05 ¡¡¡¡¡¡¡¡¡¡¨­¡¡¨²["T.Sasaki" <papasan2]                         
     11853 2005-08-01 20:55 ¡¡¡¡¡¡¡¡¡¡¨­¡¡¨­¨²[iida_yuichi <y_iida@]                       
     11854 2005-08-01 21:50 ¡¡¡¡¡¡¡¡¡¡¨­¡¡¨­¨±[H M <hassy_94@xxxxxx]                       
     11858 2005-08-02 12:33 ¡¡¡¡¡¡¡¡¡¡¨­¡¡¨­¡¡¨±["T.Sasaki" <papasan2]                     
     11865 2005-08-02 22:55 ¡¡¡¡¡¡¡¡¡¡¨­¡¡¨­¡¡¡¡¨±[H M <hassy_94@xxxxxx]                   
     11868 2005-08-03 09:47 ¡¡¡¡¡¡¡¡¡¡¨­¡¡¨­¡¡¡¡¡¡¨±[toki <toki@xxxxxxxxx]                 
     11870 2005-08-03 10:03 ¡¡¡¡¡¡¡¡¡¡¨­¡¡¨­¡¡¡¡¡¡¡¡¨±["T.Sasaki" <papasan2]               
     11872 2005-08-03 10:51 ¡¡¡¡¡¡¡¡¡¡¨­¡¡¨­¡¡¡¡¡¡¡¡¡¡¨±[<numata@xxxxxxxxxx> ]             
     11873 2005-08-03 11:05 ¡¡¡¡¡¡¡¡¡¡¨­¡¡¨­¡¡¡¡¡¡¡¡¡¡¡¡¨±["T.Sasaki" <papasan2]           
     11874 2005-08-03 15:00 ¡¡¡¡¡¡¡¡¡¡¨­¡¡¨­¡¡¡¡¡¡¡¡¡¡¡¡¡¡¨±["T.Sasaki" <papasan2]         
     11875 2005-08-03 16:10 ¡¡¡¡¡¡¡¡¡¡¨­¡¡¨­¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¨²["T.Sasaki" <papasan2]       
     11877 2005-08-03 18:16 ¡¡¡¡¡¡¡¡¡¡¨­¡¡¨­¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¨­¨±[H M <hassy_94@xxxxxx]     
     11876 2005-08-03 17:00 ¡¡¡¡¡¡¡¡¡¡¨­¡¡¨­¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¨±["Kenichiro Fuji" <k_]       
     11843 2005-08-01 15:48 ¡¡¡¡¡¡¡¡¡¡¨­¡¡¨±["Tetsuya Hirotsu" <h] DELETE FROM table_name;  ¤Ç AUTO_INCREMENT  Ãͤ¬½é´ü²½¤µ¤ì¤Ê¤¤
     11844 2005-08-01 15:58 ¡¡¡¡¡¡¡¡¡¡¨­¡¡¡¡¨²["Tetsuya Hirotsu" <h]                       
     11845 2005-08-01 16:24 ¡¡¡¡¡¡¡¡¡¡¨­¡¡¡¡¨²[KIshii <kn-ishi@xxxx]                       
     11846 2005-08-01 16:28 ¡¡¡¡¡¡¡¡¡¡¨­¡¡¡¡¨±["T.Sasaki" <papasan2]                       
     11856 2005-08-02 11:19 ¡¡¡¡¡¡¡¡¡¡¨­¡¡¡¡¡¡¨±["Tetsuya Hirotsu" <h]                     
     11839 2005-07-31 20:27 ¡¡¡¡¡¡¡¡¡¡¨±[H M <hassy_94@xxxxxx]