Cannot login to Grafana

[cjmair]

When I try to login to Grafana, from the WLANPi GUI, I keep getting an invaild username or password error. Is there any way to reset to the default admin password ?

[cjmair]

Just incase it is of help to anyone else, this is how I changed the admin password in Grafana

I had to install the sqlite3 tool, using, sudo apt-get install sqlite3
Make sure the grafana-service is stopped
sudo systemctl stop grafana
Run the sqlite3 tool on the database using, sudo sqlite3 /var/lib/grafana/grafana.db
At the sqlite3> prompt do the following
.tables
select * from user;

You should now see a list of users, look for the one that has admin@localhost in it, in my case the username was wlanpi
so at the sqlite3> prompt enter
update user set password = '59acf18b94d7eb0694c61e60ce44c110c7a683ac6a8f09580d626f90f4a242000746579358d77dd9e570e83fa24faa88a8a6', salt = 'F3FAxVm33R' where login = 'wlanpi';
.exit

This should now have set the admin details to:
Username wlanpi
Password admin

Start grafana-server again
sudo systemctl start grafana-server
Now try using grafana from thw wlanpi GUI, it should ask you to change the default password