Hi, all.
I have lost my MB_ENCRYPTION_SECRET_KEY, and find a solution in documents.
Take care not to lose this key because you can’t decrypt connection details without it. If you lose (or change) the key, you’ll have to reset all of the connection details that have been encrypted with it in the Admin Panel.
So, my question is where's the connection details and how to reset them.
You would have to manually change information the application database from encrypted to clear text.
Specially everything in metabase_database.details to something like this:
execute one SQL script in the application database. this sql clear the database connection details.
UPDATE `metabase_database` set `details` = ''
After executing this script, you will lose all database connection details.
execute another SQL script in the application database.attention : this script will lose all setting in admin panel. I don’t know setting key meaning, so I truncate the table.
TRUNCATE `setting`
login and set all setting in admin panel
Click "Sync database schema now " and “Re-scan field values now” in database.