Re: Changing Password Schemes

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 '[clearpwd512] 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);