I'm trying to set the password for 'root'@'localhost'. I execute the query successfully but when I try to go back to the phpMyAdmin homepage I get "Cannot connect: invalid setting"
The only way to fix it is to log into MySQL via the command line and remove the password.
Why is this happening? Why can't I set the password? When I am able to open the homepage it says User: root@localhost. If I'm accessing the page as root@localhost, shouldn't it be asking me for my password or something?