Home » How to Install MariaDB on Mac

How to Install MariaDB on Mac

by Online Tutorials Library

How to Install MariaDB on MacOS.

Introduction

MariaDB is an open source database management system. MariaDB intends to maintain high compatibility with MySQL. It is one of the most popular databases in the world. MariaDB is named after the name of younger daughter Maria of its founder Michael “Monty” Widenius. In this tutorial, we will learn the steps involved in the installation process of MariaDB on MacOS.

Prerequisites

  1. MacOS
  2. Login as an administrator on terminal

Installation

Installation includes following steps.

1) Update the local repository index of homebrew package installer

Following command can be executed to update the local repository index of homebrew.

2) Install with homebrew

MariaDB can be installed by using homebrew package installer. Following command is executed to install MariaDB.

Install MariaDB
Install MariaDB

3) Start MariaDB

To start MariaDB, MySQL.server needs to be started which is located inside /usr/local/Cellar/mariadb/10.2.12/support-files. We can start the server by using following command.

To execute the command, we need to either change our working directory to usr/local/Cellar/mariadb/10.2.12/support-files or change the PATH variable by editing .bash_profile.

Install MariaDB

4) Working on command line

To get started with the MariaDB shell, following command can be executed.

For this, change the working directory to /usr/local/cellar/mariadb/10.2.12/bin or edit .bash_profile.

Install MariaDB

Create database command is responsible for creating the database named as tutoraspire in the records.

5) Stop MariaDB

To stop MariaDB server, we run the following command.

Install MariaDB

Hence, we have installed and get started with MariaDB.

You may also like