MySQL Client Homebrew

When it comes to managing databases, MySQL is one of the most widely used solutions. For those who use a Mac, there are several options available for viewing and interacting with these databases. One popular option is TablePlus, which offers a free variant that is sufficient enough.

In this article, we will explore some of the MySQL clients that can be used on a Mac to view and manage databases. We will also take a look at how to install and use MariaDB Server, a popular alternative to MySQL.

Installing MariaDB Server

One way to get started with MariaDB Server is by installing it using Homebrew, a popular package manager for macOS. To do this, simply run the following command in your terminal:

`brew install mariadb`

Once installed, you can start MariaDB Server by running the following command:

`brew services start mariadb`

After starting the server, you can log in as your user by running the following command:

`mysql`

Building from Source

Alternatively, you can build MariaDB Server from source using Homebrew. To do this, follow these steps:

1. Install the dependencies needed to build MariaDB Server:

```

brew install boost homebrew/boneyard/judy

```

2. Build and install MariaDB Server:

```

brew install mariadb --build-from-source

```

Upgrading MariaDB Server

To upgrade MariaDB Server, simply run the following command:

`brew upgrade mariadb`

Auto-Starting MariaDB Server

To auto-start MariaDB Server when your Mac starts up, you can use Homebrew's services functionality. This will configure auto-start with the launchctl utility from launchd.

To do this, run the following command:

```

brew services start mariadb

```

By using Homebrew to install and manage MariaDB Server, you can easily keep your database software up-to-date without having to build it from source yourself.

In this article, we have explored some of the options available for viewing and managing databases on a Mac. We have also looked at how to install and use MariaDB Server using Homebrew. Whether you are a developer or simply need to manage a database for personal use, these tools can be very useful in helping you get the job done.

TL;DR

My personal favorite for Mac is TablePlus, which offers a free variant that is sufficient enough.

Mysql client homebrew