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


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

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??


Options: ReplyQuote

Written By
help - cant log in user password v4 to v4.1 migration problem.
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.