Today, We will discuss how to install MariaDB on Ubuntu 18.04. The MariaDB is a database server and it's an open-source relational database management system, so you can download and use it as much as you want free of charge. There are two ways to install MariaDB. (1) Install from MariaDB mirror and (2) Install from repository

(1) Install from MariaDB mirror

First, find the MariaDB repository file from the official website. after then import the package key and added the repository package on your system.

Ubuntu 18.04 LTS "bionic"

sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://mirror.edatel.net.co/mariadb/repo/10.4/ubuntu bionic main'

Ubuntu 16.04 LTS "xenial"

sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
sudo add-apt-repository 'deb [arch=amd64,arm64,i386,ppc64el] http://mirror.edatel.net.co/mariadb/repo/10.4/ubuntu xenial main'

Install from repository

The MariaDB Installing from the Ubuntu default repository is a straightforward way. but you if you want to use below the following command then will be installed the old version of MariaDB.

sudo apt-get update
sudo apt-get install mariadb-server mariadb-client

During installation, we will ask you root user password and confirmation password.

Mysql Secure Installation

sudo mysql_secure_installation

Above command run in the command prompt, it will ask you following configuration.

set root password (if not set in the configuration step above).
disable remote root login
remove test database
remove anonymous users and
reload privileges

After complete installation, we will check a MariaDB connection using the below command.

mysql -u root -p

If you want to know the server status or you want to start or stop server then you can do using the below command.

sudo systemctl start mariadb
sudo systemctl enable mariadb
sudo systemctl status mariadb