1. Go https://mariadb.com/docs/platform/post-download/mariadb-server-11.8.3
2. Install mariaDB.

Go to CMD and log in via mysql -u root -p, use the password you set before when installing.

User Set up

-- 1) Create a local user with your name
CREATE USER 'YOURNAME'@'localhost' IDENTIFIED BY 'P@ssw0rd!';

-- 2) Grant privileges (full, for lab purpose)
GRANT ALL PRIVILEGES ON *.* TO 'YOURNAME'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

-- 3) Show users + host
SELECT User, Host FROM mysql.user ORDER BY User, Host;

-- (Optional) Verify grants
SHOW GRANTS FOR 'YOURNAME'@'localhost';

Use “EXIT;” to leave the terminal if needed.

Create:

CREATE DATABASE dbName
SHOW DATABASES;

USE dbName;

CREATE TABLE students (
  sid   INT PRIMARY KEY,
  name  VARCHAR(100) NOT NULL,
  grade VARCHAR(5)    NULL
);

Select:

SELECT * FROM students;

Insert:

INSERT INTO dbName (sid, name, grade)
VALUES (2001111, 'Lewis', 'NA');
SELECT * FROM students;

Example: