How to install MariaDB 10 on Ubuntu 16 & Debian 8

Introduction

MariaDB is a backward compatible, drop-in replacement of the MySQL Database Server and it’s led by MySQL developers. MariaDB maintains high compatibility with MySQL, It’s very smooth and lightweight. It includes all major open source storage engines.

We are assuming that you have root permission, otherwise, you may start commands with “sudo”.

Install MariaDB on Debian 8

If you want to install the latest stable version (10.1) of MariaDB you can not use official repositories, so you have to add MariaDB repository first:

apt-get install software-properties-common

apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db

add-apt-repository 'deb [arch=amd64,i386,ppc64el] http://ftp.osuosl.org/pub/mariadb/repo/10.1/debian jessie main'

Once the key is imported and the repository added you can install MariaDB with:

apt-get update

apt-get install mariadb-server mariadb-client

When the installation is finished, you can start and enable your service:

systemctl start mariadb
systemctl enable mariadb
systemctl status mariadb

Install MariaDB on Ubuntu 16

Just like Debian 8 you have to add the MariaDB repository first:

apt-get install software-properties-common

apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8

add-apt-repository 'deb [arch=amd64,i386,ppc64el http://ftp.osuosl.org/pub/mariadb/repo/10.1/ubuntu xenial main'

Now you can install MariaDB 10.1 easily with:

apt-get update

apt-get install mariadb-server mariadb-client

When it’s completed, you can start and enable your service:

systemctl start mariadb
systemctl enable mariadb
systemctl status mariadb

 
Check out MariaDB official website for more information and news!