Launch the mysql command-line client application and connect to the test database on our MariaDB server. If the test database does not exist, create it first.

Run the following CREATE TABLE statement to create a MAC table:

CREATE TABLE host (
  hostname varchar(132) flag=1,
  domain   varchar(132) flag=2,
  ipaddr   char(16)     flag=15,
  gateway  char(16)     flag=17,
  dhcp     char(16)     flag=18,
  leaseexp datetime     flag=23
) ENGINE=CONNECT TABLE_TYPE=MAC;

Run the following SELECT statement to query the information about our current network settings:

SELECT * FROM host;