The MAC table type allows us to look up and query various bits of information about the network connection and network setup of our local machine.
Launch the
mysql
command-line client application and connect to thetest
database on our MariaDB server. If thetest
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;