Create Database in MariaDB

Login into MariaDB

mysql -u root -p

Above 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;

Show all databases

show databases;

Select one database from the list

use testdb;

List tables inside the DB

show tables;