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

mysqlÎÞ·¨Æô¶¯

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


Ïà¹ØÎĵµ£º

MySQLѧϰ±Ê¼Ç£ºInnoDBºÍMyISAMµÄ²î±ð


InnoDB
ºÍMyISAM
ÊÇÔÚʹÓÃMySQL
×î³£ÓõÄÁ½¸ö±íÀàÐÍ£¬¸÷ÓÐÓÅȱµã£¬ÊÓ¾ßÌåÓ¦Óöø¶¨¡£»ù±¾µÄ²î±ðΪ£ºMyISAM
ÀàÐͲ»Ö§³ÖÊÂÎñ´¦ÀíµÈ¸ß¼¶´¦Àí£¬¶øInnoDB
ÀàÐÍÖ§³Ö¡£MyISAM
ÀàÐ͵ıíÇ¿µ÷µÄÊÇÐÔÄÜ£¬ÆäÖ´ÐÐÊý¶È±ÈInnoDB
ÀàÐ͸ü¿ì£¬µ«ÊDz»ÌṩÊÂÎñÖ§³Ö£¬¶øInnoDB
ÌṩÊÂÎñÖ§³ÖÒѾ­Íⲿ¼üµÈ¸ß¼¶Êý¾Ý¿â¹¦ÄÜ¡£
MyIASMÊÇIASM± ......

½â¾öÔ¶³ÌÁ¬½Ómysql´íÎó1130´úÂëµÄ·½·¨

http://hi.baidu.com/qk618/blog/item/f61e5830f2125d93a9018e0c.html
½â¾öÔ¶³ÌÁ¬½Ómysql´íÎó1130´úÂëµÄ·½·¨
½ñÌìÔÚÓÃÔ¶³ÌÁ¬½ÓMysql·þÎñÆ÷µÄÊý¾Ý¿â£¬²»¹ÜÔõôŪ¶¼ÊÇÁ¬½Ó²»µ½£¬´íÎó´úÂëÊÇ1130£¬ERROR 1130: Host 192.168.2.159 is not allowed to connect to this MySQL server
²ÂÏëÊÇÎÞ·¨¸øÔ¶³ÌÁ¬½ÓµÄÓû§È¨ÏÞÎÊÌâ¡£½á¹ ......

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

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

MySQL±í±ÀÀ£

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

MySQL 1067´íÎó½â¾ö·½·¨¼¯ºÏ

1
°²×°MYSQLºó¸ü¸ÄÁËROOTµÄÃÜÂëºóÓÃ
net startmysql
Æô¶¯Ê±ÎÒ¾ÍÓöµ½ÁËÕâÑùµÄÎÊÌ⣮ʹÓÃÒÔÏÂÃüÁîºó
c:\mysql\bin\mysqladmin-u root -p shutdown
ÔÙnet start mysql¾ÍûÓÐÕâ¸ö´íÎóÌáʾÁË!
*************
2
MySQLµÄ1067´íÎó
Q£ºÎÒµÄMysqlÅöµ½ÁË 1067 ´íÎó
´íÎóÐÅϢΪ£º
A system error has occurred. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ