Go Back   Forum Care Forums > Development Reference Area > MySQL Discussion

Reply
 
LinkBack Thread Tools Display Modes
error mysql when I clean all the other null account in mysql database that located in table user
Old
  (#1)
kwan
Guest
 
Posts: n/a
Default error mysql when I clean all the other null account in mysql database that located in table user - 06-04-2007, 06:58 AM

Dear all,

I tried to clean the default information in the mysql database that
located in user table. When use the >mysql -uroot -proot
it is working, but when I clean and delete some data in the user table
by calling the following SQL statement:
DELETE FROM user WHERE User= ' ';
DELETE FROM user WHERE User=' ' AND HOST='localhost';
DELETE FROM user WHERE User='root' AND P***word=' ';

after calling the above SQL statement, then I try to
use >mysql -uroot -proot

It displays the following error:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
p***word: YES)

Any solution?

   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Contact Us - Forum Care Forums - Archive - Top