How to reset superadmin password?

[francescor]

We've lost superadmin password, how to reset it?

We use

image: ghcr.io/windmill-labs/windmill:1.432.0

on a docker swarm setup

[rubenfiszel]

Modify the password_hash in the password table to: $argon2id$v=19$m=4096,t=3,p=1$z0Kg3qyaS14e+YHeihkJLQ$N69flI6yQ/U98pjAHtbNxbdz2f4PrJEi9Tx1VoYk1as for your user. That's the hash for changeme

[francescor]

psql
\c windmill
UPDATE password SET password_hash = '$argon2id$v=19$m=4096,t=3,p=1$z0Kg3qyaS14e+YHeihkJLQ$N69flI6yQ/U98pjAHtbNxbdz2f4PrJEi9Tx1VoYk1as' WHERE username = 'admin';

but still no login :(

windmill-qa_server.1.d036q0znkkr5@boat-worker-arm-9337    | 2025-05-05T11:44:08.380942Z  INFO request: windmill-audit/./src/audit_ee.rs:131: kind="audit" operation="redacted" action_kind=Create resource="EE only" parameters={"redacted":"-"} workspace_id="global" username="admin@windmill.dev" method=POST uri=/api/auth/login trace_id="1610a548-c19c-43aa-982f-7e11d75e4f23"

[francescor]

Uh, this one worked

UPDATE password SET password_hash = '$argon2id$v=19$m=4096,t=3,p=1$oLJo/lPn/gezXCuFOEyaNw$i0T2tCkw3xUFsrBIKZwr8jVNHlIfoxQe+HfDnLtd12I' WHERE username = 'admin';
UPDATE 1

found that hash in backend/migrations/20220508150023_changeme_passwords.up.sql