Fatal error: Client does not support authentication protocol requested by server; consider upgrading MySQL client in

1. Select the 'privileges' option on the main PhpMyAdmin page
2. Edit the user you're using to connect to the database
3. Scroll down to where it says 'Change password'
4. Enter and re-type the password for that user
5. IMPORTANT Where it says 'Password Hashing', choose the option that says 'MySQL 4.0 compatible'.
6. Save your selection


Or you can manually from the backed by using the below command
===============
mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

===============