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

After numerous attempts to find the solution to this problem, I found one that worked. I had gone through a slew of message boards, and forums, and everything I tried did not work. I did remember osCommerce working on my server on godaddy, so what was the difference? The operating system. When I tried to install osCommerce on a Windows (IIS) based server, I would get the error: "Client does not support authentication protocol requested by server; consider upgrading MySQL client".

Clearly this is not an easy solution, but its the best I found compared to the other ones. First, I backed up all my files on the server and I changed the server to Linux. And presto! osCommerce began the installation process, and everything worked!

Hopefully, this will help someone else.

Sol