select
password_hash
from customer_entity
where email = ‘’;
得到以下值:
hash:xxxxxxxx:1
执行sql:
UPDATE customer_entity
SET password_hash
= CONCAT(SHA2(‘xxxxxxxxYOURPASSWORD’, 256), ‘:xxxxxxxx:1’)
WHERE entity_id
= 1;
select
password_hash
from customer_entity
where email = ‘’;
得到以下值:
hash:xxxxxxxx:1
执行sql:
UPDATE customer_entity
SET password_hash
= CONCAT(SHA2(‘xxxxxxxxYOURPASSWORD’, 256), ‘:xxxxxxxx:1’)
WHERE entity_id
= 1;