How to reset the administrator password? (如何重置管理员密码)

[Jonnyan404]

docker exec -it memos sed -i 's/dl-cdn.alpinelinux.org/mirrors.ustc.edu.cn/g' /etc/apk/repositories #Non -Chinese users ignore this trip

docker exec -it memos apk add sqlite

docker exec -it memos sqlite3 /var/opt/memos/memos_prod.db 'update user set password_hash="$2a$14$ajq8Q7fbtFRQvXpdCq7Jcuy.Rx1h/L4J60Otx.gyNLbAYctGMJ9tK" where id=1'

The password after resetting is: secret
重置后的密码为: secret

[3336832]

failed like this:

/usr/local/memos # apk add sqlite
fetch https://dl-cdn.alpinelinux.org/alpine/v3.21/main/x86_64/APKINDEX.tar.gz
fetch https://dl-cdn.alpinelinux.org/alpine/v3.21/community/x86_64/APKINDEX.tar.gz
(1/4) Installing ncurses-terminfo-base (6.5_p20241006-r3)
(2/4) Installing libncursesw (6.5_p20241006-r3)
(3/4) Installing readline (8.2.13-r0)
(4/4) Installing sqlite (3.48.0-r0)
Executing busybox-1.37.0-r9.trigger
OK: 10 MiB in 20 packages
/usr/local/memos # sqlite3 /var/opt/memos/memos_prod.db 'update user set passwo
rd_hash="$2a$14$ajq8Q7fbtFRQvXpdCq7Jcuy.Rx1h/L4J60Otx.gyNLbAYctGMJ9tK" where id
=1'
Error: in prepare, no such column: "$2a$14$ajq8Q7fbtFRQvXpdCq7Jcuy.Rx1h/L4J60Otx.gyNLbAYctGMJ9tK" - should this be a string literal in single-quotes?
  update user set password_hash="$2a$14$ajq8Q7fbtFRQvXpdCq7Jcuy.Rx1h/L4J60Otx.gy
                  error here ---^