PHPMyAdmin has been setup to use “cookie” authentication, but when you try to log into phpmyadmin, it returns:
"Client does not support authentication protocol requested by server; consider upgrading MySQL client"
This is because, the mysqlclient installed on the box does not use the same authentication protocol that the mysqlserver is using. You can either upgrade the client, or reset the root password using this
SET PASSWORD FOR user@localhost = OLD_PASSWORD('password');