Why does the SQLite 3 command using the Android ADB shell return “permission denied”?

Question

Specifically, I was trying to use the sqlite3 command with the ADB shell to run some queries on the database of the Android application I'm building.

I kept getting "sqlite3: permission denied". I'm developing on a Nexus One that I purchased from Google. Does my phone need to be rooted or something?

$ sqlite3 /data/data/com.moodme.android/databases/moodme.db
sqlite3 /data/data/com.moodme.android/databases/moodme.db
sqlite3: permission denied

Answer 1

The files are read protected. You need to root your phone or use the emulator.