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

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.
System error 1067 has occurred.
The process terminated unexpectedly.
A£ºÔÚÎҵĻúÉϵĽâ¾ö°ì·¨ÊÇ£º
ÐÞ¸Ä%windir%\my.ini£¬Ôö¼Ó
[mysqld]
#ÉèÖÃbasedirÖ¸ÏòmysqlµÄ°²×°Â·¾¶
basedir=D:\Program\Tools\mysql
datadir=D:\Program\Tools\mysql\data
*************
3
ÒѾ­ÅªºÃÁË!!!
ºÃÏñÊÇÕâÑù……
mysql_install_db½Å±¾Ö»ÊÇÔÚ³õ´Î°²×°Ê±²ÅÐèÒªÔËÐÐÒ»´Î,Ö®ºó¾Í²»ÓÃÔÙÔËÐÐÁË,²»ÖªµÀÊDz»ÊÇÕâô»ØÊÂ.ÎÒ°Ñmysql.server¿½±´ÖÁ/etc/rc.d/init.d/ÖÐ,ÔËÐÐchkconfig mysql.server,ÖÁ´Ëmysql·þÎñÆ÷ÿ´Î¿ª»ú×Ô¶¯Æô¶¯,Ö»ÒªÉèÖúÃPATH,ÔÚÃüÁîÐÐÉÏÊäÈëmysql¾ÍÒ»Çи㶨!
¿´À´ÃþË÷µÄ¹ý³ÌʵÔÚÊÇÍ´¿à°¡,ÕâÒѾ­ÕÛÄ¥ÎҺü¸ÌìÁË……
*************
4
ÎÊ£ºÎÒµÄMysqlÅöµ½ÁË 1067 ´íÎó
´íÎóÐÅϢΪ£º
A system error has occurred.
System error 1067 has occurred.
The process terminated unexpectedly.
´ð£º
½â¾ö°ì·¨£º
1.¼ì²éÄãµÄMysqlĿ¼ÓÐûÓиøÏµÍ³µÄSystemÓû§È¨ÏÞ¡£
2.ɾ³ýµôÄãµÄ %WINDOWS%/my.ini Îļþ¡£
3.¼ì²éÄãµÄ c:/my.cnf ÎļþÅäÖÃÊÇ·ñÕýÈ·¡£
*************
5
¡¾¡î¡î¡î MySql¸ÅҪ˵Ã÷ ¡î¡î¡î¡¿
MySqlµÄĬÈϰ²×°Ä¿Â¼ÊÇc:mysql£¬°²×°½áÊøºóûÓÐÈκÎÌáʾÐÅϢ˵°²×°½áÊø£¬ÇëµãFinish°´Å¥Ö®ÀàµÄ»°£¬Ö±½Ó¾ÍÍ˳öÁË¡£Èç¹ûÐèÒª°²×°µ½ÆäËûĿ¼£¬½¨ÒéÏȰ²×°µ½c:mysql£¬È»ºóÔÙÕû¸öĿ¼moveµ½×Ô¼ºÏ£ÍûµÄµØ·½£¬ÀýÈçÒÆ¶¯µ½d:mysql Ö®ºó£¬ÐèÒª±à¼­ d:mysqlmy-example.cnf £¨*.cnfµÄÎļþÔÚWindows 2000Öлᱻע²á³ÉΪ SpeedDialÎļþ£¬ÔÚ×ÊÔ´¹ÜÀíÆ÷ÖÐÎÞ·¨²Ù×÷£¬ÒªÓÃÃüÁîÐÐÀ´Æô¶¯notepad±à¼­£¬ÀýÈçÔËÐÐnotepadd:mysqlmy-example.cnf £¬µ«ÊÇÕâ¸öÎļþÊÇUNIXϵͳϵÄÎı¾Îļþ¸ñʽ£¬ÔÚnotepadÖв»ÄÜÕýÈ·»»ÐУ¬¿ÉÒÔÓÃwrite´ò¿ª±à¼­£¬
»òÕßÓÃwrite´ò¿ªºó±£´æÒ»´Î£¬ÔÙÓÃnotepad¾Í¿ÉÒԱ༭ÁË¡££©ÕÒµ½basedirÒ»ÐУ¬È¥µôÇ°ÃæµÄ“#”ºÅ×¢ÊÍ£¬½«ºóÃæµÄ·¾¶¸ÄÎªÒÆ¶¯ºóµÄĿ¼£¨Ä¿Â¼·Ö¸ô·ûÒªÓÃбÏß¶ø²»ÊÇ·´Ð±Ïߣ©£¬È»ºóÁí´æÎª£ºc:my.cnf
Ó÷þÎñ·½Ê½Æô¶¯µÄMySqlÈç¹ûÓà net


Ïà¹ØÎĵµ£º

mysql³£¼û´íÎóÌáʾ¼°½â¾ö·½·¨

130 £ºÎļþ¸ñʽ²»ÕýÈ·¡££¨»¹²»ÊǺÜÇå³þ´íÎóµÄ×´¿ö£©
145  £ºÎļþÎÞ·¨´ò¿ª¡£
1005£º´´½¨±íʧ°Ü¡£
1006£º´´½¨Êý¾Ý¿âʧ°Ü¡£
1007£ºÊý¾Ý¿âÒÑ´æÔÚ£¬´´½¨Êý¾Ý¿âʧ°Ü¡£
1008£ºÊý¾Ý¿â²»´æÔÚ£¬É¾³ýÊý¾Ý¿âʧ°Ü¡£
1009£º²»ÄÜɾ³ýÊý¾Ý¿âÎļþµ¼ÖÂɾ³ýÊý¾Ý¿âʧ°Ü¡£
1010£º²»ÄÜɾ³ýÊý¾ÝĿ¼µ¼ÖÂɾ³ýÊý¾Ý¿âʧ°Ü¡£
1011£ºÉ ......

linuxÏ mysql Íü¼ÇrootÓû§ÃÜÂë½â¾ö°ì·¨

linuxÏÂÍü¼ÇÁËmysqlµÄrootÓû§ÃÜÂë½â¾ö°ì·¨£º
¡¡¡¡Ò»¡¢ÒÔϵͳµÄrootÓû§£¨Ê²Ã´£¬ÄãµÄϵͳµÄrootÓû§ÃÜÂëÒ²ÍüÁË¡£ÄÇÖ»ºÃ¿´ÎÒÁíÍâһƪlinuxÏÂÍü¼ÇrootÓû§µÄ½â¾ö°ì·¨ÁËÏȽâ¾öÕâ¸öÎÊÌ⣩µÇ½ϵͳ£¬½øÈëÖÕ¶Ë
¡¡¡¡[root@localhost /]#
¡¡¡¡¶þ¡¢É±µômysql½ø³Ì
¡¡¡¡·½·¨1¡¢[root@localhost /]#killall mysqld
¡¡¡¡·½·¨2¡ ......

mysqlÐÞ¸ÄÃÜÂë(°üÀ¨ÃÜÂëÍü¼ÇµÄÇé¿ö)

ÐÞ¸ÄrootÃÜÂëµÄʱºò°´ÕÕÍøÉϵÄ˵µÄ¾ÓȻɵɵµÄÖ´ÐÐÁËupdate user set password="asdf" where user="root"£»Ö´ÐÐÖ®ºó·¢ÏÖÃÜÂë´íÁË£¬½øÈ¥²»ÁË£¬ÓÚÊÇÕÛÌÚÁ˰ëÌ죬·¢ÏÖmysqlµÄÃÜÂëÊǼÓÃܵIJ»ÊÇÃ÷ÎÄ´æ´¢µÄ£¬ËùÒԸĵÄʱºòÐèÒªÕâÑùset password=password("asdf")¡£´íÎóÒѾ­·¢ÉúÁË£¬ÓÚÊǾͰ´ÕÕÏÂÃæµÄ· ......

mysql Ëæ»ú»ñÈ¡¼Ç¼ order by rand ÓÅ»¯

Èç¹ûÒªËæ»ú»ñÈ¡¼Ç¼Êý£¬ÔÚmysqlÀï×î¼òµ¥µÄ·½·¨¿Ï¶¨ÊÇorder
by
rand
()ÁË£¬µ«ÊÇÕâÖÖ·½·¨Ö»ÄÜÔÚ±í¼Ç¼¼«ÉÙµÄÇé¿öϲÅÄÜʹÓá£Ö÷ÒªÊÇÒòΪorder
by
rand
()µ¼ÖÂÁËusing filesort.Õâ¸öʱºò²éѯÀàÐÍ»á±ä³Éall£¬Ë÷Òý»áʧЧ¡£Ö»Ðè¼òµ¥µÄ±äͨÏ£¬Íê³É¿ÉÒÔ×öµ½Í¬ÑùµÄЧ¹û¡£
¸ù¾Ý¼Ç¼µÄÀàÐÍ£¬·ÖÀàÁ¬ÐøºÍ·ÇÁ¬ÐøÁ½ÖÖ¡£
Á¬ÐøÖ ......

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

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