This code shows how to manage a local MariaDB server on local

mariadb-setup-on-manjaro.md

Setup for MariaDB / MySQL on Manjaro Linux

Follow these steps for a PHP-MariaDB project:

sudo pacman -S php mariadb mariadb-clients mariadb-libs
sudo mariadb-install-db
sudo systemctl enable mariadb.service
sudo systemctl start mariadb.service
sudo systemctl status mariadb.service
sudo mariadb-secure-installation (respond to the questions)
sudo mariadb

Source: Youtube

start the server and run as root with password prompt:

mariadb -u root -p