Install MySQL 5.7 on macOS Mojave

This is a tutorial on how to install MySQL 5.7 on macOS since the default version of MySQL (at the time of writing) is 8.0. Some software like Sequel Pro don’t yet support the changes made in the newer version of MySQL.

Update: Check out Sequel Ace, the fork of Sequel Pro.

First off, if you don’t have Homebrew installed, install it with:

Note: If you previously installed MySQL 8.0 but are downgrading, let’s uninstall everything first. This will completely remove any MySQL configurations and data that you might have.

Now lets install MySQL 5.7

Since 5.7 isn’t the latest version of MySQL that Homebrew has available, we need to manually link it.

Finally, if you want MySQL to always be running as a service, run:

To make your installation a bit more secure, and to set the root password run the following command and fill out the options as you see fit.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store