原创作者:运维工程师 林琪
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
可以正常登录了!