How to Install Maria DB, create Database and Execute Queries

Hello Friends,

In this tutorial,we will see :

1. How to Install Maria DB
2. How to connect to Maria DB,Create Database and Execute Queries

1. How to Install Maria DB

 1.1 

Go to following link and click on "Download 10.4.12 Stable Now!" button.

As of writing this post,latest stable release of Maria DB is 10.4.12.Please check for latest stable release when you  are downloading. 

https://downloads.mariadb.org

1.2 

Download the installer for maria db by clicking and saving "mariadb-10.4.12-win64.msi"  on your local drive.

1.3 

Double click on Installer file and it will start Installation Wizard.

1.4

Click on Next and you will see following screen.Click on checkbox to accept Licences Agreement.

1.5

Click on Next and you will see following screen:

Here you can see :

-  It needs at least 147 MB of memory to install this software

-  List of items which will be installed

-  Software will  be installed at C:\Program Files\MariaDB 10.4\ .You can change this location if you want.

- HeidiSQL is a GUI using which you can access Maria DB easily like we we have SQL Developer or Toad.

1.6

Click on Next and you will see following screen :

Enter username and password ,whatever you want for the root user.You will  need this later for logging into database.So enter the password which you can remember.

1.7

Click on Next and you will see following screen.Here we can see that
 - Maria DB will be Installed as a Service
 - Maria DB will be accessible on port 3306
 - DB engine used is Innodb

1.8 

Click on Next and you will see following screen :

1.9

Click on Next and you will see following screen :

1.10

Click on Install and it will start installing Maria DB on your machine.

1.11

Once installation is finished, you will see following screen :

Just click on Finish,which means your installation is done.

2. How to connect to Maria DB,Create Database and Execute Queries

There are multiple ways you can connect with Maria DB like 

  2.1 Using HeidiSQL

  2.2 Using MySQL Client

 Note : Both of these comes with the installation of Maria DB itself ,so you dont need to install

anything separately.

  2.1 Using HeidiSQL

    2.1.1 

    

    You will find Icon of HeidiSQL on your Desktop like below :

             

       If you don't see above Icon then you can go to Start -> Search and type HeidiSQL and                         select HeidiSQL you will see following :

                   

2.1.2

Click on New and you will see following screen :

2.1.3

Enter password which you entered during installation

2.1.4

Click on Open and you will see GUI to work with Maria DB:

2.1.5

Now,you can create new database and execute queries as below :

CREATE DATABASE mydatabase;

USE mydatabase;

CREATE TABLE student(id INT, NAME CHAR(15));

INSERT INTO student(id, NAME) VALUES(101, "Gaurav");

SELECT  * FROM student;

2.2 Using MySQL Client

 2.2.1

  

 Go to Start -> Search, type "MySQl Client" and select "MySQL Client (Maria DB 10.4(x64))" and you will see following :

  

2.2.2 

 Enter your password to connect to Maria DB and hit enter and you will get connected to Maria DB as can be seen in following screen

   

2.2.3

To create new database execute following command :

create database mydatabase;

2.2.4

Execute following queries one by one to use mydatabase,create table,insert data and select data.

use mydatabase;

create table student(id int, name char(15));

insert into student(id, name) values(101, "Gaurav");

select * from student;

Summary 

So in this tutorial,we learnt,

- How we can install Maria DB

- How we can connect to Maria DB using HeidiSQL and MySQL Client

- How we can create database and execute queries

Thanks for reading.Please subscribe the blog for latest updates and share it with your friends.