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
