Upgrade problems

[untold4you]

Hi there, i've updated to mysql 5

Does someone knows what this error means?

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Client does not support authentication protocol requested by server; consider upgrading MySQL client
--------------\htdocs\includes\class_core.php on line 271

I think it has something to do with copying my old data files from mysql 4 ?
(the .frm & myd things :))

Does someone know how to fix this without reinstalling mysql 4 ?

Thnx in advance!

Edit: I'm getting the same error when i import the data as .sql

[Dead Eddie]

The MySQL team changed the password hashing algorithm when they went to 4.1. When I got it, I had to run the following command as root directly against the database:

SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass');

More information here:

http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html

[Paul M]

You can also add

old-passwords = 1

to your mysql config file.

[untold4you]

thanks guys! It does the trick!