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

¹ØÓÚMySQLµÄ1067´íÎó½â¾ö·½·¨

 ¡ù ¹ØÓÚ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 LAST_INSERT_ID()

LAST_INSERT_ID
×Ô¶¯·µ»Ø×îºóÒ»¸ö INSERT »ò UPDATE ²Ù×÷Ϊ AUTO_INCREMENT ÁÐÉèÖõĵÚÒ»¸ö·¢ÉúµÄÖµ. ²Î¿¼ÕâÀï
The ID that was generated is maintained in the server on a per-connection basis.
LAST_INSERT_IDÊÇ»ùÓÚµ¥¸öconnectionµÄ, ²»¿ÉÄܱ»ÆäËüµÄ¿Í»§¶ËÁ¬½Ó¸Ä±ä¡£
¿ÉÒÔÓà SELECT LAST_INSERT_ID(); ²éѯLAST ......

mysqlµÄCR_COMMANDS_OUT_OF_SYNC´íÎó

mysqlÖ´ÐÐsqlÓï¾äʱÓÐʱ»á³öÏÖCR_COMMANDS_OUT_OF_SYNC´íÎó£¨2014£©
ÌáʾÓïΪ
commands out of sync; you can't run this command now
ÍøÉ϶Դ˴íÎóµÄÃèÊöºÜÉÙ£¬¶øÇÒûÓиø³ö½â¾ö·½·¨¡£
ÆäʵÕâÊÇÒòΪÉÏÒ»¸ösqlÖ´Ðзµ»ØÁ˶à¸ö½á¹û¼¯£¬µ«Ã»Óаѽá¹û¶¼È¡³öÀ´£¬¾ÍÖ´ÐÐÁËеÄsqlÓï¾ä£¬¾Í»á²úÉúÕâ¸ö´íÎó¡£
Ó¦ÔÚsqlÓï¾äÖ´Ðкó ......

MySql ³£¼ûÒì³£


1016´íÎó£ºÎļþÎÞ·¨´ò¿ª£¬Ê¹Óúǫ́ÐÞ¸´»òÕßʹÓÃphpmyadmin½øÐÐÐÞ¸´¡£
1044´íÎó£ºÊý¾Ý¿âÓû§È¨ÏÞ²»×㣬ÇëÁªÏµ¿Õ¼äÉ̽â¾ö
1045´íÎó£ºÊý¾Ý¿â·þÎñÆ÷/Êý¾Ý¿âÓû§Ãû/Êý¾Ý¿âÃû/Êý¾Ý¿âÃÜÂë´íÎó£¬ÇëÁªÏµ¿Õ¼äÉ̼ì²éÕÊ»§¡£
1054´íÎ󣺳ÌÐòÎļþ¸úÊý¾Ý¿âÓгåÍ»£¬ÇëʹÓÃÕýÈ·µÄ³ÌÐòÎļþÉÏ´«ÉÏÈ¥¸²¸Ç¡£
1146´íÎó£ºÊý¾Ý±íȱʧ,Çë»Ö ......

MySQLÊý¾Ý¿â±¸·ÝºÍ»¹Ô­µÄ³£ÓÃÃüÁî

±¸·ÝMySQLÊý¾Ý¿âµÄÃüÁî
mysqldump -hhostname -uusername -ppassword databasename > backupfile.sql
±¸·ÝMySQLÊý¾Ý¿âΪ´øɾ³ý±íµÄ¸ñʽ
±¸·ÝMySQLÊý¾Ý¿âΪ´øɾ³ý±íµÄ¸ñʽ£¬Äܹ»Èøñ¸·Ý¸²¸ÇÒÑÓÐÊý¾Ý¿â¶ø²»ÐèÒªÊÖ¶¯É¾³ýÔ­ÓÐÊý¾Ý¿â¡£
mysqldump -–add-drop-table -uusername -ppassword databasename > backu ......

JDBCÁ¬½ÓÖ´ÐÐMySQL´æ´¢¹ý³Ì±¨¿ÕÖ¸Õë»òȨÏÞ´íÎó

 ×î½üʹÓÃrootÓû§±àдÁ˼¸¸ö´æ´¢¹ý³Ì£¬µ«ÊÇʹÓÃÆÕͨÓû§Í¨¹ýJDBCÁ¬½ÓÖ´ÐÐÈ´±¨´í£º
java.lang.NullPointerException......
»ò
java.sql.SQLException: User does not have access to metadata required to determine stored procedure parameter types. If rights can not be granted, configure connection with " ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ