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

If you did encounter an error like this

Heres the best solution for it:
just type this simple sql query

use mysql;
UPDATE table_name SET password = old_password('password') WHERE user = 'user_name';
FLUSH PRIVILEGES;