SQL HOME SQL Intro SQL Syntax SQL Select SQL Select Distinct SQL Where SQL And, Or, Not SQL Order By SQL Insert Into SQL Null Values SQL Update SQL Delete SQL Select Top SQL Min and Max SQL Count, Avg, Sum SQL Like SQL Wildcards SQL In SQL Between SQL Aliases SQL Joins SQL Inner Join SQL Left Join SQL Right Join SQL Full Join SQL Self Join SQL Union SQL Group By SQL Having SQL Exists SQL Any, All SQL Select Into SQL Insert Into Select SQL Case SQL Null Functions SQL Stored Procedures SQL.
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.'
Caching Sha2 Password
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 itin 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$.'