Login into MariaDB
mysql -u root -pAbove command tells the system you will login as “root” and for that you will provide the password (previously configured during Maria DB installation, check the here).
Creation of a database
The database you are going to create is an empty database, it has no tables inside, exactly what you need if you are planning to use it with WordPress.
CREATE DATABASE testdb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;Collation: utf8mb4_unicode_ci
utf8mb4_unicode_ci
Show all databases
show databases;
Select one database from the list
use testdb;
List tables inside the DB
show tables;