how to reset the admin password in 4.10

[mmljmb3]

How to reset the admin password in 4.10? There is no documented way to do this anywhere.

[knadh]

To reset the password externally, you can run this query on the database. Will add this to the documentation and also consider a CLI flag for a future release.

UPDATE users SET password = CRYPT('newpasswordhere', GEN_SALT('bf')) WHERE username='yourusername';

[mmljmb3]

So, can I be logged into Postgres with "listmonk" user and do this? Or does this require "postgres" user?

[knadh]

Any user that has access to the listmonk db.