Changes
Page history
Update Cheat Sheet
authored
Jul 08, 2022
by
Daniel Kazior
Show whitespace changes
Inline
Side-by-side
Cheat-Sheet.md
View page @
61c4df57
## Update a Customer password in database
## Update a Customer password in database
(identified by email)
```
sql
```
sql
UPDATE
`customer_entity`
SET
`password_hash`
=
CONCAT
(
SHA2
(
'xxxxxxxx
test123
'
,
256
),
':xxxxxxxx:1'
)
WHERE
`email`
=
'
nullfuenf
@crefopay.de'
;
UPDATE
`customer_entity`
SET
`password_hash`
=
CONCAT
(
SHA2
(
'xxxxxxxx
PASSWORD
'
,
256
),
':xxxxxxxx:1'
)
WHERE
`email`
=
'
example
@crefopay.de'
;
```
```
\ No newline at end of file