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

How to change default ssh login banner

To create a cool ASCII art banner for your server, first start off by going here:

ASCII art creator/

To change the message displayed before login, edit /etc/ssh/sshd_config :

sudo vim /etc/ssh/sshd_config

and add (or uncomment) the line:

Banner /etc/banner

/etc/banner can be whatever file you want. Then edit /etc/banner

sudo vim /etc/banner

You’ll probably need to restart sshd before your changes take effect:

sudo /etc/init.d/ssh restart

To change the message displayed after login, edit /etc/motd :

sudo vim /etc/motd

and enter the message you want to display.

Linux system and Hardware details via command line

Uname command

Basic information can be access with command uname. Which is short for unix name.

1. Linux Kernel Name

uname -s

2. Linux Kernel Release

uname -r

3. Linux Kernel Version

uname -v

4. Network Node Hostname

uname -n

5. Machine Hardware Architecture

uname --m

6. Processor Type

uname -p

7. Hardware Platform

uname -i

8. Operating System information

uname -o

9. Displaying All Information of Uname Command

uname -a

CPU Information with lscpu command:

lscpu

Block Device Information with lsblk

lsblk

More detailed information for all devices:

lsblk -a

USB Device Info with lsusb

lsusb

More detailed information on each device:

lsusb -v