Upgrade problems

[untold4you]

Hi there, i've updated to mysql 5

Does someone knows what this error means?



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



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:



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



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!