How to read settings.db

Preparations:

1. install busybox

- Download busybox
- Type 'adb remount'
- Type 'adb push busybox /system/xbin/busybox'
- Type 'adb shell chmod 4755 /system/xbin/busybox'
- Type 'adb shell /system/xbin/busybox --install -s /system/xbin/'

2. install sqlites

Start:

root@android:/ # adb root

root@android:/ # adb remonut

root@android:/ # adb shell

root@android:/ # cd data/data/com.android.providers.settings
root@android:/data/data/com.android.providers.settings # cd databases
root@android:/data/data/com.android.providers.settings/databases # chmod 777 settings.db
root@android:/data/data/com.android.providers.settings/databases #sqlite3 settings.db
SQLite version 3.7.11 2012-03-20 11:35:50
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .table
android_metadata   bookmarks          system           
bluetooth_devices  secure           
sqlite> select * from secure;
1|bluetooth_on|0
2|data_roaming|0
3|mobile_data|1
4|install_non_market_apps|0
5|location_providers_allowed|
6|assisted_gps_enabled|1
7|network_preference|1
8|usb_mass_storage_enabled|1
10|wifi_networks_available_notification_on|1
11|preferred_network_mode|0
12|cdma_cell_broadcast_sms|1
13|mock_location|0
16|mount_play_not_snd|1
17|mount_ums_autostart|0
18|mount_ums_prompt|1
19|mount_ums_notify_enabled|1
20|accessibility_script_injection|0
21|accessibility_web_content_key_bindings|0x13=0x01000100; 0x14=0x01010100; 0x15=0x02000001; 0x16=0x02010001; 0x200000013=0x02000601; 0x200000014=0x02010601; 0x200000015=0x03020101; 0x200000016=0x03010201; 0x200000023=0x02000301; 0x200000024=0x02010301; 0x200000037=0x03070201; 0x200000038=0x03000701:0x03010701:0x03020701;
22|long_press_timeout|500
23|touch_exploration_enabled|0
24|speak_password|0
25|accessibility_script_injection_url|https://ssl.gstatic.com/accessibility/javascript/android/AndroidVox_v1.js
26|lockscreen.disabled|0
28|netstats_enabled|1
29|wifi_max_dhcp_retry_count|9
30|wifi_watchdog_poor_network_test_enabled|0
31|sms_outgoing_check_max_count|100
32|sms_outgoing_check_interval_ms|3600000
33|android_id|a8f4309911b60f47
36|selected_input_method_subtype|-1
37|wifi_watchdog_on|1
39|voice_recognition_service|com.google.android.googlequicksearchbox/com.google.android.voicesearch.GoogleRecognitionService
41|throttle_reset_day|20
42|device_provisioned|1
49|tts_default_synth|com.google.android.tts
50|tts_default_locale|com.google.android.tts:eng-usa
51|backup_transport|com.google.android.backup/.BackupTransportService
53|allowed_geolocation_origins|
57|masterLocationPackagePrefixBlacklist|com.google.,com.semaphoremobile.zagat.android
58|serial_blacklist|827,864
59|send_action_app_error|1
60|web_autofill_query_url|http://android.clients.google.com/proxy/webautofill
61|dropbox:data_app_anr|disabled
62|dropbox:data_app_wtf|disabled
63|ssl_session_cache|file
64|pubkey_blacklist|5f3ab33d55007054bc5e3e5553cd8d8465d77c61,783333c9687df63377efceddd82efa9101913e8e
65|facelock_liveliness_recognition_threshold|2.2
66|facelock_detection_threshold|0.0
67|dropbox:data_app_crash|disabled
68|masterLocationPackagePrefixWhitelist|
69|lockscreen.options|enable_facelock
70|facelock_max_center_movement|10.0
71|locationPackagePrefixBlacklist|com.google.,com.semaphoremobile.zagat.android
72|backup_enabled|1
73|backup_auto_restore|0
89|development_settings_enabled|0
90|adb_enabled|1
92|wifi_on|1
125|input_methods_subtype_history|com.sonyericsson.textinput.chinese/.glue.InputMethodServiceGlue;-1:com.sonyericsson.textinput.uxp/.glue.InputMethodServiceGlue;-1
126|default_input_method|com.sonyericsson.textinput.uxp/.glue.InputMethodServiceGlue
127|enabled_input_methods|com.sonyericsson.textinput.uxp/.glue.InputMethodServiceGlue:com.sonyericsson.textinput.chinese/.glue.InputMethodServiceGlue:com.google.android.googlequicksearchbox/com.google.android.voicesearch.ime.VoiceInputMethodService
128|wifi_country_code|00
sqlite>