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

mysql:11828

From: SATOH Fumiyasu <SATOH Fumiyasu <fumiya@xxxxxxxxxx>>
Date: Fri, 29 Jul 2005 17:03:15 +0900
Subject: [mysql 11828] Re: ³°Éô¥¯¥é¥¤¥¢¥ó¥È¤«¤é¤ÎÀܳ

At Fri, 29 Jul 2005 12:29:30 +0900 (JST),
H M wrote:
> MySql 4.1.13 on Debian3.1 ¥½¡¼¥¹¤«¤é¤Î¥¤¥ó¥¹¥È¡¼¥ë
> 
> ¤È¤¤¤¦¾õ¶·¤Ç¡¢
> 192.168.0.100 MySql Server
> 192.168.0.5   ÁàºîÍÑüËö¡ÊWinXp Pro)
> ¤È¤·¤Þ¤¹¡£
> ¤«¤Í¤ä¤óMySqlAdmin¤òÍѤ¤¤ÆÁàºî¤·¤¿¤¤¤Î¤Ç¤¹¤¬¡¢
> ÀßÄê¤Ç¤Ä¤Þ¤Å¤¤¤Æ¤¤¤Þ¤¹¡£

ÀßÄê¤Î²¿¤Ë¤Ä¤Þ¤Å¤¤¤¿¤Î¤Ç¤·¤ç¤¦¤«?

> GRANT ALL PRIVILEGES ON *.* TO superadm@localhost
> IDENTIFIED BY 'admin' WITH GRANT OPTION;
> GRANT ALL PRIVILEGES ON *.* TO superadm@"%" IDENTIFIED BY
> 'admin' WITH GRANT OPTION;
> 
> ¤È¥æ¡¼¥¶¡¼¤òÀßÄꤷ¤Þ¤·¤¿¤¬¡¢Â¾¤Ë²¿¤«É¬ÍפǤ·¤ç¤¦¤«¡©

¤½¤Î¼ÁÌä¤À¤È¡Ö¤¢¤Ê¤¿¤¬É¬ÍפȤ¹¤ëÀßÄê¡×¤È¤·¤«
Åú¤¨¤é¤ì¤Ê¤¤¤è¤¦¤Ê¡Ä¡£

²¿¤¬¤·¤¿¤¯¤Æ (¤³¤ì¤Ï½ñ¤¤¤Æ¤¢¤ë¤¬)¡¢²¿¤¬¤Ç¤­¤Æ¡¢²¿¤¬ÌäÂê¤Ç¡¢
²¿¤¬¤ï¤«¤Ã¤Æ¤¤¤Æ¡¢²¿¤¬¤ï¤«¤é¤Ê¤¤¤Î¤Ç¤·¤ç¤¦¤«?

¡Ä

Ê̤ÎÊý¤È¤Î¤ä¤ê¤È¤ê¤Ç inetd ¤òÄä»ß¤·¤Æ¤¤¤Þ¤·¤¿¤¬¡¢
Ū³°¤ì¤Ç¤¹¡£¤´¼«¿È¤Ç inetd.conf ¤ò¿¨¤Ã¤Æ¤Ê¤¤¤Î¤Ç¤¢¤ì¤Ð¡¢
100% ´Ø·¸¤¢¤ê¤Þ¤»¤ó¡£

¡Öiptables ¤¬¤¦¤ó¤Ì¤ó¡×¤È¤¤¤Ã¤¿»ØŦ¤â¤¢¤ê¤Þ¤·¤¿¤¬¡¢
¸½ºß¤Î Debian ¤Ï iptables ¤Ë¤è¤ëÀ©¸Â¤Ï¥Ç¥Õ¥©¥ë¥È¤Ç
¤«¤«¤é¤Ê¤¤¤Î¤Ç¡¢¤´¼«¿È¤ÇÀßÄꤷ¤Æ¤¤¤Ê¤¤¸Â¤ê¤ÏÌäÂê¤Ê¤¤¤«¤È¡£

telnet ¤Ç MySQL ¥µ¡¼¥Ð¡¼¤ËÀܳ¤·¤¿¤È¤­¤ËÊÖ»ö¤¬Ê֤äƤ³¤Ê¤¤
¤È¤Î¤³¤È¤Ç¤¹¤¬¡¢Windows XP ¤«¤é¤Ç¤Ï¤Ê¤¯¡¢Debian
(MySQL ¥µ¡¼¥Ð¡¼¤¬²ÔƯ¤·¤Æ¤¤¤ë¥Û¥¹¥È¼«¿È) ¤«¤é¤À¤È¤É¤¦¤Ê¤ê¤Þ¤¹¤«?
  $ telnet localhost mysql
TCP Àܳ¤Ç¤Ê¤¤¥½¥±¥Ã¥È¤Ë¤è¤ëÀܳ¤À¤È¤É¤¦¤Ê¤ê¤Þ¤¹¤«?
  $ mysql -u superadm

¤½¤â¤½¤â¡¢mysqld ¥×¥í¥»¥¹¤Ï²ÔƯ¤·¤Æ¤¤¤Þ¤¹¤«?
  $ ps -ef |grep mysqld
¤Þ¤¿¡¢mysqld ¤Ï TCP ¤Î¥Ý¡¼¥È¤Ç listen ¤·¤Æ¤¤¤Þ¤¹¤«?
  # netstat -anp |grep 3306

-- 
-- Name: SATOH Fumiyasu  -- Home: http://www.sfo.jp (in Japanese only)
-- Mail: fumiya at net-thrust.com, samba.gr.jp, namazu.org or ...

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

     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]