How To Install MariaDB Database version 10.11.6 on Debian 12.xx

Installing MariaDB 10.11.6 on Debian 12.xx is a straightforward process that enhances your server’s database capabilities. MariaDB, a popular and reliable open-source relational database, offers robust performance and extensive features suitable for various applications. Whether you’re setting up a new server or upgrading your existing database system, this guide will walk you through the necessary steps to install and configure MariaDB 10.11.6 on Debian 12.xx, ensuring a secure and efficient database environment.

1. Update the Package Index: First, update the package index on your Debian system to make sure you have the latest information about available packages.

sudo apt update

2. Install MariaDB Server: Install the MariaDB database server package. By default, Debian’s repository includes MariaDB.

sudo apt install mariadb-server

3. Start and Enable MariaDB Service: After the installation is complete, start the MariaDB service and enable it to start on boot.

sudo systemctl start mariadb
sudo systemctl enable mariadb

4. Secure MariaDB Installation: Run the mysql_secure_installation script to improve the security of your MariaDB installation. This script will guide you through several steps, including setting a root password, removing anonymous users, disallowing remote root login, and removing the test database.

sudo mysql_secure_installation

5. Verify MariaDB Installation: Finally, verify that MariaDB is running and working correctly by logging in to the MariaDB shell.

sudo mysql -u root -p

After entering your root password, you should be at the MariaDB prompt:

root@debian:~# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 36
Server version: 10.11.6-MariaDB-0+deb12u1 Debian 12
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)]> 

By following this guide, you will successfully install MariaDB 10.11.6 on your Debian 12.xx system. This setup ensures that your database environment is robust, secure, and ready to support your applications. MariaDB’s powerful features and performance enhancements will help you manage your data effectively and reliably. Regular updates and security configurations will further protect your data, providing peace of mind and ensuring optimal performance for your database operations.