Mariadb encryption

by Pooja   Last Updated August 14, 2019 07:06 AM

I have a requirement to encrypt certain column of DB tables. Going through the links, have followed the below steps:

In /etc/my.cnf

[mysqld]
plugin-load-add = file_key_management
file_key_management_filename = /etc/mysql/encryption/keyfile.enc
file_key_management_filekey = /etc/mysql/encryption/keyfile.key
file_key_management_encryption_algorithm = AES_CTR

Restarted the mysql

service mysqld restart

But i m unable to see the plugin added.

Executed the following mysql commands:

MariaDB [TestEncr]> CREATE TABLE table1 (col1 INT NOT NULL PRIMARY KEY, secret CHAR(200)) ENGINE=InnoDB ENCRYPTED=YES;
ERROR 1005 (HY000): Can't create table `TestEncr`.`table1` (errno: 140 "Wrong create options")

MariaDB [TestEncr]> install soname 'file_key_management';
ERROR 2 (HY000): Cannot decrypt /etc/mysql/encryption/keyfile.enc. Wrong key?

Unable to understand what is wrong???

Tags : mariadb-10.2


Related Questions


Updated October 24, 2018 17:06 PM

Updated August 17, 2017 10:06 AM

Updated May 08, 2019 09:06 AM

Updated October 11, 2016 09:02 AM

Updated May 03, 2017 19:06 PM