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

WindowsÏÂÐÞ¸ÄMySQL°²×°Ä¿Â¼ºÍMySQLÊý¾ÝĿ¼ ʧ°Ü

ϵͳµÄʼþ²é¿´Æ÷ÖпÉÒÔ¿´µ½Å¶

ÔØ£ºTable 'mysql.host' doesn't existµÄ´íÎó
»¹ÊDz»Äܽâ¾öÎÊÌâ

²Î¿¼ÈçÏÂ
indowsÏÂÐÞ¸ÄMySQL°²×°Ä¿Â¼ºÍMySQLÊý¾ÝĿ¼
2009-04-04 08:49:20
¡¡±êÇ©£ºMySQL¡¡¡¡¡¡[ÍÆË͵½¼¼ÊõȦ]

Windowsϰ²×°MySQL£¬Ò»°ãµÄĬÈÏĿ¼ÊÇcÅÌ£¬Òò´ËÔÚ°²×°ÍêºóÎÒÃÇÒ»°ã»áÒª¸ü¸ÄÎļþµÄ°²×°Ä¿Â¼ºÍMySQLÊý¾ÝĿ¼¡£
Ò»°ãµÄÐ޸ķ½·¨ÊÇ£º
1¡·ÐÞ¸Ämy.iniÎļþ¡£´ò¿ªÖ®ºó±à¼­ÆäÖеÄbasedirºÍdatadir£¬
  [mysqld]
basedir=E:\Program Files\mysql        #Ð޸ijÉÄãµÄmysql°²×°Ä¿Â¼
datadir=E:\Program Files\mysql\data    #Ð޸ijÉÄãµÄmysqlÊý¾ÝĿ¼
2¡·Æô¶¯Dos½çÃæ£¬ÔËÐÐnet start mysql±¨´í£¬ÏµÍ³ÕÒ²»µ½Ö¸¶¨Â·¾¶¡£
ÒòΪÎÒÃǸıäÁËmysqlµÄ°²×°Ä¿Â¼£¬µ¼ÖÂÕÒ²»µ½binÆô¶¯Ä¿Â¼¡£
Ð޸Ļ·¾³±äÁ¿£¬ÔÚpath·¾¶Ï¼ÓÈ룺E:\Program Files\mysql\bin
3¡·´ËʱÆô¶¯mysql£¬Èç¹û»¹±¨´íÎ󣬴ò¿ª×¢²á±í£¬ËÑË÷Ô­À´mysqlµÄ°²×°Â·¾¶£¬²¢½«ÆäÌæ»»ÎªÏÖÔÚÐµİ²×°Â·¾¶¡£
4¡·×¢ÏúÏ£¬ÖØÐÂÔËÐÐnet start mysqlÃüÁî¼´¿É¡£
×¢Ò⣺Æô¶¯MysqlʱÅöµ½ÁË 1067 ´íÎó£¬Ò»°ãÊÇmysqlµÄÅäÖÃÎļþmy.iniÓÐÎÊÌ⣬´ò¿ªÖص㿴ÏÂÀïÃæµÄbasedirºÍdatadir·¾¶ÊÇ·ñºÍÄãµÄʵ¼Ê°²

װĿ¼Ïàͬ¡£ÁíÍâÈç¹û»¹²»ÐУ¬¿ÉÒÔÖØÐÂÔËÐÐÏÂÄãµÄmysqlÅäÖÃÏòµ¼£¬ÖØÐÂÅäÖÃÏ¡£

ÏÂÃæÊÇ´ÓÍøÂçÉÏËѼ¯µÄ¹ØÓÚ1067´íÎóµÄ½â¾ö·½°¸£º
°²×°ºóMYSQL5ºó£¬·¢ÏÖÆô¶¯³ö´í£¬ÓÐʱÆô¶¯Õý³££¬µ«¼Ó½ÓʱÂíÉϳö´í¡£
³ö´í´úÂ룺1067
½â¾ö°ì·¨ÈçÏ£º
1.ɾ³ý%windows%/my.ini
2.ɾ³ýÆäËüµØ·½µÄmy.ini
3.ÔÚmysql°²×°Ä¿Â


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

Çómysql+php ÖÐÎÄÈ«ÎÄËÑË÷

×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£

µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ

È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......

´óÏÀÃǾÈÃü°¡:MysqlµÄmy.iniÎļþ¸ü¸ÄÊý¾Ý¿â·¾¶ÎÊÌâ

  ÎÒ°²×°ºÃmysqlºó,ĬÈϵÄÊý¾Ý¿â·¾¶ÊÇÔÚCÅÌÏÂ,ÎÒÏë°ÑËü¸Äµ½EÅÌÀï: ÎÒÏȰÑmysql·þÎñÍ£Ö¹,ÔÙÔÚmysql°²×°Ä¿Â¼(Ò²ÊÇÔÚEÅÌ)ÏÂÕÒµ½my.iniÎļþ,¾Í¸ÄÁËÏÂÃæÄÇô¶à:
#Path to the database root
datadir="E ......

MySQLÊý¾Ý°ü¹ý´ó

ÎÒÓÃÒ»¸öÑ­»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ


public static final DataBase.MAXSIZE=102 ......

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

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

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ