PHPMyAdmin - Client does not support authentication protocol requested by server

The Problem

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"


The Fix

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');