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
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
±í
CREATE TABLE `ch1` (
`id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
`no` int(10) unsigned DEFAULT NULL,
`dtime` datetime DEFAULT NULL,
PRIMARY KEY (`id ......