|
When reading Encrypting Data for InnoDB / XtraDB you may be lead to believe that if you are using innodb_encrypt_tables=FORCE then you would be unable to access any InnoDB tables that are storing data in plaintext.
| Option |
Description |
| OFF |
Disables table encryption |
| ON |
Enables table encryption, but allows unencrypted tables |
| FORCE |
Enables table encryption, but doesn't allow unencrypted tables |
The variable documentation states it differently:
Description: Encrypt all tables in the storage engine. See Table and Tablespace Encryption. The FORCE option (from 10.1.4) means that XtraDB/InnoDB will refuse to create unencrypted tables (CREATE TABLE ... ENCRYPTED=NO will fail).
|
This could lead to someone having the wrong impression about using FORCE
|