Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÐÞ¸ÄÃÜÂëÎÊÌâ

ÎÊÌâÊÇÕâÑùµÄ£¬ÏÖÔÚÓиöÓû§mysql ÃÜÂëΪ¿Õ£¬È»ºóÎÒÏÈ°ÑËü¸Ä³É123£¬ÕâÑùдΪʲô²»ÄܸÄmysqladmin -u mysql password 123£¬½á¹û³öÏÖmysqladmin: Can't turn off logging; error: 'Access denied; you need t ......

Á½Ì¨Mysql·þÎñÆ÷£¬Êý¾Ýͬ²½

ÏÖÔÚÓÐÒ»¸öÍøÕ¾£¬ÏëÔÚÁíÍâһ̨·þÎñÆ÷ÉÏ×öÒ»¸öÕâ¸öÍøÕ¾µÄ¾µÏñ¡£
ÔÚÖ÷ÍøÕ¾ÉϵÄÊý¾Ý¸üÐÂҪͬ²½µ½¾µÏñ·þÎñÆ÷ÉÏ
ͬʱÓû§·ÃÎʾµÏñ·þÎñÆ÷ʱµÄÊý¾Ý¸üÐÂҲҪͬ²½µ½Ö÷ÍøÕ¾ÉÏ

ÆäÖÐÊý¾Ý¸üРÖ÷Òª°üÀ¨ MysqlÊý¾Ý¿âµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ