To install MySQL on Mac, the two most common ways are Docker and Homebrew service. But Docker might be too big and eat up a large portion of memory, or sometimes you feel clumsy configuring the local server using the command line. On the other hand, it's really hard to install and manage multiple versions of MySQL on your computer.
In this post, we are going to use DBngin, a free tool for database version management on Mac. It allows you to set up a local MySQL server of any versions within a click. No command, no complicated configuration required.
First, go to DBngin, and download and install the app on your Mac.
Open DBngin and click on + New Server button.
Choose MySQL from the drivers' list; choose the MySQL version and name your server to create a new server. The default port is 3306 but you can edit the server and change the port later on.
DBngin will automatically create a new database cluster and a database which can be managed via a simple server controller. To start the server, go back to the server controller and click on start button, and quit when you're done.
DBngin supports creating multiple local database servers of not only MySQL but also PostgreSQL and Redis.
For your convenience, DBngin allows you to open the command line tools in your Terminal. All in all, finding your way around the DBngin app is fairly intuitive.