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

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


Ïà¹ØÎÊ´ð£º

eclipseÓëmySQLµÄÎÊÌâ - Java / Eclipse

ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......

ÓйØmysqlµÄÎÊÌ⣡ - Java / Web ¿ª·¢

ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ

ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£

ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......

mysqlÁ¬½Ótomcat - Java / Web ¿ª·¢

ÎÒÒѾ­°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......

MysqlЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

±í
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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ