New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Reset Admin pass #1815
Comments
yea, this feature is not yet implemented :( |
what database do you use for grafana? Sqlite ? I can walk you trough or give you a script that resets it |
@torkelo yes im using sqlite! |
i am using mysql, any chance you can post the instructions here. |
Need admin password reset for postgres. |
Update the password and salt columns in the user table: if its mysql you need to escape user, like |
The above will set password back go admin/admin |
Thanks. user table needs to be in quotes for postgres ie: update "user" set ... |
+1 With SQLite on Ubuntu I had to do this:
|
I tried the given solution, and when I logged in with admin user after a little while (less than a minute) it kicked me out to login page. Now I can not login and when I set password again it does not have any effect. UPDATE: just checked the database, user was deleted for some reason I don't know. I'm not sure how to create new admin user. Should I open another issue? |
@torkelo apologies for opening up an old thread. Can you tell me what type of hash value grafana uses and how you would create a salt value? I'm new to password hashing in general and wish to automate the creation of grafana users via mysql within my Puppet setup. Any info you can provide would be appreciated. Cheers, |
@Qtax .. this is great trick. |
I did reset password this way, but all previous dashboard data is lost. |
Which hashing algorithm do you use, how to generate some other password? |
@miodrag-zivkovic-shiftplanning We use PBKDF2 from this golang package. For login, we also have a guard for time based attacks. What do you mean by
|
why grafana-cli admin reset-admin-password admin docments not working? It's told me |
@eoekun So you changed the password but it still does not work (with username EDIT: nevermind, I see you did it via the database instead. |
@daniellee Use the grafana-cli does not work so I execute the sql statement. |
http://docs.grafana.org/administration/cli/#reset-admin-password @eoekun what version are you running? grafana-cli-admin reset-admin-password works fine for me in 4.5.2 |
Just for anyone may need this - my grafana docker installation suddenly reseted user table and I was able to login only with default admin:admin pair. |
|
My user table (in Not only do the official instructions on the support page (http://docs.grafana.org/administration/cli/) not work, the instructions telling you to manually modify the SQLite3 database at Your documentation should make clear that the relevant database is |
Team, We are running grafana in kubernetes container. I forgot the admin password and try to reset the password with below command. but no luck. Can you please suggest how to i reset the admin@localhost/admin password on grafana container |
This is broken due to the service graph refactoring. The cli does not init the transaction manager and the bus itself. |
Worked for me thanks using v5.3.4 in a lxd container! |
@xdfil's solution worked for me but only after deleting ALL users, not just admin. |
I was changing my pass! But now, the new Password isnt working! How can i reset it?
The text was updated successfully, but these errors were encountered: