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

mysqlÎÞ·¨Æô¶¯

ÓôÃÆ£¡CSDNµÄ²©¿Í±à¼­Æ÷ÓÒ±ßÔõôûÓÐÏÔʾ³öÀ´Íê°¡£¬¸ã¸öʲô“ÈçºÎʹÓÿͻ§¶Ëд²©¿Í”£¬º¦ÎÒÊäÈëµÄ×Ö¶¼±»ÄǸöÌáʾµ²×¡ÁË£¡
תÈëÕýÌ⣺
½ñÌìÒ»´óÔçÆðÀ´£¬´ò¿ªeclipseÆô¶¯tomcat£¬×òÍí»¹Õý³£ÔËÐеÄÒ»¸öÏîĿȴ±¨´í£¬¸øÎÒµÄÐÄÇéÕæÊÇÒ»¸ö´ò»÷ѽ~~ÐÂÄêµÚÒ»Ìì¾Í²»Ì«Ë³Àû£¡
¾­¹ý¼ì²é²ÅÖªµÀʹÓõÄÊý¾Ý¿âmysqlûÓÐÆô¶¯£¬Í¨¹ýWINXPµÄϵͳ·þÎñÀ´Æô¶¯mysql¸øÎÒÌø³öÒ»¸ö´íÎóÀ´£¬“´íÎó 1067: ½ø³ÌÒâÍâÖÕÖ¹”
¾­¹ýÍøÉÏËÑË÷£¬²ÅÖªµÀÊÇûÓÐmy.iniÕâ¸öÅäÖÃÎļþ£¬Ò²ÕÒµ½ÁËһЩ½â¾öÕâ¸öÎÊÌâµÄ°ì·¨£¬±ÈÈçн¨Ò»¸ömy.iniÎļþ£¬ÊäÈëһЩÅäÖÃÐÅÏ¢µÈ
ÕâÑù´¦Àí¹ýºóµ¹ÊÇ¿ÉÒÔÕý³£Æô¶¯mysql£¬²»¹ýÔÚÔËÐÐÏîÄ¿µÄʱºò£¬ÎÒ»¹ÊÇÓöµ½Á˲»¿ÉÖªµÄÊý¾Ý¿âÒì³£
×îºóÕÒµ½ÁËÒ»¸ö×î¼òµ¥°²È«²¢ÓÐЧµÄ·½·¨£º
ÔËÐÐmysql°²×°Ä¿Â¼ÏµÄbinĿ¼ÏµÄMySQLInstanceConfig.exeÖ´ÐÐÎļþ£¬Í¨¹ýËü¿ÉÒÔ´ÓÐÂÅäÖÃÒ»¸ömysqlʵÀý
һ·nextÏÂÈ¥£¬¾ÍÍòÊ´ó¼ªÁË£¬mysql³É¹¦Æô¶¯£¬ÏîĿҲÕý³£ÔËÐУ¡
ÁíÍ⣬ΪʲôÍùÌ컹Õý³£Æô¶¯µÄmysql½ñÌìÎÞ·¨Æô¶¯£¬ÅäÖÃÎļþΪºÎ»á¶ªÊ§£¬ÎÒ»¹²»ÖªµÀÔ­Òò£¬Ï£ÍûÓÐÖªµÀµÄÅóÓѸøÎÒ½âÊÍÒ»ÏÂ


Ïà¹ØÎĵµ£º

LinuxÏÂMySQL¿ª·ÅrootµÄÔ¶³Ì·ÃÎÊȨÏÞ

»·¾³£ºRHEL 5.3
°²×°ÁËMySQLÖ®ºó£¬MySQLµÄrootÓû§Ä¬ÈÏÊDz»¿ª·ÅÔ¶³Ì·ÃÎÊȨÏ޵ġ£ÎªÁË¿ª·ÅËü£¬Ö»ÐèÒªÁ½²½£º
ÓÃLinuxϵͳµÄrootÓû§µÇ¼ϵͳ£¬È»ºó£º
£¨1£©¿ª·Å3306¶Ë¿ÚµÄÔ¶³ÌÁ¬½ÓȨÏÞ£º
ÔÚ“-A RH-Firewall-1-INPUT -j REJECT --reject-with icmp-host-prohibited”ÕâÒ»ÐеÄÉÏÃæ£¨×¢Ò⣬һ¶¨ÊÇÉÏÃæ£©£¬Ìí¼ÓÈçÏ ......

MySQL´æ´¢ÒýÇæÑ¡ÔñInnoDB»¹ÊÇMyISAM

´æ´¢ÒýÇæÊÇʲô
MySQLÖеÄÊý¾ÝÓø÷ÖÖ²»Í¬µÄ¼¼Êõ´æ´¢ÔÚÎļþ(»òÕßÄÚ´æ)ÖС£ÕâЩ¼¼ÊõÖеÄÿһÖÖ¼¼Êõ¶¼Ê¹Óò»Í¬µÄ´æ´¢»úÖÆ¡¢Ë÷Òý¼¼ÇÉ¡¢Ëø¶¨Ë®Æ½²¢ÇÒ×îÖÕÌṩ¹ã·ºµÄ²»Í¬µÄ¹¦ÄܺÍÄÜÁ¦¡£Í¨¹ýÑ¡Ôñ²»Í¬µÄ¼¼Êõ£¬ÄãÄܹ»»ñµÃ¶îÍâµÄËÙ¶È»òÕß¹¦ÄÜ£¬´Ó¶ø¸ÄÉÆÄãµÄÓ¦ÓõÄÕûÌ幦ÄÜ¡£
ÀýÈ磬Èç¹ûÄãÔÚÑо¿´óÁ¿µÄÁÙʱÊý¾Ý£¬ÄãÒ²ÐíÐèҪʹÓÃÄÚ´æ ......

MySQL±í±ÀÀ£

Èç¹ûÔÚһЩ¸üÐÂÃüÁîÖ®ºó£¬mysqld×ÜÊǵ±µô£¬»òÕßÈç¹ûÄãÓöµ½±»ÆÆ»µµÄ±í£¬Äã¿ÉÒÔÓÃÏÂÃæµÄ²Ù×÷²âÊÔ¿´Õâ¸öȱÏÝÊÇ·ñÊÇ¿ÉÖØ¸´²úÉúµÄ£º
жµôMySQLÊØ»¤½ø³Ì£¨ÓÃmysqladmin shutdown£©¡£
¸ø¸Ã±í×ö±¸·Ý£¨·ÀÖ¹ÐÞ¸´²Ù×÷·´¶ø¸ã»µÕâÖֺܲ»¿ÉÄܳöÏÖµÄÇé¿ö£©¡£
Óà myisamchk -s database/*.MYI ¼ì²éËùÓÐµÄ±í£¬ÓÃmyisamchk -r database/ ......

mysql substring

µÃ°²Ææ×¨Âô£¨Ô˶¯ÐÝÏÐЬ£¬°åЬ£©ÌÔ±¦Ð¡µê£ºwww.bxbshoes.com
substring£º
Óï·¨
SUBSTRING ( expression , start , length )   
²ÎÊý
expression     
ÊÇ×Ö·û´®¡¢¶þ½øÖÆ×Ö·û´®¡¢text¡¢image¡¢Áлò°üº¬Áеıí´ïʽ¡£²»ÒªÊ¹Óðüº¬¾ÛºÏº¯ÊýµÄ ......

mysqlÓû§ÈÏ֤ЭÒé¸ü»»£¨mysqlʹÓÃÎÊÌâ)

°²×°ºÃmysqlºó£¬ÔÚʹÓÃmysqʱ£¬³öÏÖÁËÈçÏÂÎÊÌâ.
java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:327)
at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:261)
at org.gjt.mm.mysql.jdbc2 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ