Geoff Montee (Inactive) added a comment - 2018-12-20 19:33 I added a note about this to the documentation: https://mariadb.com/kb/en/library/encrypting-data-for-aria/#enabling-encryption-for-manually-encrypted-tables

Federico Razzoli added a comment - 2019-03-19 08:12 Will it be possible to encrypt Aria tables in mysql database?

Geoff Montee (Inactive) added a comment - 2019-03-19 18:39 Hi f_razzoli , Yeah, you just can't do it by setting ENCRYPTED=YES. You have to globally enable encryption for all Aria tables, and then explicitly rebuild the table. See the following documentation section: https://mariadb.com/kb/en/library/aria-enabling-encryption/#encrypting-existing-tables e.g.: 1.) Enable Aria encryption: MariaDB [(none)]> SET GLOBAL aria_encrypt_tables=ON; Query OK, 0 rows affected (0.000 sec) 2.) Rebuild the table that you want to ensure is encrypted: MariaDB [(none)]> ALTER TABLE mysql.global_priv ENGINE=Aria; Query OK, 7 rows affected (0.017 sec) Records: 7 Duplicates: 0 Warnings: 0 3.) Confirm that the table is encrypted. See the following documentation section for that: https://mariadb.com/kb/en/library/aria-encryption-overview/#determining-whether-a-table-is-encrypted e.g.: $ sudo strings /var/lib/mysql/mysql/global_priv.MAD | grep "root"