Hi folks,
Got a puzzler that I'm wondering if anyone can point me in the right
direction of. Noone has had any inspiration as of yet!

I have a FreeBSD server (6.2-RELEASE)

It runs cpanel and in the course of setting something up things broke
etc. I've got most of the problems sorted but Mysql is being a pain.

It is running:

mysql Ver 14.12 Distrib 5.0.51a, for portbld-freebsd6.2 (amd64) using
5.0

The problem is in authentication and new versus old passwords.
The password table is the right width for new passwords.
When passwords are generated they get generated and stored as the right
length for new passwords.
However, when you try to authenticate against a new password it gives the
message "Client does not support authentication protocol requested by
server".
Any passwords stored as the old type still pass.

I have to manually use old_password() to make sure users have old
passwords and I have had to set the old passwords on so that any new
passwords are generated in the old format.

So, the summary questions are:

1) Why will mysql no longer work with the new password format?
2) What can I do about it?

Cheers if anyone can , identifying where the problem is about as far
as I can get!