Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

netbeans Á¬mysql - Web ¿ª·¢ / HTML(CSS)

ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......

ÔõôÔÚeclipseÏÂÏòmysql²åÈë±äÁ¿°¡ - Java / JavaÏà¹Ø

String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡­¡­µ½µ×¸Ãզд°¡

Íò·Ö¸Ðл£¡

String SQL=&q ......

mysqlÊý¾Ý¿â - Java / JavaÏà¹Ø

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