Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÔËËã·û»ñµÃ¸ü¶àÊý¾Ý±È½Ï¹¦ÄÜ
Èç¹ûÄãÔÚ×î½ü½øÐйýSELECT»òUPDATE²éѯ£¬ÄÇôÄãºÜ¿ÉÄÜÓõ½¹ýÒ»¸ö»òÕ߶à¸öMySQLµÄ±È½ÏÔËËã·ûÀ´ÏÞÖƲéѯµÄÊä³ö½á¹û¡£±È½ÏÊÇ´ó¶àÊýSELECT²éѯ²»¿É·Ö¸îµÄÒ»²¿·Ö£¬¶øMySQLΪÕâÒ»¹¦ÄÜÌṩÁ˺ܶຯÊý£»¸ù¾Ý×î½üÒ»´Îͳ¼Æ£¬ËüÓг¬¹ý20¸öÕâÑùµÄÔËËã·ûºÍº¯Êý£¬´ÓÖøÃûµÄ=ºÍLIKEµ½¸ü¼ÓÄѶ®µÄNO ......

MySQL´¥·¢Æ÷½â¾ö·½°¸Àú³Ì

×î½ü£¬ÏîÄ¿ÖÐÓõ½mysql£¬ÓÉÓÚÊý¾ÝÁ¿·Ç³£´ó£¬Ã¿ÌìµÄÊý¾ÝÁ¿ÔÚ°ÙÍò¼¶£¬¿¼Âǵ½mysqlÊý¾Ý¿â´¦ÀíÐÔÄÜÒÔ¼°Êý¾ÝÊôÐÔ£¬¾ö¶¨±£´æ×ã¹»¶àµÄ²éѯÊý¾Ý¼´¿É£¬¾àµ±Ç°Ê±¼ä×î¾ÃÔ¶µÄÊý¾ÝÖ±½Óɾ³ý£¬ÎÞÐè½øÐб¸·Ý¡£
Í·ÄÔÖÐð³öµÄµÚÒ»¸öÏë·¨¾ÍÊÇ£¬ÄÜ·ñÀûÓÃmysqlÖеĴ¥·¢Æ÷£¬¼ì²éÊý¾Ý±í´óС£¬Èç¹û³¬¹ýÔ¤É賤¶È£¬Ôòɾ³ý²¿·ÖÊý¾Ý¡£
CREATE TRIGGER ......

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

1.µÇ¼£º mysql -uroot -p
2.LinuxÏÂmysql ²»ÄÜÍâÍø·ÃÎÊ
  
   ÒѾ­ÔÚMYSQLÀïgrantÁËȨÏÞÁË¡£ÔÚÍâÍø»¹ÊDz»ÄÜ·ÃÎÊ .
   ÎÊÌ⣺
   cat  /etc/mysql/my.conf
   ÕÒµ½ÏÂÃæÒ»ÐÐ
   bind-address   = 127.0.0.1
   Î ......

dominoÁ¬½Ómysql²åÈëÖÐÎÄÄÚÈݳöÏÖÂÒÂëµÄ½â¾ö·½°¸

    ½üÈÕ£¬ÓÐÒ»¸öÏîÄ¿ÐèҪͨ¹ýOAϵͳ£¨Dominoƽ̨£©ÏòÒ»¸öMySQLÓ¦ÓòåÈë¼Ç¼£¬ÒòΪƽ̨ÊÇwindowsƽ̨£¬ËùÒÔ²ÉÓÃÁËODBCÁ¬½Ó·½Ê½£¬ÔÚOA·þÎñÆ÷ÉÏ°²×°ÁËMyODBC-3.51.11-1Çý¶¯£¬ÅäÖÃÁËODBCÇý¶¯Êý¾ÝÔ´Ö®ºó£¬²åÈë¼Ç¼³É¹¦£¬µ«²»ÂÛÊDzåÈëÖÐÎÄÄÚÈÝ£¬»¹ÊÇ´ÓMySQLÖжÁÈ¡ÖÐÎÄÄÚÈÝ£¬¶¼ÊÇÂÒÂ룬ÔÚÍøÉϲéÔÄÁ˸÷ÖÖ×ÊÁÏ£¬³õ²½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ