Installation MySQL DB test issue

After getting past my initial problems with the database install screen I got a new error:
Client does not support authentication protocol requested by server; consider upgrading MySQL client

I search the osCommerce forum and the MySql forum. Some of the posts in the osCommerce forum suggested downgrading MySql from 4.1 to 4.0. I did find a post that pointed to a discussion in the MySql forum that had a suggestion which I tried and was able to get past this issue.

Open a MySql Command Line and enter:
use mysql;

UPDATE user SET password = old_password('yourpassword') WHERE user = 'theuser';

('theuser' is the user you're using to connect to the database with your application.)

FLUSH PRIVILEGES;