Title: database SQLCipher key location
Last modified: April 1, 2021

---

# database SQLCipher key location

 *  [runcit](https://wordpress.org/support/users/runcit/)
 * (@runcit)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/database-sqlcipher-key-location/)
 * Hi
 * I have a digitalocean droplet, basically a vm running ubuntu 20.04 with wordpress.
   I entered ssh and downloaded the wordpress database by using mysqldump -u root-
   p wordpress > db.sql and downloaded it using sftp into my local machine. But 
   then I cannot open the database using db browser for sqlite application as it
   asks me for SQLCipher encryption key as in picture. What’s interesting is that
   I can open the database file using notepad editor and the words are not gibberish/
   encrypted. I don’t know if here is the right place to ask this but I gladly thank
   you for all your help.
 * [https://ibb.co/9rKVHnX](https://ibb.co/9rKVHnX) – the prompt in db browser
    
   [https://ibb.co/94sWZwV](https://ibb.co/94sWZwV) – can just open it in editor
   and looks unencrypted
 * Thanks.

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Moderator [Yui](https://wordpress.org/support/users/fierevere/)
 * (@fierevere)
 * 永子
 * [5 years, 2 months ago](https://wordpress.org/support/topic/database-sqlcipher-key-location/#post-14262425)
 * MySQL dumps are completely different format with SQLite database format.
 * You can view them as plain text in any text viewer or editor, but to see it as
   database you will have to import it into a running MySQL database server instance
   and view them in PHPMyAdmin or other application which can access MySQL
 *  Thread Starter [runcit](https://wordpress.org/support/users/runcit/)
 * (@runcit)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/database-sqlcipher-key-location/#post-14263122)
 * Thanks a lot Yui.
 * I will proceed with the suggestions given.
 *  Thread Starter [runcit](https://wordpress.org/support/users/runcit/)
 * (@runcit)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/database-sqlcipher-key-location/#post-14265228)
 * I managed to view the database and its tables, by following the guide as suggested
   by Yui.
 * I created an empty database in MySQL and from there, I imported the dump file
   into the database. At first there is an error then I searched around an tried
   the solution by Rangel at [https://stackoverflow.com/questions/29916610/1273-unknown-collation-utf8mb4-unicode-ci-cpanel](https://stackoverflow.com/questions/29916610/1273-unknown-collation-utf8mb4-unicode-ci-cpanel),
   and it works right now!
 * Thanks Yui and have a nice day!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘database SQLCipher key location’ is closed to new replies.

 * In: [Everything else WordPress](https://wordpress.org/support/forum/miscellaneous/)
 * 3 replies
 * 2 participants
 * Last reply from: [runcit](https://wordpress.org/support/users/runcit/)
 * Last activity: [5 years, 2 months ago](https://wordpress.org/support/topic/database-sqlcipher-key-location/#post-14265228)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics