I want to use encryption at rest for my hosted databases. I found some documentation on how to encrypt my databases, and that went fine. But when I try to host my encrypted databases, they fail to open. The log says "incorrect encryption password", which makes sense, because I was never given an opportunity to specify the encryption password when I tried to open them.
How do you specify an encryption password that the server can use when hosting encrypted databases? And is there some way to store this securely (not plaintext) on the server so that it can open databases automatically on startup?