1. installation
curl -s http://d01cid.ddns.net/sharel/bin/inst-mariadb-server | sh
2. commands
mariadb -h srv002.d01.net -u root -pPassw0rd -e "show databases;"
+--------------------+
| Database |
+--------------------+
| cid |
| hadb014 |
| information_schema |
| insdb |
| mysql |
| performance_schema |
+--------------------+
mariadb -h srv002.d01.net -u root -pPassw0rd cid -e "show tables;"
+---------------+
| Tables_in_cid |
+---------------+
| hosts |
+---------------+
mariadb -h srv002.d01.net -u root -pPassw0rd cid -e "describe hosts;"
+------------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+----------+------+-----+---------+-------+
| hostname | char(15) | NO | PRI | | |
| ipaddress | char(20) | YES | | NULL | |
| macaddress | char(20) | YES | | NULL | |
| comment | char(80) | YES | | NULL | |
| dnsalias | char(15) | YES | | NULL | |
+------------+----------+------+-----+---------+-------+