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]