On May 23, 2:34 pm, "nino9st...@yahoo.com" <nino9st...@yahoo.com>
wrote:
> > > 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?
>
> Have you tried: flush privileges; after making those changes? Are you
> sure that the root account that you were using your p***word 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


No I already stop and restart the mysqld service, and call the FLUSH
PRIVILEGES too, and I have try the same way as you tell me, but it
still doesnt work anyway

hope to get solution very soon, thank you