Re: error mysql when I clean all the other null account in mysql database that located in table user

On May 23, 2:24 pm, kwan <kwan.ji...@gmail.com> wrote:
> 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?

The mysqld service is running as normal,