How to reset admin password in Grafana

Grafana method to reset admin password: 1. View the Grafana configuration file and determine the path of [grafana.db]; 2. Use sqlites to modify the admin password; 3. Modify the specified user as the administrator.

The operating environment of this tutorial: Windows 7 system, Grafana 6.1.4 version, DELL G3 computer.

Grafana reset admin password method:

1) View the Grafana configuration file and determine the path of grafana.db

Configuration file path: /etc /grafana/grafana.ini

[paths]
;data = /var/lib/grafana
[database]
# For "sqlite3" only, path relative to data_path setting
;path = grafana.db

The complete path of grafana.db is known through the configuration file as follows:

/var/lib/grafana/grafana.db

Or you can directly search the path of grafana.db through the find tool of the shell:

find / -name "grafana.db"

2) Use sqlites to change the admin password

Open the database

[root@local]# sqlite3 /var/lib/grafana/grafana.db

Modify the password of the admin user in the user table

#查看数据库中包含的表
.tables
#查看user表内容
select * from user;
#重置admin用户的密码为默认admin
update user set password = '59acf18b94d7eb0694c61e60ce44c110c7a683ac6a8f09580d626f90f4a242000746579358d77dd9e570e83fa24faa88a8a6', salt = 'F3FAxVm33R' where login = 'admin';
#退出sqlite3
.exit

Okay, you can use admin, admin Logged in.

3) Modify the designated user to be the administrator

udpate user set is_admin = 1 where login = 'xxxx';

Related learning recommendations: Go language tutorial

The above is the detailed content of How to reset admin password in Grafana. For more information, please follow other related articles on the PHP Chinese website!