::CONFIG::

[mysqld] 
port=10221
socket=10221.sock
basedir=/home/myharem/instances/10221
server_id=10221
user=mysql
innodb_file_per_table
log_bin
log_error=error.10221.log
binlog_format=row


plugin_load_add = file_key_management
file_key_management_filename = /home/myharem/instances/10221/keys.enc
file_key_management_filekey = FILE:/home/myharem/instances/10221/.key
file_key_management_encryption_algorithm = aes_cbc
encrypt_binlog=ON
innodb_default_encryption_key_id=3






::SQL::

SET GLOBAL innodb_encrypt_tables=ON;

SET SESSION innodb_default_encryption_key_id=3;

CREATE TABLE tab1 (
   id int PRIMARY KEY,
   str varchar(50)
);

insert into tab1 values (1,'row 001');
insert into tab1 values (2,'row 002');
insert into tab1 values (3,'row 003');