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

[Database Administrator]

On May 23, 11:24 am, kwan 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 Password=' ';
>
> 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
> password: YES)
>
> Any solution?

Have you tried: flush privileges; after making those changes? Are you
sure that the root account that you were using your password with was
set up with the host as localhost? Perhaps your root account only has
access to the mysql table? Try getting in directly to the mysql
database with just: mysql -uroot mysql, and then try it with mysql -
uroot -proot mysql.

Nino