重置Grafana admin密码

原创作者：运维工程师 林琪

1、进入grafana数据库

sqlite3 /var/lib/grafana/grafana.db

2、查看数据库中包含的表，找到user表

sqlite> .tables
alert                     dashboard_tag             server_lock
alert_notification        dashboard_version         session
alert_notification_state  data_source               star
alert_rule_tag            login_attempt             tag
annotation                migration_log             team
annotation_tag            org                       team_member
api_key                   org_user                  temp_user
cache_data                playlist                  test_data
dashboard                 playlist_item             user
dashboard_acl             plugin_setting            user_auth
dashboard_provisioning    preferences               user_auth_token
dashboard_snapshot        quota

3、查看user表内容，找到admin用户

sqlite> select * from user;
1|0|admin|admin@localhost||94fe17ecc7dd72a7ba9787e13c17462747f50ce8574adb1cb1422f3d62cdab2f3d058c7a356447b698cfa3341fbc6c1d6bd8|2pJooRU9Dd|0VZzPVERJY||1|1|0||2020-09-14 00:47:30|2020-09-14 00:48:47|0|2020-12-03 06:55:03|0

4、重置admin密码为admin

# 使用update更新密码
sqlite> update user set password = ‘59acf18b94d7eb0694c61e60ce44c110c7a683ac6a8f09580d626f90f4a242000746579358d77dd9e570e83fa24faa88a8a6‘, salt = ‘F3FAxVm33R‘ where login = ‘admin‘;

# 修改完成后退出
sqlite> .exit

可以正常登录了！