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

mysql root ÃÜÂëÍü¼Ç£¿£¿£¿£¿

½ñÌì¸øÐÂÀ´µÄÔ±¹¤Á¬½ÓÊý¾Ý¿â£¬ÐÞ¸ÄÁËÒ»ÏÂmysql rootÓû§µÄÃÜÂ룬ÎÒÏÂÔصÄÊÇ´ò°üµÄredMine£¬Ä¬ÈÏÃÜÂëÊÇ¿Õ£¬ÐÞ¸ÄÃÜÂëÖ®ºóÖØÆôredmine£¬phpAdmin Á´½Ó²»ÉÏmysqlÊý¾Ý¿âÁË£¬ÎÒÒ²ÐÞ¸ÄÁËphpadminÎļþ¼ÐϵÄconfig.inc.phpµÄÃÜÂ룬»¹ÊDz»ÐУ¬Ìáʾ#1130 - Host 'localhost' is not allowed to connect to this MySQL server´íÎó£¬Ã÷ÏÔ²»ÊÇÃÜÂëÎÊÌâ°¡£¬Èç¹ûÊÇÃÜÂë´íÎóµÄ»°»áÌáʾ#1045 - Access denied for user 'root'@'localhost' (using password: YES)´íÎóµÄ£¬
ÎÒÉÏÍøËÑÁ˺ܶà½â¾ö·½°¸£¬Ã»ÓÐÒ»¸öÄÜ˵Ã÷°×µÄ£¬ËùÒÔ×Ô¼º½â¾öÁËһϣ¬Ê×ÏÈ°Ñmysql/data/mysqlÎļþ¼ÐϵÄuser.frm+user.MYD+user.MYIÈý¸öÊý¾Ý¿âÎļþÓÃÎÒÔÚÁíһ̨»úÆ÷ÉÏ°²×°µÄÌæ»»µô£¬¹âÌæ»»µôÕâЩÊDz»Ðеģ¬ÔÙÀ´ÔÚmysql/dataĿ¼ÏÂÌæ»»µôib_logfile0ºÍib_logfile1Îļþ£¬µ½´ËΪֹ£¬ÕâÑùÓлص½ÁËûÓÐÐÞ¸ÄÃÜÂë֮ǰ£¬


Ïà¹ØÎĵµ£º

ÈçºÎ±£»¤MySQLÖеÄÖØÒªÊý¾Ý

ÔÚÈÕ³£µÄ¹¤×÷ÖУ¬±£»¤Êý¾ÝÃâÊÜδÊÚȨÓû§µÄÇÖ·¸ÊÇϵͳ¹ÜÀíÔ±Ìرð¹ØÐĵÄÎÊÌâ¡£Èç¹ûÄãÄ¿Ç°ÓõÄÊÇMySQL£¬¾Í¿ÉÒÔʹÓÃһЩ·½±ãµÄ¹¦ÄÜÀ´±£»¤ÏµÍ³£¬À´´ó´ó¼õÉÙ»úÃÜÊý¾Ý±»Î´ÊÚȨÓû§·ÃÎʵķçÏÕ¡£
ÆóÒµ×îÓмÛÖµµÄ×ʲúͨ³£ÊÇÆäÊý¾Ý¿âÖеĿͻ§»ò²úÆ·ÐÅÏ¢¡£Òò´Ë£¬ÔÚÕâЩÆóÒµÖУ¬Êý¾Ý¿â¹ÜÀíµÄÒ»¸öÖØÒª²¿·Ö¾ÍÊDZ£»¤ÕâЩÊý¾ÝÃâÊÜÍⲿ¹¥»÷£ ......

mysql µ¥ÒýºÅ Ë«ÒýºÅ

½ñÌìÔÚдһÌõsqlÓï¾äµÄʱºò£¬ÓõÄË«ÒýºÅ£¬sqlÓï¾äÖ´ÐдíÎ󡣼ǵÄͬÊÂÎÊÎÒmysqlÓï¾äÖеĵ¥ÒýºÅºÍË«ÒýºÅÓÐÇø±ðÂ𣿻شðÊÇûÓÐÇø±ð¡£
½ñÌìÌصزéÁ˲飬»¹ÊÇÓеãÇø±ðµÄ¡£
mysqlÖеÄÒ»¶Î˵Ã÷£º
ÔÚmysqlÖУ¬Ê¹Óõ¥ÒýºÅºÍË«ÒýºÅÁ©ÖÖ±í´ï·½·¨ÊÇÒ»ÑùµÄ£¬¾¡¹ÜʹÓõ¥ÒýºÅµÄ±í´ï·½·¨·ûºÏANSI-SQL/92±ê×¼¡£
Èç¹ûÔÚ×Ö·û´®ÀïÓÐÒýºÅ£¬Ôò ......

mysql°²×°µÄ¹ý³Ì

   ½ñÌìÖØÐÂ×°ÁËÒ»ÏÂmysqlÊý¾Ý¿â£¬½ØÖ¹µ½ÏÖÔÚÒѺÄʱ2£º30£¬ÓôÃÆ£¡£¡£¡£¡£¨ÎÒÔ­À´²»ÖªµÀ×°¹ý¶àÉÙ´Îmysql£©
   ËùÒÔÎÒ¾ö¶¨£¬°Ñ¹ØÓÚmysqlÊý¾Ý¿âµÄ³õʼ»¯²Ù×÷½éÉÜÒ»ÏÂ
£º
    1.°²×°mysqlÊý¾Ý¿â
       http://www.duote.com/tech/1/2430_1.html
  ......

Linux Ï mysql µÄÏà¹ØÃüÁî

1.µÇ¼£º mysql -uroot -p
2.LinuxÏÂmysql ²»ÄÜÍâÍø·ÃÎÊ
  
   ÒѾ­ÔÚMYSQLÀïgrantÁËȨÏÞÁË¡£ÔÚÍâÍø»¹ÊDz»ÄÜ·ÃÎÊ .
   ÎÊÌ⣺
   cat  /etc/mysql/my.conf
   ÕÒµ½ÏÂÃæÒ»ÐÐ
   bind-address   = 127.0.0.1
   Î ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ