MYSQl client: "Client does not support authentication protocol requested by server

[MITTAL Pradeep Kumar]

Hello,
 
 
I want to use mysql in revoltuion 2.6.  When I try to connect to the my
sql server, it throws me the following error,
 
"There was an error connecting to database. Please check that connection
fields are correct"
REvDBError: "Client does not support authentication protocol requested
by server , Consider upgrading mysql client"
 
Please let me know if you have any idea to solve this.
 
Thanks
Best Regards
Pradeep