Client does not support authentication protocol requested by server; consider upgrading MySQL client

This error i've handling for many month lol..

u can solve this problem by type this command

you enter in the mySql command line client and enter the following command SET PASSWORD FOR 'user'@'host' = OLD_PASSWORD('password');

example:
my user: is abu, my password: something and my host: localhost

the command will be:

SET PASSWORD FOR abu@localhost = OLD_PASSWORD('abu123');"


tara...siap now u can istall phpmyadmin or sqlyog for manage db