Thursday, November 18, 2010

mysql access denied for user 'root@localhost' using password yes

we are getting the comman error for phpmyadmin login
or doing the new set of mysql and trying to connect mysql

mysql access denied for user 'root@localhost' using password yes

Solution

root@localhost$ mysqladmin -u root password NEWPASSWORD
 
OR you want to update 
 
root@localhost$ mysqladmin -u root -p 'OLDPASSWORD' password NEWPASSWORD 
 
issue get resolved...
 
if still issue try to do following...
 
1) Restart mysql 
service myqsql restart

if still issue do following

1) execute following command
$ mysql
mysql > use mysql
mysql > UPDATE mysql.user SET Password=PASSWORD("*******")WHERE User="root";
mysql > FLUSH PRIVILEGES; 
mysql > quit;  
 
 

No comments: