| 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? |