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