MySQL Error-The server requested an authentication method unknown to the client
Recently some of our clients got this error when tried to connect the MySQL database. The main cause for this error is the improper authentication settings given in MySQL. Why a MySQL authentication plugin? When a MySQL user tries to login (for example in PhpMyAdmin) then the authentication plugin checks that the connection is whether coming from a legitimate user. While creating a user or altering a user using CREATE USER, GRANT, ALTER USER statements