Error 1251 - Client does not support authentication protocol requested by server. Navicat ( HELP )

[JayReyes]

Been trying to get my retro up but this server is setting me back, anyone know the fix??

 

[TesoMayn]

For anyone else experiencing this issue, it's an easy fix

UPDATE mysql.user SET Password=PASSWORD('new-password') WHERE User='username';
FLUSH PRIVILEGES;

And if you are unable to login to run that command

mysqld_safe --skip-grant-tables --old-passwords
mysql -u root