MySQL Workbench is a visual tool for database architects and developer. It offers administration tools for server configuration, user administration and much more. It is available on Windows, Linux, and MAC OS X. It is recommended for anyone who wants to master Database administration. MariaDB Server is available for installation on macOS (formerly Mac OS X) via the Homebrew package manager. MariaDB Server is available as a Homebrew 'bottle', a pre-compiled package. This means you can install it without having to build from source yourself.
I'm looking for database administration tools for MariaDB, I've used HeidiSQL on a PC and live this, but I understand it isn't available for a MAC.
Answer Answered by Jan Steinman in this comment.
There are numerous Mac OS clients for MySQL, all of which work for MariaDB, although you generally have to use SQL statements to use MariaDB features like virtual columns, etc.
First off, if you run a web server, you can use phpMyAdmin, which is nice because it will work on any platform that has a web browser. It has some quirks and has gotten slower over the years, so I don't use it very much now.
My favourite is Sequel Pro (http://www.sequelpro.com). It's free. I wish it could identify foreign keys with a tooltip, like phpMyAdmin does, but it at least gives you a link, so you're one click away.
Another one I like is Querious. (http://www.araelium.com/querious/) I would use it more often but for a silly reason: i can't remember its name! I think it costs something, but not very much. It has a nice boxes-and-lines graphical schema view that Sequel Pro lacks.
I also have downloaded other tools from the Apple Store, such as Toad, Metabase, LamaFree, and more. Most of them, I fire up, play with for a bit, then go back to my favourites above.
Hope this is helpful!
Comments
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
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 For Mac
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.
Mariadb Windows Client
Create database command is responsible for creating the database named as javatpoint in the records.
5) Stop MariaDB
To stop MariaDB server, we run the following command.
Hence, we have installed and get started with MariaDB.