[SQLITE 101] SQLITE 101 #sqlite #101 #gogs #reset #admin

SQLITE-101.md

SQLITE 101

• Connect to specific database: sqlite3 this.db

• Liste databases: .databases

• Reset admin (create new user and recover password and salt to overwrite admin ones)

sqlite> SELECT name,passwd,salt FROM user WHERE name='testuser';
testuser|6ed26719fe986fea3a9f997ab3c7853ac64ce5d0f5f278dbb571a50a2a2509a4540dd353506cf1f4b9b6211b04faa1a1fc28|97ZaYtIZwM

sqlite> UPDATE user
...> SET passwd='6ed26719fe986fea3a9f997ab3c7853ac64ce5d0f5f278dbb571a50a2a2509a4540dd353506cf1f4b9b6211b04faa1a1fc28',
   ...> salt='97ZaYtIZwM'
   ...> WHERE name='user';