Created
January 14, 2020 11:49
-
-
Save PadCesar/80b466135764d2c107501b884d1ab6f6 to your computer and use it in GitHub Desktop.
[sqlite3 DB grafana]Reset grafana password into admin,admin
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
root@codesposts:~# sqlite3 /var/lib/grafana/grafana.db | |
SQLite version 3.28.0 2019-07-04 01:12:19 | |
Enter ".help" for instructions | |
Enter SQL statements terminated with a ";" | |
sqlite> .tables | |
alert dashboard_version quota | |
alert_notification data_source session | |
annotation login_attempt star | |
annotation_tag migration_log tag | |
api_key org team | |
dashboard org_user team_member | |
dashboard_acl playlist temp_user | |
dashboard_provisioning playlist_item test_data | |
dashboard_snapshot plugin_setting user | |
dashboard_tag preferences user_auth | |
sqlite> update user set password = '59acf18b94d7eb0694c61e60ce44c110c7a683ac6a8f09580d626f90f4a242000746579358d77dd9e570e83fa24faa88a8a6', salt = 'F3FAxVm33R' where login = 'admin'; | |
sqlite> .exit |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment