I want to remove the password for user root in localhost. How can I do that? By mistake I have set the password of root user. That's why phpmyadmin is giving an error:
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
I want to remove the password for user root in localhost. How can I do that? By mistake I have set the password of root user. That's why phpmyadmin is giving an error:
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
I have also been through this problem,
First i tried setting my password of root to blank using command :
But don't be happy , PHPMYADMIN uses 127.0.0.1 not localhost , i know you would say both are same but that is not the case , use the command mentioned underneath and you are done.
Just replace localhost with 127.0.0.1 and you are done .
You need to set the password for
root@localhost
to be blank. There are two ways:The MySQL
SET PASSWORD
command:Using the command-line
mysqladmin
tool: