Database field of hashed password

In which table and field of postgres is the admin password stored?

I have lost my admin password on a local redash instance I am maintaining and would like to manually changed it.

You can do this with the CLI. If the user is example@example.com and you want to set the password to pass1234 you would run the following:

docker-compose run --rm server manage users password example@example.com pass1234

You don’t want to edit the users table directly because the password is encrypted there. So you can’t just paste a plaintext value.

you can also use try with

 sudo docker exec -it redash_server_1 /app/manage.py users password mymail@mail.com  NeW_Pa55word

To create new admin user

 docker exec -it redash_server_1 /app/manage.py users create_root  mymail@mail.com  manju   --password pa55word123 --org my_org

To find your organization name ,

     docker exec -it redash_postgres_1 /usr/local/bin/psql -U postgres 

     select * from organizations ;
1 Like