Hi,
Can I convert all users plain text password in field "password" to hashed password in field "passwordhash", so users do not have to create new passwords themselves?
Have tried this in phpMyadmin:
UPDATE usertable
SET passwordhash
= SHA2(passwordlower
, 256) WHERE 1
But that does not seem to work.
tia
/Poul