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

PBÈçºÎÒþ²Øµ¥»úMYSQLÆô¶¯ºóÄǸöcmd´°¿Ú£¿

    ÎÒÓÃMYSQLµ¥»ú°æ£¬Ð´Á˸öBAT´ò¿ªÒ»¸öCMD´°¿Ú È»ºóÆô¶¯ mysqld --console ÕâÑùÆô¶¯µÄ»° ´ò¿ªµÄÕâ¸öCMD´°¿ÚÄܲ»ÄÜÏë°ì·¨Òþ²Øµô »òÕß°ÑËû×îС»¯µ½ÈÎÎñÀ¸È¥¡£¡£¡£

    ÐÖµÜÃǸø¸öÏë·¨£¿
×ö³É·þÎñ£¡

(*^__^*) ÎûÎû¡­¡­  ÓÐÏà¹ØµÄÌû×Óô Õ¦×ö³É·þÎñ°¡£¿

¶¥~~~~~~~~~~~~~~~~~


д¸ö³ÌÐòÔËÐÐÖ¸Á¿ÉÒÔʵÏÖÒþ²Ø¡£

ÇëÎÊ  c:\mysql1\bin\mysqld --console  ºÍ  c:\mysql1\bin\mysqld ÓÐÊ²Ã´Çø±ðÄØ

ÎÒBATÀï ÓõÄÊÇÇ°ÃæÕâ¾ä ¿ÉÒÔÕý³£Æô¶¯ MYSQL  ºóÃæÕâ¾ä¾Í²»ÐР Õâ¸öconsole±ØÐë´ø×Å£¿

c:\mysql1\bin\mysqld ΪʲôÕâÑùÆð²»À´¿âѽ¡£¡£¡£¡£¡£¡£¡£

×¢²á³Éϵͳ·þÎñ ÊÔÑé³É¹¦ÁË µ«ÊÇÒªÏÈ removeһϠ·ÀÖ¹¿Í»§»úÆ÷ÉÏÒѾ­ÓÐmysql·þÎñÁË ÎÒ¾õµÃÕâÑùÒþ²ØµÄÎÊÌâºÜÉî°¡£¡£¡

cmd³ÌÐò¿ÉÒÔ×ö·þÎñ£¬ÎÒд¹ýÒ»¸öjavaµÄ£¬Ô­À´ÓõÄcmd£¬ºóÀ´Ò²×ö³É·þÎñÁË

ÎÒ֮ǰÊÇÏÈ net stop mysql È»ºóÆô¶¯×Ô¼ºµÄ¿â Í˳öʱ net start ÔÙ°ÑÔ­À´µÄϵͳ·þÎñÆô¶¯ÆðÀ´ £¬µ«ÊÇÓиöÎÊÌâ¾ÍÊÇ Ö»ÄÜÓÃc:\mysql1\bin\mysqld --console À´Æô¶¯£¬Õâ¸öconsole²ÎÊý²»¼Ó ¾ÍÆô¶¯²»ÁË£¬´ø×Åconsole°É£¬ÄǸöCMD´°¿Ú¾Í¿¨ÄÇÁË ²»ÄÜ¹Ø ºÜ·³ÈË£¬ Ϊʲô²»´øÕâ¸ö²ÎÊýÆð²»À´ÄØ £¿Õâ¸öÊÇÔõô»ØÊÂ
  Èç¹û°Ñ×Ô¼ºµÄMYSQLÒ²×ö³É·þÎñ ¿ÉÒÔÈÆ¹ý»úÆ÷ÉÏÒÑÓеÄMYSQL·þÎñ ½¨Á¢ÊôÓÚ×Ô¼ºµÄÒ»¸ö·þÎñô¡£¡£±ÈÈç net start mysql_1 ÕâÑù¿ÉÐÐô£¿



End_rbody_60094265//-->
¸Ã»Ø¸´ÓÚ2009-09-27 08:25:15±»°æÖ÷ɾ³ý



¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP








jjoulejcc
(񎙡)

µÈ¡¡¼¶£º



#11Â¥ µÃ·


Ïà¹ØÎÊ´ð£º

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. 
¿ ......

mysqlÄ£ºý²éѯÈçºÎ²éѯÁ½¸ö¹Ø¼ü×Ö

ÎÒÓõÄlikeÄ£ºý²éѯ£¬±ÈÈçmysqlµÄnameÖÐÓС°csdnÂÛ̳ϵͳ¡±Õ⼸¸ö×Ö£¬ÈçºÎÔÚ <input>Öвéѯ¡°csdn ϵͳ¡±Ò²ÄܳöÀ´Õâ¸ö¡°csdnÂÛ̳ϵͳ¡±£¬ÎÒÏÖÔÚÊDz顰csdn¡±»òÕß¡°ÏµÍ³¡±¶¼¿ÉÒÔ¡£Ð»Ð»¸÷λÁË£¡²»ÖªµÀÎÒÕâô±í´ï ......

Çë½ÌÒ»¸ömysqlÁ©±íÁ¬½ÓµÄÎÊÌâ

ÓÐÒ»ÌõsqlÓï¾ä select a.name ,b.name from tableA a,tableB b where a.id = b.id and ¡£¡£¡££¨ÆäËû¹ýÂËÌõ¼þ£©
ÆäÖÐa.id ΪtableAÖ÷¼ü ÓÐΨһÐÔË÷Òý Êý¾ÝÁ¿²Å1ǧ¶à
b.id ΪÈÕÖ¾±ítableB µÄÍâ¼ü £¬ÂýÈ¥Ìõ¼þµÄ²Å ......

Çë½Ìmysql innodbÊý¾ÝÎļþ´óС³¬¹ýϵͳÏÞÖÆµÄÎÊÌâ

ÓÉÓÚÒÔǰûÓÐinnodbµÄÓ¦Óþ­Ñ飬ÔÚÅäÖÃinnodbµÄinnodb_data_file_pathÑ¡ÏîʱÓõÄÊÇĬÈÏÅäÖã¨ibdata1:10M:autoexte
nd£© ,½ñÌì·¢ÏÖ´ËÊý¾Ý¿âÔÚͬ²½Ö÷Êý¾Ý¿âÊý¾Ýʱ£¨´ËinnodbÊÇ×÷Ϊһ̨myisam dbµÄÀ䱸»úÆ÷£©£¬ibda ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ