How to install mariadb on your Debian 12/13 server

 It has been a while since my last tinkering around VM machines on my laptop. 

Today I just had little bit of time to install new Debian 13 server to play around with databases and bash scripting.

Prerequisites

Before you begin, make sure you have:

•     A Debian 12/13 system with root or sudo access.
•     An SSH client to connect to your server.
•     A stable internet connection.

 Installing MariaDB on Debian 13

Follow these steps to install and configure MariaDB on your Debian server:

1. Update package index

sudo apt update

2. Install MariaDB server

sudo apt install mariadb-server -y

3. Start MariaDB service

sudo systemctl start mariadb
 

4. Enable MariaDB to start on boot

sudo systemctl enable mariadb

5. Run the secure installation script

sudo mysql_secure_installation

Installation will prompt to set a root password, remove anonymous users, disallow root login remotely and remove the test database. Follow the prompts and answer ‘Y’ or ‘N’ as needed.

6. (Optional) Log in to MariaDB to test

sudo mariadb -u root -p
 

7. (Optional) Check MariaDB service status

sudo systemctl status mariadb

Debian Server 12 - adding user to sudoers

sudo is a command-line utility that allows trusted users to run commands as another user, by default root. This tutorial shows two ways to grant sudo privileges to a user.

1. Step -On my VM Debian Server I had to install the sudo utility first as root user I ran

   apt install sudo

2. Step is to add user you sudoers file. To do so you need to as root user run visudo and at the end of file add

   username ALL=(ALL) NOPASSWD:ALL

3. Step is to add user to the sudo group, again as root you run

   usermod -aG sudo username

4. Step you can now check if you can use sudo command as user you created before and if you followed those steps you should be able to run commands as trusted user