Server Install

aptitude install mariadb-server

Root Password

Wizard

mysql_secure_installation

Manual

systemctl stop mariadb
mysqld_safe --skip-grant-tables &
mysql
UPDATE mysql.user SET Password=PASSWORD('123456') WHERE User='root';
FLUSH PRIVILEGES; exit;
mysqladmin -u root -p shutdown
systemctl start mariadb

Client Install

aptitude install mariadb-client

Commads

root@server:~# mysql -u root -p
MariaDB [(none)]> show databases;
MariaDB [(none)]> use db_name;
MariaDB [(none)]> select database(); #Show selected database
MariaDB [(none)]> show tables;
MariaDB [(none)]> describe table_name; #show fields from a table;