help - cant log in user password v4 to v4.1 migration problem.

[dave grant]

Hi

im in the process of transferring hosts and i cant log into my application as a user in my application on the new server.

old host
PHP Version 4.4.1
MySQL v4.0.26-standard.

new host
PHP version 4.4.2
MySQL 4.1.13-standard

my user password are encrypted as
eg
5f4dcc3b5aa765d61d8327deb882cf99

but the db appears to have been upgraded with a charset of:
MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation: utf8_general_ci

and various columns in the tables now have a collation of latin1_swedish_ci eg username and userpassword

i understand this is a change in the encryption but i dont know what to do about it.

has anyone got any suggestions to help me fix / update the two columns??

Thanks
Dave