(Last Updated On: December 26, 2018)

In this tutorial, I’ll show you how you can install MariaDB 10.4 on Debian 9 Stretch and Debian 8 Jessie. MariaDB is an open source database server released under the General Public License version 2.  It is a community-developed fork of the MySQL relational database management system built to be fast, robust and with more features.

For CentOS 7  check: How to Install MariaDB 10.4 on CentOS 7

For Ubuntu 18.04 / Ubuntu 16.04 use: How to Install MariaDB 10.4 on Ubuntu 18.04 / Ubuntu 16.04

How to Install MariaDB 10.4 on Debian 9 / Debian 8

Before you install MariaDB 10.4 on Debian 9 / Debian 8, you need to add official MariaDB upstream repositories which contain binary packages for MariaDB.

Step 1: Install dependency packages

sudo apt -y install software-properties-common dirmngr

Step 2: Add MariaDB 10.4 repository and Import GPG key

For Debian 9:

sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xF1656F24C74CD1D8
sudo add-apt-repository 'deb [arch=amd64,i386,ppc64el] http://mirror.zol.co.zw/mariadb/repo/10.4/debian stretch main'

For Debian 8:

sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
sudo add-apt-repository 'deb [arch=amd64,i386,ppc64el] http://mirror.zol.co.zw/mariadb/repo/10.4/debian jessie main'

Step 3: Install MariaDB Database Server

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

sudo apt update && sudo apt install mariadb-server mariadb-client

When prompted to set the root password, provide the password.

Confirm root password to set.

When done, it will finish installation and start mysql service. You can check status using:

$ sudo  systemctl status mysql
● mariadb.service - MariaDB 10.3.8 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Fri 2018-08-10 10:38:08 UTC; 34min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Main PID: 5468 (mysqld)
Status: "Taking your SQL requests now..."
CGroup: /system.slice/mariadb.service
└─5468 /usr/sbin/mysqld

You can log in as well to check your database version:

$ 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.4.1-MariaDB-1:10.4.1+maria~stretch-log mariadb.org binary distribution

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

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

MariaDB [(none)]> SELECT VERSION();
+-------------------------------------------+
| VERSION()                                 |
+-------------------------------------------+
| 10.4.1-MariaDB-1:10.4.1+maria~stretch-log |
+-------------------------------------------+
1 row in set (0.001 sec)
MariaDB [(none)]> QUIT
Bye

Step 4: Install Desktop Database Management Tool

If working with MySQL command line is not your thing, then consider installing a Database Tool to help you. Check out our guide below:

Install and Configure DBeaver on Ubuntu 18.04 / Ubuntu 16.04 / Debian 9

That’s all. Enjoy running MariaDB 10.4 on Debian 9 / Debian 8 server.