Metabase super user Login password

Get Help
1

I am not able to login ,
from SELECT * FROM CORE_USER
I got user name, pwd , pwd salt etc
using salt I tried to update pwd but its not working showing 'Whoops, that's an expired link’

https://metabase.example.com/auth/reset_password/'pwd salt'

is it any way I can decrypt existing pwd, please help !

2

Hi @subhabrata007
Follow this guide: https://www.metabase.com/docs/latest/faq/using-metabase/how-do-i-reset-my-password.html

3

hi @flamber, I am using docker , I followed what you mentioned another article, Reset admin account without email

https://metabase.example.com/auth/reset_password/<<<<<pwd_salt>>>>
pwd_salt is right one or any other thing I should use?
but I stuck here

Whoops, that's an expired link

For security reasons, password reset links expire after a little while. If you still need to reset your

4

@subhabrata007 It's not password_salt, it's reset_token. You should be able to run a container with reset-password email@example.com applied in the end of the run-command. Otherwise use JAR and point it to your application database.

5

@flamber, can you please provide docker cmd for doing this , Please .

docker run -d -p 127.0.0.1:3000:3000
-v <>:/metabase-data
-e "MB_DB_FILE=/metabase-data/metabase.db"
--name metabasev0.33.6 metabase/metabase:v0.33.6 reset-password email@example.com , if so other container should I kill ?

6

@subhabrata007 I would recommend not using Docker unless you fully understand how it works. It just makes everything more complicated.

  1. Shutdown the container
  2. Download https://downloads.metabase.com/v0.33.6/metabase.jar
  3. Run
    java -DMB_DB_FILE=/<your-location-of-the-h2>/metabase.db -jar metabase.jar reset-password email@example.com

Then after you got access, then migrate away from H2 and consider upgrading to a later release. Latest is 0.39.3

1 Like
8

@flamber, thanks for your suggestion and help , you are awesome ,
worked for me. thanks a ton.

9

I have used the above command to reset the password. now can you help me to set new password for the user.

java -DMB_DB_FILE=metabase.db -jar metabase.jar reset-password metabaseadmin@abc.com

now how to set new password for metabaseadmin@abc.com

10

@babai93 Have a look here: https://www.metabase.com/docs/latest/troubleshooting-guide/cant-log-in
And migrate away from H2: https://www.metabase.com/docs/latest/installation-and-operation/migrating-from-h2
Latest release is 0.44.2: https://github.com/metabase/metabase/releases/latest