[MySQL]Client does not support authentication protocol

[Flexis Hosting]

See title, I get this error since I updated MySQL to 4.1.12 on my server.

The server is running on Fedora 1 and php is version 4.3.11. I searched and found this link already and found also some other solutions like putting old-passwords in the my.cnf config but all don't work.

The SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd'); command is working fine but it's gonna be alot of work 2 convert all those password for all the customers. So I wonder is there a better way?

 

[wagnerch]

Yes, set the "old-passwords" option /etc/my.cnf...

[mysqld]
old-passwords
safe-show-database
skip-networking
skip-bdb
.
.
.