Resetting admin password
I have the SQL needed to reset my admin password to a known bcrypt hash value, but I can't get it to work.
I'm running the SQLitebrowser as Docker on my unRaid 7.3.1, but when I try to go to the directory for my appdata, the mnt directory shows as empty.
I've tried running the SQLite Browser from my Windows PC using the shared folder for AppData. Even though I have the share set as Public, I can't save the changes as I get an error message that states "Error changing data: unable to open database file".
I've tried opening the console from my unRaid dashboard. I can change directories to /mnt/user/appdata/grafana to see my grafana.db file. I then run the SQL
UPDATE user
SET password = 'new_hashed_password'
WHERE login = 'admin';
That seems to work (no error message). I then try select * from user, but the new hashed password is not saved.
Can someone tell me what I should be doing, or what I'm doing wrong with my selected avenues of change>