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
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!