windowspowershellsqlitecmdcommand-line

SQLite3 Not Showing Prompt (sqlite>), Unable to See What I'm Typing


I'm using SQLite3 on Windows, but when I open my database with sqlite3 mydatabase.db, the usual sqlite> prompt does not appear, and I can't see what I'm typing. Commands still execute, but it's difficult to work without visibility. I've tried enabling .echo on, setting .prompt sqlite>, and checking .show settings, but nothing restores the prompt. This happens in both CMD and PowerShell. How can I fix this issue and make my input visible again?

  1. Running sqlite3 mydatabase.db in both CMD and PowerShell—expected to see the sqlite\> prompt, but it doesn’t appear.

  2. Enabling .echo on expected to see my commands as I type, but it didn’t help.

  3. Checking .show settings everything seems normal, but the prompt is still missing.

enter image description here


Solution

  • This issue happens because my system chooses the first matching executable found in the PATH environment variable. In your case, MSYS2's SQLite3 (C:\msys64\ucrt64\bin) is higher in priority than your intended installation (F:\Installed programes\sqlite3\)