Installing MariaDB on Ubuntu 16.04


MariaDB is a fork of the very popular MySQL database management system; it is now considered as a full drop-in replacement for MySQL.

Installing MariaDB on Ubuntu 16.04
Installing MariaDB on Ubuntu 16.04

Installing MariaDB on Ubuntu 16.04

You can install MariaDB in two ways, using either Ubuntu repository or Official MariaDB mirror.

Installing MariaDB from Ubuntu Repository:

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

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

Installing MariaDB from Official Mirror:

MariaDB offers an official installer package for MariaDB; you can choose any one of mirrors from the MariaDB downloads page to download it.

Run below commands in the terminal to configure MariaDB repository straight away.

sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys --keyserver hkp:// 0xF1656F24C74CD1D8
sudo add-apt-repository 'deb [arch=amd64,i386,ppc64el] xenial main'


If you don’t wish to use the above commands, you can manually create and update the MariaDB repository file under /etc/apt/sources.list.d/.

sudo nano /etc/apt/sources.list.d/mariadb.list

Place the following entries into the above file.

# MariaDB 10.1 repository list - created 2016-06-18 06:14 UTC
deb [arch=amd64,i386] xenial main
deb-src xenial main

Now, install MariaDB using the following command.

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

Secure MariaDB installation by running mysql_secure_installation.

sudo mysql_secure_installation

Accessing MariaDB:

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

mysql -u root -p

Enter the password of root user that you have set during the installation when prompted.

Once after entering the password, you would get a MariaDB shell.

raj@server:~$ mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 10
Server version: 10.1.14-MariaDB-1~xenial binary distribution

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

Managing MaraDB:

In case if you want to start / stop the MariaDB; use the following command.

sudo systemctl start mariadb
sudo systemctl stop mariadb

Run the following command in the terminal to check whether MariaDB is running.

sudo systemctl status mariadb

That’s All.

You might also like

  • 增达信购QQ172607715







  • QQ403867









  • JH

    Thanks! It’s been very helpful.