MySql root ÃÜÂëÊÇ·ñÓÐʱЧ?
ÇëÎÊMySqlµÄRootµÄµÇÈëÃÜÂëÊÇ·ñÓÐʱЧ? ½ñÌ컹¿ÉÒÔͨ¹ýrootµÄÃÜÂëµÇÈë,Ã÷ÌìÔÙÓÃͬһ¸öÃÜÂëµÇÈëÈ´ÌáʾÎÒ1045´íÎó. ϵͳ»·¾³ÊÇMySql5.1 + windows2003 Ôڴ˹ý³ÌÖÐûÓÐÈ˸ü¸Ä¹ýrootµÄÃÜÂë.
²¹³ä˵Ã÷:ÔÏÈ×¢²á¹ýµÄ¿Í»§¶Ë¹¤¾ß¶¼¿ÉÒÔÕý³£·ÃÎÊ ¾ÍÊÇÔÚMySqlĿ¼Ï Óà mysql -u root -p ÔÙÊäÈëÃØÂë,¾ÍÒ»Ö±Ìáʾ1045´íÎó. ======================================================================= C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql -u root -p Enter password: ******* ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y ES) ûÓаÉÒýÓà ²¹³ä˵Ã÷:ÔÏÈ×¢²á¹ýµÄ¿Í»§¶Ë¹¤¾ß¶¼¿ÉÒÔÕý³£·ÃÎÊ µÇ¼ÉÏÈ¥£¬ÌùÒ»ÏÂshow grants µÄ½á¹û¡£ ÊÇûÓÐʱЧµÄ£¬ ÏÈ¿´Ò»ÏÂÄãÊÇ·ñ¿ª´óСд¹¦ÄÜ£¬ ÔÙÒ»¸öºÃºÃÏëÏëÃÜÂëÊÇ·ñÓдíÎó¡£ ÃÜÂëÍü¼ÇÁ˲ſ¼ÏÂÌû http://topic.csdn.net/u/20090515/21/2b3c9a12-d8a5-4bb1-9895-6069cef5aef8.html?64096 ÎÒ¿Í»§¶ËÊÇ EMS Sql Manager 2007 , ÎÒÓÃÕâ¸ö¿Í»§¶Ë¹¤¾ßµÇÉÏÈ¥·¢ÏÖuser À¸ÀïÓÐÒ»ÐÐÊÇNull, ÇÒ¿Í»§¶ËµÄÒªÔö¼ÓÒ»¸öÓû§¶¼»áÌáʾAccess denied for user 'root'@'%' Access denied for user 'root'@'%' ÄãµÄÓû§ÊÇ 'root'@'%' ²»ÊÇ 'root'@'localhost' £¬ÕâÊÇÁ½¸ö²»Í¬µÄÓû§¡£ Ã÷°×ÁË...ллACMAIN_CHM
Ïà¹ØÎÊ´ð£º
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡ linux? ÔõôдÈëµÄ ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£ ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡ ±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿ Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
CREATE DATABASE ADDRESSLIST; USE ADDRESSLIST; DROP TABLE IF EXISTS FRIEND; CREATE TABLE FRIEND (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY , FRIEND_NAME VARCHAR(20) NOT N ......