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
- MacOS
- 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.
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.
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.
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.
Hence, we have installed and get started with MariaDB.