How To Install MariaDB on Ubuntu:
Step 1 — Installing MariaDB:
$ sudo apt update
$ sudo apt install mariadb-server
Step 2 — Configuring MariaDB
$ sudo mysql_secure_installation
Creating an Administrative User:
$ sudo mariadb
$ create user “user1”@‘localhost’ identified by ’1234’ Username = user1 Passwd = 1234
Step 3 — Status of MariaDB
$ sudo systemctl status mariadb
Step 4 — Create Database
$ sudo create database “database1”;
Step 5 — Create Tables
$ use database1;
$ create table employee_detail( -> id int,
-> Name varchar(20),
-> age int, -> PRIMARY KEY(id));
Step 5 — Give Permission
$ GRANT ALL ON database1.* to ’user1’@‘localhost’;
Basic Commands
Databases list - $ show databases; User List. - $ select host, user from mysql.user; Open database. - $ use database1 Open table. - $ describe employee_detail; Delete Database. - $ Drop Database aalavai; Delete User. - $ Drop user ‘user1’@localhost; Version. - $ mysql --version Status check. - $ service mysql status Stop Service. - $ systemctl stop mariadb.service Re-Start Service - $ systemctl restart mariadb.service
Comments