Changing Password Schemes

Carl A Jeptha cajeptha at
Fri Apr 29 23:03:06 UTC 2016

Hi Bill,
using PHPMYAdmin:
UPDATE 'mailbox' SET 'password' = SHA2 ('clearpwd',512);
{UPDATE 'the users table' SET 'cryptic password column' = SHA2 ('clear 
text password column',512);}
gives this error:
#1064 - You have an error in your SQL syntax; check the manual that 
corresponds to your MySQL server version for the right syntax to use 
near '[`clearpwd`512] FROM `mailbox` WHERE `password` <> SHA2 [ 
`clearpwd` OR 512' at line 1

You have a good day now, en mag jou môre ook so wees,

Carl A Jeptha

On 2016-04-29 15:20, Bill Shirley wrote:
> UPDATE `users`
> SET `passwd_SHA512` = SHA2(`passwd_clear`, 512);

-------------- next part --------------
A non-text attachment was scrubbed...
Name: dot.gif
Type: image/gif
Size: 43 bytes
Desc: not available
URL: <>

More information about the dovecot mailing list