mysql> select table_schema, table_name, create_options from information_schema.tables where create_options like '%encryption%'; +--------------+------------+----------------+ | TABLE_SCHEMA | TABLE_NAME | CREATE_OPTIONS | +--------------+------------+----------------+ | test | testTB | ENCRYPTION="Y" | +--------------+------------+----------------+ ** mysql> select plugin_name, plugin_status from information_schema.plugins where plugin_name like 'keyring%'; +--------------+---------------+ | plugin_name | plugin_status | +--------------+---------------+ | keyring_file | ACTIVE | +--------------+---------------+ 1 row in set (0.00 sec)