[Mysql]Client does not support authentication protocol error

Not a problem, but a solution / suggestion.

I was trying to install gallery2 with no avail at step 5.

I was getting the error: Client does not support authentication protocol

After reading the mysql manual (I am using 4.1.9 on freebsd and setting up from a remote machine on the same subnet)

manual.html#Old_client

and it described having to set the password to the old type, which fixed the problem i was having.

Will gallery2 be upgraded to support the new password format?

(hint for stuck people)

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;

bug posted