yes u can reset the admin password of grafana, i had the same thing, i did reset it.
I could not remember my password after my accident…
I think at the release of 2023.11 or 12 frenck stated that longterm history data is always stored hourly in the database (temp sensors etc), no matter if u purge the data.
Before you could not retrieve that data, now you can, u need to look up those live streams where they explain.
Also they stated people like me who use MariaDB is not needed at all…
Yes ot use Influx WIth grafana u can just query your own Hass DB.
For me personally InfluxDB is great when using it on an other system with more HD space, same with Grafana, as i record every 10 seconds needed data.
After my project is complete i will stop using data every 10 seconds but will go for hourly.
I do also record every change to google spread sheet, for example HUMIDITY,TEMPERATURE, and energy totals etc, u can also import them to Grafana without using InfluxDB.
With all those sensors i have i could record 1 year and 1 month in a spreadsheet of many many rows and it was only 17mb…
After that i duplicated a new spreadsheet and deleted the data and started over.