I lost my password to Metabase running on Kubernetes. I am the only admin on the team and can’t seem to reset password. Can I find my password in system files on the container running Metabase in Kubernetes ?
Hi @kng
The passwords are stored in the application database.
https://www.metabase.com/docs/latest/faq/using-metabase/how-do-i-reset-my-password.html
Thanks @flamber, the password in application database is encrypted and the reset_token attribute is null
.
Is there a way to decrypt the encrypted password?
I resolved this by making another team member super_user in the core_user table and have them reset my password.
Hey, how do you create a new super user in core_user table? Thanks
@mal_a You should absolutely not do that manually - it's a great way to corrupt your application database.
Use the API to create a new user. https://www.metabase.com/docs/latest/api-documentation.html
If you already have a user in core_user
that you want to make superuser, then change the is_superuser
column to true
for that user.
@flamber Can the change of is_super_user for an existing user be done manually? Or is there a way to decrypt the encrypted password?
@mal_a You can change is_superuser manually, like I wrote.
You cannot decrypt the passwords - it's a one-way hash (bcrypt)