Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : mysql

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';&nbs ......

½«ÈÕÖ¾ÎļþдÈëMySqLÖÐ

Ê×ÏȽ¨Ò»¸ö¹¤³Ì£¬×¼±¸ºÃÒ»¸ölog4jµÄjar°üºÍÁ¬½ÓMySqLµÄÇý¶¯°ü¡£ÅäÖÃÈçÏ£º
ÐÞ¸Älog4j.propertiesÎļþ£º
######## #´Ë¾äΪ¶¨ÒåÃûΪstdoutµÄÊä³ö¶ËÊÇÄÄÖÖÀàÐÍ£¬¿ÉÒÔÊÇ
#org.apache.log4j.ConsoleAppender£¨¿ØÖÆ̨£©£¬
#org.apache.log4j.FileAppender£¨Îļþ£©£¬
#org.apache.log4j.DailyRollingFileAppender£¨Ã¿Ìì²úÉúÒ»¸öÈÕÖ¾Îļþ£©£¬
#org.apache.log4j.RollingFileAppender£¨Îļþ´óСµ½´ïÖ¸¶¨³ß´çµÄʱºò²úÉúÒ»¸öеÄÎļþ£©
#org.apache.log4j.WriterAppender£¨½«ÈÕÖ¾ÐÅÏ¢ÒÔÁ÷¸ñʽ·¢Ë͵½ÈÎÒâÖ¸¶¨µÄµØ·½£©
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
#´Ë¾äΪ¶¨ÒåÃûΪstdoutµÄÊä³ö¶ËµÄlayoutÊÇÄÄÖÖÀàÐÍ£¬¿ÉÒÔÊÇ
#org.apache.log4j.HTMLLayout£¨ÒÔHTML±í¸ñÐÎʽ²¼¾Ö£©£¬
#org.apache.log4j.PatternLayout£¨¿ÉÒÔÁé»îµØÖ¸¶¨²¼¾Öģʽ£©£¬
#org.apache.log4j.SimpleLayout£¨°üº¬ÈÕÖ¾ÐÅÏ¢µÄ¼¶±ðºÍÐÅÏ¢×Ö·û´®£©£¬
#org.apache.log4j.TTCCLayout£¨°üº¬ÈÕÖ¾²úÉúµÄʱ¼ä¡¢Ï̡߳¢Àà±ðµÈµÈÐÅÏ¢£©
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
#Èç¹ûʹÓÃpattern²¼¾Ö¾ÍÒªÖ¸¶¨µÄ´òÓ¡ÐÅÏ¢µÄ¾ßÌå¸ñʽConversionPattern£¬´òÓ¡²ÎÊýÈçÏ£º
#%m Êä³ö´úÂ ......

Zend FrameWokÖе÷ÓÃmysqlµÄ´æ´¢¹ý³Ì

ÔÚZend FrameWorkÖе÷ÓÃmysqlµÄ´æ´¢¹ý³Ì·½·¨ÈçÏ£º
$db = Zend_Db::factory($sql_DbType,$sql_Config);
$connection=$db->getConnection();
Zend_Registry::set("db",$db);
Zend_Registry::set("connect",$connection);
µ÷Óô洢¹ý³ÌÈçÏ´úÂëËùʾ£º
$this->_db = Zend_Registry::get('db');
$connection=Zend_Registry::get("connect");
$connection->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY,true);
$prev_next_rs=$this->_db->query('call moretableSelect();')->fetchAll(); ......

½«ÈÕÖ¾ÎļþдÈëMySqLÖÐ

Ê×ÏȽ¨Ò»¸ö¹¤³Ì£¬×¼±¸ºÃlog4jµÄjar°üºÍMysqLµÄÇý¶¯°ü¡£
ÅäÖÃlog4j.propertiesÎļþ£º
    #´Ë¾äΪ¶¨ÒåÃûΪstdoutµÄÊä³ö¶ËÊÇÄÄÖÖÀàÐÍ£¬¿ÉÒÔÊÇ
#org.apache.log4j.ConsoleAppender£¨¿ØÖÆ̨£©£¬
#org.apache.log4j.FileAppender£¨Îļþ£©£¬
#org.apache.log4j.DailyRollingFileAppender£¨Ã¿Ìì²úÉúÒ»¸öÈÕÖ¾Îļþ£©£¬
#org.apache.log4j.RollingFileAppender£¨Îļþ´óСµ½´ïÖ¸¶¨³ß´çµÄʱºò²úÉúÒ»¸öеÄÎļþ£©
#org.apache.log4j.WriterAppender£¨½«ÈÕÖ¾ÐÅÏ¢ÒÔÁ÷¸ñʽ·¢Ë͵½ÈÎÒâÖ¸¶¨µÄµØ·½£©
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
#´Ë¾äΪ¶¨ÒåÃûΪstdoutµÄÊä³ö¶ËµÄlayoutÊÇÄÄÖÖÀàÐÍ£¬¿ÉÒÔÊÇ
#org.apache.log4j.HTMLLayout£¨ÒÔHTML±í¸ñÐÎʽ²¼¾Ö£©£¬
#org.apache.log4j.PatternLayout£¨¿ÉÒÔÁé»îµØÖ¸¶¨²¼¾Öģʽ£©£¬
#org.apache.log4j.SimpleLayout£¨°üº¬ÈÕÖ¾ÐÅÏ¢µÄ¼¶±ðºÍÐÅÏ¢×Ö·û´®£©£¬
#org.apache.log4j.TTCCLayout£¨°üº¬ÈÕÖ¾²úÉúµÄʱ¼ä¡¢Ï̡߳¢Àà±ðµÈµÈÐÅÏ¢£©
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
#Èç¹ûʹÓÃpattern²¼¾Ö¾ÍÒªÖ¸¶¨µÄ´òÓ¡ÐÅÏ¢µÄ¾ßÌå¸ñʽConversionPattern£¬´òÓ¡²ÎÊýÈçÏ£º
#%m Êä³ö´úÂëÖÐÖ¸¶¨µ ......

ruby gem mysql on cygwin

1£®    °²×°Cygwin
ÔËÐÐCygwinµÄ°²×°³ÌÐò¡£´ÓÎļû°üµÄµÄÁбíÖУ¬ÔÚDEVÀïÃ棬ȷ¶¨ÒªÑ¡Ôñ
• Ruby
• gcc
• subversion
    ÄãÐèҪʹÓÃgccÀ´½¨Á¢Cygwin°æ±¾µÄMySQL.
2. ÔÚwindowsÉÏÃæ°²×°MYSQL£º
    download MySQL 5.0 Windows Installer
3£®    °²×°MySQL generic source package²¢ÇÒ½¨Á¢Ëü
°ÑtarballÊͷŵ½Ò»¸öÁÙʱÎļþ¡£
./configure
make install
4£®    °²×°Ruby Gems
°´ÕÕÕý³£·½Ê½°²×°£¬ÏÂÔØDownload Gems ÊͷŲ¢°²×°¡£
5£®    °²×°Rails:
ÏÖÔÚÄãÒѾ­ÓÐGems£¬Äã¿ÉÒÔ°²×°Rails. Ö´ÐУº
gem insall rails –include-dependencies
6. °²×°mysql gem
    ÔËÐÐgem°²×°mysql¡£ µ±³öÏÖÑ¡Ôñʱºò£¬²»Òª°²×°mswin32,
Òª°²×°×îеÄUnix °æ±¾¡£
À©Õ¹µÄ°²×°Ö¸ÁÕâÀïûÓÐÈ«²¿·­Ò붼ÊÇ°²×°CygwinµÄÖ¸Á
µ«ÊÇÓÐÒ»¾ä»°ÒªÖصã˵£ºWindows isn’t the greatest environment for development.
Windows²¢²»ÊǺܺõĿª·¢»·¾³¡£
Thanks for http://wiki.rubyonrails.org/rails/pages/RailsonWindowsCygwin ......

ruby gem mysql on cygwin

1£®    °²×°Cygwin
ÔËÐÐCygwinµÄ°²×°³ÌÐò¡£´ÓÎļû°üµÄµÄÁбíÖУ¬ÔÚDEVÀïÃ棬ȷ¶¨ÒªÑ¡Ôñ
• Ruby
• gcc
• subversion
    ÄãÐèҪʹÓÃgccÀ´½¨Á¢Cygwin°æ±¾µÄMySQL.
2. ÔÚwindowsÉÏÃæ°²×°MYSQL£º
    download MySQL 5.0 Windows Installer
3£®    °²×°MySQL generic source package²¢ÇÒ½¨Á¢Ëü
°ÑtarballÊͷŵ½Ò»¸öÁÙʱÎļþ¡£
./configure
make install
4£®    °²×°Ruby Gems
°´ÕÕÕý³£·½Ê½°²×°£¬ÏÂÔØDownload Gems ÊͷŲ¢°²×°¡£
5£®    °²×°Rails:
ÏÖÔÚÄãÒѾ­ÓÐGems£¬Äã¿ÉÒÔ°²×°Rails. Ö´ÐУº
gem insall rails –include-dependencies
6. °²×°mysql gem
    ÔËÐÐgem°²×°mysql¡£ µ±³öÏÖÑ¡Ôñʱºò£¬²»Òª°²×°mswin32,
Òª°²×°×îеÄUnix °æ±¾¡£
À©Õ¹µÄ°²×°Ö¸ÁÕâÀïûÓÐÈ«²¿·­Ò붼ÊÇ°²×°CygwinµÄÖ¸Á
µ«ÊÇÓÐÒ»¾ä»°ÒªÖصã˵£ºWindows isn’t the greatest environment for development.
Windows²¢²»ÊǺܺõĿª·¢»·¾³¡£
Thanks for http://wiki.rubyonrails.org/rails/pages/RailsonWindowsCygwin ......

MySqlÊý¾Ý¿â³¹µ×ɾ³ý

жÔØMySQLÊý¾Ý¿â£º
ÏÈÍ£µôWINDOWSÀïµÄMySQL·þÎñ£»
ÓÃ360°²È«ÎÀÊ¿Ç¿ÐÐɾ³ýMySQLÊý¾Ý¿â
½Ó×ÅÔÚ×¢²á±íÀïÇå³ýMySQL·þÎñ£º
1¡¢HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL Ŀ¼ɾ³ý
2¡¢HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services\Eventlog\Application\MySQL Ŀ¼ɾ³ý
3¡¢HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\MySQL Ŀ¼ɾ³ý
×¢²á±íÖеÄControlSet001,ControlSet002,²»Ò»¶¨ÊÇ001ºÍ002,¿ÉÄÜÊÇControlSet005,006Ö®Àà,ɾ³ýµÄʱºò,¶¼É¾³ý¾Í¿ÉÒÔ
¼ì²éC:\WINDOWSĿ¼ÏÂÊÇ·ñÓÐmy.iniÎļþ,½«Æäɾ³ý(C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 6.0\)
ÊÖ¹¤É¾³ýMySQLµÄ°²×°Ä¿Â¼
4¡¢ÖØÆôÄãµÄµçÄÔ£¡ ......
×ܼǼÊý:2220; ×ÜÒ³Êý:370; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [16] [17] [18] [19] 20 [21] [22] [23] [24] [25]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ