How to Install MariaDB on Ubuntu 18.04

r00t August 6, 2018

Install MariaDB on Ubuntu 18.04

In this tutorial we are going to learn how to install MariaDB on Ubuntu 18.04. We will also install and configure its prerequisites. MariaDB is a drop-in replacement for MySQL. It is developed by former members of MySQL team who concerned that Oracle might turn MySQL into a closed-source product. Many Linux distributions and companies have migrated to MariaDB.

I recommend to use a minimal Ubuntu server setup as a basis for the tutorial, that can be a virtual or a root server image with an Ubuntu 18.04 Bionic Beaver minimal install from a web hosting company or you use our minimal server tutorial to install a server from scratch.

Install MariaDB on Ubuntu 18.04

Step 1. First, ensure your system and apt package lists are fully up-to-date by running the following:

apt-get update -y
apt-get upgrade -y

Step 2. Installing MariaDB on Ubuntu 18.04 Bionic Beaver.

Installing from Ubuntu default repository is a straightforward way, but this may have bit old version of MariaDB:

sudo apt install mariadb-server mariadb-client

After it’s installed, MariaDB server should be automatically started. Use systemctl to check its status:

systemctl status mariadb.service

With MariaDB installed, we must now turn to security. The next step will perform some basic hardening on the newly-installed database server:

mysql_secure_installation

Follow the prompts as below:

  • Would you like to setup VALIDATE PASSWORD plugin? press Enter here for No
  • Please set the password for root here. New password: Type a secure password here then press Enter
  • Re-enter new password: Re-type the secure password here then press Enter
  • Remove anonymous users? (Press y|Y for Yes, any other key for No) : press y and then Enter here
  • Disallow root login remotely? (Press y|Y for Yes, any other key for No) : press y and then Enter here
  • Remove test database and access to it? (Press y|Y for Yes, any other key for No) : press y and then Enter here
  • Reload privilege tables now? (Press y|Y for Yes, any other key for No) : press y and then Enter here

Once the database server is secured, check it’s installed version and login to the MariaDB command shell as follows:

mysql -V

To access the MariaDB instance, run the following command on the terminal.

mysql -u root -p

Congratulation’s! You have successfully install and configured MariaDB on your Ubuntu 18.04 LTS server. Thanks for using this tutorial for installing MariaDB data base on Ubuntu 18.04 LTS (Bionic Beaver) system.

Save

The Tags:

Leave a Comment

Comments are closed.