Skip to content

Instantly share code, notes, and snippets.

@PadCesar
Created January 14, 2020 11:49
Show Gist options
  • Save PadCesar/80b466135764d2c107501b884d1ab6f6 to your computer and use it in GitHub Desktop.
Save PadCesar/80b466135764d2c107501b884d1ab6f6 to your computer and use it in GitHub Desktop.
[sqlite3 DB grafana]Reset grafana password into admin,admin
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