How To Install MariaDB On Debian 9?

Embracing MariaDB on Debian 9

Nestled within the realm of databases lies the potent and versatile MariaDB, a beacon of reliability and efficiency. If you’re venturing into the landscape of Debian 9 and seeking the prowess of MariaDB to manage your data, fear not the installation process, for here lies a comprehensive guide to walk you through this journey with finesse and clarity.

Unveiling MariaDB:

Understanding the Foundation

Before delving into the installation process, let’s acquaint ourselves with MariaDB. Born as a fork of MySQL, this open-source relational database management system (RDBMS) boasts enhanced features, performance optimizations, and robustness. Designed with compatibility in mind, MariaDB inherits MySQL’s structure while augmenting it with added functionalities and improvements, rendering it a favored choice for diverse applications. Its modular design, support for multiple storage engines, and active community contribute to its allure.

Preparation Phase:

Prerequisites and Initial Steps

Firstly, ensure your Debian 9 system is up-to-date by executing the following commands in the terminal:

sudo apt update
sudo apt upgrade

This ensures your system is primed and ready to welcome MariaDB without any compatibility hiccups. Following this, proceed to install the essential package for managing software repositories:

sudo apt install software-properties-common dirmngr

Securing the repository keyring is paramount before adding the MariaDB repository to your Debian system. Execute the commands below to fetch the repository’s key:

sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xF1656F24C74CD1D8

Repository Configuration:

Adding MariaDB’s Repository

With the key securely in place, the next step involves integrating the MariaDB repository into your system. This can be achieved by executing the following commands:

sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://mariadb.mirror.globo.tech/repo/10.6/debian stretch main'

This ensures that your Debian 9 system is synchronized with the MariaDB repository, facilitating seamless access to its suite of packages and updates.

MariaDB Installation:

The Core Implementation

The moment of truth arrives as we initiate the installation of MariaDB. Execute the following command in your terminal to start the installation process:

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

This command prompts the system to fetch and install both the server and client components of MariaDB, empowering your system with the database management capabilities you seek.

Post-Installation:

Securing and Configuring MariaDB

Securing your freshly installed MariaDB instance is pivotal. Execute the following command to kickstart the security script that fortifies your database:

sudo mysql_secure_installation

This script aids in setting a root password, removing anonymous users, disallowing remote root login, and purging the test database to enhance security.