Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

[sandeep b]

hey guys i have the solution for the problem error 1045 (28000):access denied for the user 'root'@'localhost'(using password:NO)

step 1: query the user table of mysql database by logging in without password

\mysql -uroot
mysql>use mysql;

mysql>select user,host,password from user;

if the result set contains >2 users with the same name root then remove them by querying

mysql >delete from mysql.user where user='root';
(you can do this even for one root user)

step 2: add the root user like the below

insert into user(user,host,ssl_cipher,x509_issuer,x509_subject) values ('root','localhost','n','n','n');

step 3: now change the pass word of newly born user like

mysql>update mysql.user set password=password('root') where user='root';

now if u try to connect as

mysql -uroot -proot

the same problem arises

error 1045 (28000):access denied for the user 'root'@'localhost'(using password:NO)

step 4: now by giving a magic command you can resolve the problem

/mysql -uroot

mysql>flush privileges;
mysql>exit

step 5:now u can connect with mysql

/mysql -uroot -proot

thats all folks........................:)