help - cant log in user password v4 to v4.1 migration problem.
Posted by: dave grant
Date: February 21, 2006 10:06AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
help - cant log in user password v4 to v4.1 migration problem.
2710
February 21, 2006 10:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.