grafana密码忘记

说明：K8S部署的grafana

1.找到grafana.db 和sqlite3位置

 

2.修改密码

 /usr/bin/sqlite3 /data/grafana/grafana.db

.tables 查看表

select * from user;  查看用户

update user set password = '59acf18b94d7eb0694c61e60ce44c110c7a683ac6a8f09580d626f90f4a242000746579358d77dd9e570e83fa24faa88a8a6', salt = 'F3FAxVm33R' where login = 'admin'; 密码修改

.exit 退出　　

sqlite> select * from user;
1|0|admin|admin@localhost||64fbb9f932597faf4dbdfa364c9dfabcb3e44b3bc0c02d5ec1bb0cb751e3e73e8010ed37e63a8ed03ad9d49880f4cfd4e2d1|F3FAxVm33R|GFL40m4FGM||1|1|0||2024-01-22 06:20:26|2024-01-25 03:28:07|0|2024-01-25 06:10:20|0|0
sqlite> update user set password = '59acf18b94d7eb0694c61e60ce44c110c7a683ac6a8f09580d626f90f4a242000746579358d77dd9e570e83fa24faa88a8a6', salt = 'F3FAxVm33R' where login = 'admin'; 
sqlite> .exit

 3.登陆网页 账号密码： admin/admin