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.
Enter current password for root (enter for none):Enter
Set root password? [Y/n] Y
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