Changing phpmyadmin root password
I'm trying to figure out how to change the root password for phpmyadmin. I've tried doing this a few times using this:
$ mysql -u root -p
use mysql;
update user set password=PASSWORD("NEWPASSWORD") where User='root'
But then when I go to login using the new password or even the old password, I'm denied access. Any help is appreciated!
I was able to do this by instead of doing update update user set password=PASSWORD("newpassword") where User='root'
but usingset password = password ("newpassword");
flush privileges
//optionalquit