MariaDB Installation and Usage on Linux (Debian/Ubuntu)

This document explains how to install, secure, and use MariaDB on Linux systems

1. Install MariaDB

sudo apt update && sudo apt upgrade -y
sudo apt install mariadb-server

2. Start & Enable Service

sudo systemctl start mariadb sudo systemctl enable mariadb

3. Secure MariaDB

sudo mysql secure_installation

• Recommended answers: Yes to all security prompts.

4. Login to MariaDB

sudo mysql
or
mysql -u root -p

5. Check MariaDB Port

SHOW VARIABLES LIKE 'port';
Default: 3306

6. Create Database & User

CREATE DATABASE mydb;

CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON mydb.\* TO 'myuser'@'localhost'; FLUSH PRIVILEGES;

7. Basic Commands

SHOW DATABASES;
USE mydb;
SHOW TABLES;

8. Configuration Files

/etc/mysql/mariadb.conf.d/50-server.cnf

9. Restart MariaDB

sudo systemctl restart mariadb