#说明 重置:admin 账号密码为:admin #执行命令 sqlite3 /var/lib/grafana/grafana.db update user set password = '59acf18b94d7eb0694c61e60ce44c110c7a683ac6a8f09580d626f90f4a242000746579358d77dd9e570e83fa24faa88a8a6', salt = 'F3FAxVm33R' where login = 'admin'; 59acf18b94d7eb0694c61e60ce44c110c7a683ac6a8f09580d626f90f4a242000746579358d77dd9e570e83fa24faa88a8a6
[root@monitor1 grafana]# sqlite3 grafana.db SQLite version 3.7.17 2013-05-20 00:56:22 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> sqlite> sqlite> show databases; Error: near "show": syntax error sqlite> select * from user; 10adminadmin@localhostdf66a6815245dbd4b60e5c5fdd14b14aa7f5b4504ccf26ffc1baef459203a13a160d96783a088ed8915a4d07b8961ef2292aLZDEE9xnpKpMS90l93cH1102020-11-25 02:19:592021-03-15 07:21:0902021-03-19 06:23:440 sqlite> update user set password='59acf18b94d7eb0694c61e60ce44c110c7a683ac6a8f09580d626f90f4a242000746579358d77dd9e570e83fa24faa88a8a6',salt='F3FAxVm33R' where login='admin'; sqlite> sqlite> sqlite> .exit [root@monitor1 grafana]#
也可在sqlite3进入后,修改一个已知密码的账号为管理员,通过管理员web重置
1
udpate user set is_admin = 1 where login = '账号';
1 2 3 4 5 6
备注:
修改 password 后为"admin"字符经过grafana加密后的字符串 where login为指定账号,也可指定其他账号,将其密码先修改成为admin 在sqlite3 进入grafana后可通过 select * from user; 查询账号及密码信息 修改完成后无需重启服务,即可用新密码登录