Transfer ENCRYPT password field to another server

[J Gao]

Hi, All,

I am having trouble to transfer email user account which is saved in 
MySQL to another server. Here is the detail:

I have an old email server which using MySQL to store user account 
information. The password field uses MySQL ENCRYPT function to save the 
users password. So if I want change the user's password I can do:
 UPDATE  `mail`.`users` SET  `password` = ENCRYPT(  '12345' ) WHERE 
CONVERT(  `users`.`email` USING utf8 ) =  'g...@veecall.com' LIMIT 1 ;

Then the new password "12345" saved in the table as string of " 
2I6JOeg.JukJ."

Now I build a new server using iRedMail. When I try to transfer user 
account I have trouble to transfer the password field. Because the 
iRadMail/dovecot is using MD5-CRAM to encrypt the password then save it 
in the MySQL. All the password string is started with "$1$".

So, is there a way to make the MySQL encrypted password string 
"2I6JOeg.JukJ." convert to MD5 hash "$1$................."?

Thanks for help.

Gao

--
     __
   _|==|_
    ('')__/
--(`^^')
  (`^'^'`)
  `======'