------------------------------------------------------

mysql> use AUDIT

Database changed

mysql> CREATE TABLE audit_trail(

    -> `timestamp` VARCHAR(255),

    -> `serverhost` VARCHAR(255),

    -> `username` VARCHAR(255),

    -> `host` VARCHAR(255),

    -> `connectionid` VARCHAR(255),

    -> `queryid` VARCHAR(255),

    -> `operation` VARCHAR(255),

    -> `database` VARCHAR(255),

    -> `object` VARCHAR(255),

    -> `retcode` VARCHAR(255))

    -> engine=CONNECT table_type=CSV file_name='/usr/local/mysql2/mariadb-audit.log'

    -> sep_char=',' quoted=1;

ERROR 1286 (42000): Unknown storage engine 'CONNECT'

mysql>

mysql> show plugins;

+-------------------------------+----------+--------------------+-----------------+---------+

| Name                          | Status   | Type               | Library         | License |

+-------------------------------+----------+--------------------+-----------------+---------+

| binlog                        | ACTIVE   | STORAGE ENGINE     | NULL            | GPL     |

| mysql_native_password         | ACTIVE   | AUTHENTICATION     | NULL            | GPL     |

| mysql_old_password            | ACTIVE   | AUTHENTICATION     | NULL            | GPL     |

...

..

..

| SEQUENCE                      | ACTIVE   | STORAGE ENGINE     | NULL            | GPL     |

| user_variables                | ACTIVE   | INFORMATION SCHEMA | NULL            | GPL     |

| FEEDBACK                      | DISABLED | INFORMATION SCHEMA | NULL            | GPL     |

| partition                     | ACTIVE   | STORAGE ENGINE     | NULL            | GPL     |

| SERVER_AUDIT                  | ACTIVE   | AUDIT              | server_audit.so | GPL     |

| CONNECT                       | ACTIVE   | STORAGE ENGINE     | ha_connect.so   | GPL     |

+-------------------------------+----------+--------------------+-----------------+---------+

54 rows in set (0.00 sec)

mysql>

mysql> show engines;

+--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+

| Engine             | Support | Comment                                                                          | Transactions | XA   | Savepoints |

+--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+

| CSV                | YES     | CSV storage engine                                                               | NO           | NO   | NO         |

| MRG_MyISAM         | YES     | Collection of identical MyISAM tables                                            | NO           | NO   | NO         |

| MyISAM             | YES     | MyISAM storage engine                                                            | NO           | NO   | NO         |

| SEQUENCE           | YES     | Generated tables filled with sequential values                                   | YES          | NO   | YES        |

| CONNECT            | YES     | Management of External Data (SQL/NOSQL/MED), including many file formats         | NO           | NO   | NO         |

| PERFORMANCE_SCHEMA | YES     | Performance Schema                                                               | NO           | NO   | NO         |

| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                        | NO           | NO   | NO         |

| Aria               | YES     | Crash-safe tables with MyISAM heritage                                           | NO           | NO   | NO         |

| InnoDB             | DEFAULT | Supports transactions, row-level locking, foreign keys and encryption for tables | YES          | YES  | YES        |

+--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+

9 rows in set (0.00 sec)

mysql>

------------------------------------------------------