This guide will walk you through the process of installing MariaDB on Ubuntu Linux, setting a password, and importing a database from a SQL file. MariaDB is a popular open-source relational database management system, and it's commonly used in web development environments.

Before installing any new software, it's essential to update the package lists to ensure you're getting the latest versions available.

sudo apt update
sudo apt install mariadb-server
sudo systemctl start mariadb
sudo systemctl enable mariadb
sudo mysql_secure_installation
sudo mysql -u root -p

CREATE DATABASE springbackend;
GRANT ALL PRIVILEGES ON springbackend.* TO 'username'@'localhost' IDENTIFIED BY 'your_password';

sudo mysql -u username -p springbackend < springbackend.sql

sudo mysql -u root -p

show databases;
use springbackend;
show tables;
select * from tbl_workers;