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

Website was developed in .NET framework and DB in MySQL.

In my scenario, client was using 'ByteFX.Data.MySqlClient.' to establish the connection to db.


Issue was because, new kind of password encryption was not support in this case. So need to update DB user password to use old method.


Solution :

Login to MySQL

Reset the password using command : 

SET PASSWORD FOR ''=OLD_PASSWORD('');

Eg: SET PASSWORD FOR 'tradsigns' = OLD_PASSWORD('abcdefg');


:)