Grafana admin log in failing after upgrade

Grafana version: 7.0.5
RHEL 7.5

When I try to log into grafana with the admin credentials (admin:admin) I get the error ‘invalid username or password’.
I’ve tried root:admin, admin:root, root:root.
in /etc/grafana/grafana.ini & /usr/share/grafana/conf/defaults.ini
[security]
admin_user = admin
admin_password = admin

I’ve also set;
grafana-cli --homepath “/usr/share/grafana” --config "/usr/share/grafana/conf/defaults.ini’ admin reset-admin-password admin

and

grafana-cli --homepath “/usr/share/grafana” --config "/etc/grafana/grafana.ini’ admin reset-admin-password admin

I’ve also tried changing the password using sqlite3 /var/lib/grafana/granana.db
Also changed in both the .ini files, the location of the DB to be direct & left as default

With no luck.

If I use an account which I set up before my upgrade;

/var/log/grafana/grafana.log
error msg= ‘Error while signing in user’ error= 'failed to create auth token: attempt to write to a readonly database"

So the grafana.db were wr/r/r so I created a backup of the db, then changed to 777 to see if that would at least work. But no luck, I also deleted the copy of the db but same error.

and finally I’ve tried reinstalling Grafana (I also restarted grafana after each change)

Any ideas?

Hey,
Could you make sure that the directory containing your db file is writable for the user?

Also, may be you’ll find this SO answer helpful.

Hey rvrs - unfortunately neither of those worked. Still having drama with;
error msg= ‘Error while signing in user’ error= 'failed to create auth token: attempt to write to a readonly database"

I gave up trying to keep the old database and wiped everything grafana related and started again. Issue resolved =)