SQLITE_NOTADB: file is not a database with SQLCipher

[shangbinpan]

Environment

Knex version:3.1.0
Database + version: sqlite3
OS: windows

Bug

1. I have an encrypted SQLite database(by sqlcipher ). I have followed this documentation to generate an encrypted database using this Guideline. My Knex configuration goes here. When I created an encrypted database I set the password as "password".
   

2. Error message
   Error: select * from sqlite_master where type = 'table' and name = 'knex_migrations' - SQLITE_NOTADB: file is not a database

3. Reduced test code, for example in Github Repo. When I try to run the migrations it is throwing an error of file is not a database. According to the documentation I have set PRAGMA KEY = 'password'. Still, it is not working. Can anyone help me out here? Please share if you have any knowledge.