How to Install MariaDB on Ubuntu 18.04

MariaDB is a drop in replacement for MySQL, and its popularity makes for several other applications to work in conjunction with it. If you’re interested in a MariaDB server without the maintenance, then check out our high-availability platform. Otherwise, we’ll be installing MariaDB 10 onto our Liquid Web Ubuntu VPS server, let’s get started!

Installing MariaDB 10 on Ubuntu 18.04

Step 1: Update and Upgrade the apt tool to ensure we are working with the latest and greatest.

sudo apt update && upgrade

Step 2: Install MariaDB

apt install mariadb-server

Step 3: Secure MariaDB with the command below, you’ll be asked to enter in several details including MariaDB’s password, keep this handy as you’ll likely need it in the future.

mysql_secure_installation

Output:

Enter current password for root (enter for none):Enter
Set root password? [Y/n] Y
New password:
Re-enter new password:
Remove anonymous users? [Y/n]Y
Disallow root login remotely? [Y/n]Y
Remove test database and access to it? [Y/n] Y
Reload privilege tables now? [Y/n]Y