----- Original Message ----- > From: "J Gao" <j...@veecall.com> > Subject: Transfer ENCRYPT password field to another server > > So, is there a way to make the MySQL encrypted password string > "2I6JOeg.JukJ." convert to MD5 hash "$1$................."?
Nope. Encrypt() calls unix crypt(), which is really more a hash - you can't go back to the original. The proper way to handle this, is to notify the users that passwords will expire upon moving to the new system, and sending each of them a personal, unique link to set their new password. -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
