In this article, we want to teach you How To Install MariaDB 10.8 on Debian 11.
MariaDB is a fork of the MySQL database management system. The RDBMS offers data processing capabilities for both small and enterprise tasks.
This DBMS is an improved version of MySQL. It comes with numerous inbuilt powerful features and many usabilities, security, and performance improvements that you cannot find in MySQL.
In this guide, you will learn to install the latest version of MariaDB on your Debian 11.
How To Install MariaDB 10.8 on Debian 11
To complete this guide, you must log in to your server as a non-root user with sudo privileges. To do this, you can check our guide the Initial Server Setup with Debian 11.
Set up MariaDB 10.8 on Debian 11
First, you need to update and upgrade your local package index with the following command:
sudo apt update && sudo apt upgrade -y
Then, you need to install the dependencies with the following command:
sudo apt install curl software-properties-common dirmngr ca-certificates apt-transport-https -y
By default, MariaDB is not available on Debian 11. You can import it using the MariaDB bash script designed for Linux distributions such as Debian that are supported, given they are long-term releases. To do this, run the following command:
curl -LsS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version=10.8
Output # [info] Checking for script prerequisites. # [info] MariaDB Server version 10.8 is valid # [info] Repository file successfully written to /etc/apt/sources.list.d/mariadb.list # [info] Adding trusted package signing keys... # [info] Running apt-get update... # [info] Done adding trusted package signing keys
Now update your local package index again:
sudo apt update
At this point, you can use the following command to install MariaDB on your server:
sudo apt install mariadb-server mariadb-client -y
Verify your MariaDB installation by checking its version:
Output mariadb Ver 15.1 Distrib 10.8.3-MariaDB, for debian-linux-gnu (x86_64) using readline EditLine wrapper
Now you need to start and enable your MariaDB service to start on boot with the following commands:
# sudo systemctl start mariadb # sudo systemctl enable mariadb
Confirm that your MariaDB is active and running on Debian 11:
sudo systemctl status mariadb
Output ● mariadb.service - MariaDB 10.8.3 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: > Drop-In: /etc/systemd/system/mariadb.service.d └─migrated-from-my.cnf-settings.conf Active: active (running) since Thu 2022-06-23 05:38:06 EDT; 2min 54s ago Docs: man:mariadbd(8) https://mariadb.com/kb/en/library/systemd/ Main PID: 20547 (mariadbd) Status: "Taking your SQL requests now..." Tasks: 10 (limit: 2340) Memory: 208.1M CPU: 541ms CGroup: /system.slice/mariadb.service └─20547 /usr/sbin/mariadbd
How To Run MariaDB Security Script
At this point that you have MariaDB installed on your server you need to secure your MariaDB by running a security script:
Output Enter current password for root (enter for none): You already have your root account protected, so you can safely answer 'n'. Switch to unix_socket authentication [Y/n] n You already have your root account protected, so you can safely answer 'n'. Change the root password? [Y/n] Y New password: Re-enter new password: Remove anonymous users? [Y/n] Y Disallow root login remotely? [Y/n] Y Remove test database and access to it? [Y/n] Y Reload privilege tables now? [Y/n] Y All done! If you've completed all of the above steps, your MariaDB installation should now be secure. Thanks for using MariaDB!
Now you can use the command below to access your MariaDB shell on Debian 11:
sudo mysql -u root -p
Output Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 37 Server version: 10.8.3-MariaDB-1:10.8.3+maria~bullseye 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)]>
To upgrade your MariaDB you can use the command below:
mariadb-upgrade -u root -p
How To Uninstall MariaDB 10.8
If you no longer wish to use MariaDB and want to remove it in full, execute the following command:
sudo apt autoremove mariadb-server mariadb-client --purge -y
Note that this will delete MariaDB, including all database data.
To remove the bash script repository, use the following command:
sudo rm /etc/apt/sources.list.d/mariadb.list
This command will remove most of the unused dependencies in the MariaDB installation to help clean up your system.
For more information, you can visit the MariaDB Documentation page.
At this point, you learn to Install MariaDB 10.8 on Debian 11.
Hope you enjoy using it.
You may be interested in these articles on the orcacore website: