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);
