DEV Community

SnapDB
SnapDB

Posted on

Running multiple MySQL versions on macOS: A Step-by-Step Guide

Managing multiple versions of MySQL on macOS can be a complex task, especially when dealing with different configurations and ports. Fortunately, with SnapDB, you can streamline this process, allowing you to run multiple MySQL servers on different ports effortlessly. You won't need to use Docker, Homebrew or other dependencies. Let's dive in and see how.

Step 1. Add your first MySQL Server

Tap the "plus" button to add a new database service. SnapDB supports various DB types, however in this instance we will select "MySQL".

Adding MySQL server in SnapDB

Step 2. Select your version and port

Select the MySQL version and port for your first service. Note: the port numbers for both MySQL instances have to be different.

Selecting a port and version for MySQL
In the example above, I'm using port 3309 for the first server.

Step 3. Create the server

Once you confirm your entry, SnapDB will create and start the MySQL server for you - that's one out of the way. Confirm that the service is running properly in the sidebar on the left.

Checking if the MySQL server is created properly

Step 4. Repeat the above steps

To start another MySQL server, all you need to do is repeat the steps above. Of course, you should select a different port and version number for your second service.

Done

If performed correctly, you will end up with two isolated MySQL instances running side-by-side. All done without bloated tools like Brew, Docker or Vagrant ⭐️. Make sure to use to correct connection details (port) when interfacing with the databases.

Two MySQL instances running using SnapDB

You can now start tinkering locally with your newly created database servers. If you have any thoughts I will be glad to hear them in the comments bellow.

Do your career a favor. Join DEV. (The website you're on right now)

It takes one minute and it's free.

Get started

Top comments (0)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 Kindness is contagious

Discover a treasure trove of wisdom within this insightful piece, highly respected in the nurturing DEV Community enviroment. Developers, whether novice or expert, are encouraged to participate and add to our shared knowledge basin.

A simple "thank you" can illuminate someone's day. Express your appreciation in the comments section!

On DEV, sharing ideas smoothens our journey and strengthens our community ties. Learn something useful? Offering a quick thanks to the author is deeply appreciated.

Okay