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×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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.
¿ ......
ÎÒÓõÄlikeÄ£ºý²éѯ£¬±ÈÈçmysqlµÄnameÖÐÓС°csdnÂÛ̳ϵͳ¡±Õ⼸¸ö×Ö£¬ÈçºÎÔÚ <input>Öвéѯ¡°csdn ϵͳ¡±Ò²ÄܳöÀ´Õâ¸ö¡°csdnÂÛ̳ϵͳ¡±£¬ÎÒÏÖÔÚÊDz顰csdn¡±»òÕß¡°ÏµÍ³¡±¶¼¿ÉÒÔ¡£Ð»Ð»¸÷λÁË£¡²»ÖªµÀÎÒÕâô±í´ï ......
ÓÐÒ»ÌõsqlÓï¾ä select a.name ,b.name from tableA a,tableB b where a.id = b.id and ¡£¡£¡££¨ÆäËû¹ýÂËÌõ¼þ£©
ÆäÖÐa.id ΪtableAÖ÷¼ü ÓÐΨһÐÔË÷Òý Êý¾ÝÁ¿²Å1ǧ¶à
b.id ΪÈÕÖ¾±ítableB µÄÍâ¼ü £¬ÂýÈ¥Ìõ¼þµÄ²Å ......
ÓÉÓÚÒÔǰûÓÐinnodbµÄÓ¦ÓþÑ飬ÔÚÅäÖÃinnodbµÄinnodb_data_file_pathÑ¡ÏîʱÓõÄÊÇĬÈÏÅäÖã¨ibdata1:10M:autoexte
nd£© ,½ñÌì·¢ÏÖ´ËÊý¾Ý¿âÔÚͬ²½Ö÷Êý¾Ý¿âÊý¾Ýʱ£¨´ËinnodbÊÇ×÷Ϊһ̨myisam dbµÄÀ䱸»úÆ÷£©£¬ibda ......