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
 mysql -h <rds endpoint> -u admin -p 

#sudo mysql_secure_installation
#sudo mysql -u root -p

CREATE DATABASE springbackend;
GRANT ALL PRIVILEGES ON springbackend.* TO 'username'@'localhost' IDENTIFIED BY 'your_password';
--------------------------------------or
CREATE USER 'admin'@'localhost' IDENTIFIED BY 'your_password';
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

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

sudo mysql -h <rds endpoint> -u admin -p springbackend < springbackend.sql

#sudo mysql -u root -p

show databases;
show tables;
select * from tbl_workers;