Information
The binlog_encryption system variable may be used to configure encryption of the binary and relay logs. This may be configured to ON even if binary logging is not enabled in order to encrypt relay log files.
Rationale:
The database, and thus the binary and relay logs, may contain sensitive information. Encrypting the binary and relay logs protects all data stored in these logs from internal and external threats.
Solution
To remediate misconfiguration, run this command:
SET GLOBAL binlog_encryption=ON;
If you receive the error message below, you need to install keyring. For instructions see Section 6.4.4, 'The MySQL Keyring' in the MySQL documentation.
ERROR 3794 (HY000): Unable to recover binlog encryption master key, please check if keyring plugin is loaded.
Default Value:
The default for binlog_encryption is OFF.