Hi Torkel,
Thank you for the suggestion. I have followed Sqlite documents to update ‘user’ table.
For those who are facing similar issue or want to access Grafana default database (Sqlite), following are the steps:
To access database:
root@grafanahost> sqlite3 /var/lib/grafana/grafana.db
To list Tables:
sqlite> .tables
To view schema of a table:
sqlite> .schema <tablename> Eg: sqlite> .schema user
To view table data:
sqlite> SELECT id, name, is_disabled FROM user;
To update a column:
sqlite> UPDATE <tablename> SET <columnName>=<value> WHERE <condition>; Eg: sqlite> UPDATE user SET is_disabled=0 WHERE id=1;
To exit:
sqlite> .exit