This content originally appeared on DEV Community and was authored by Musa
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".
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.
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.
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.
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.
This content originally appeared on DEV Community and was authored by Musa
Musa | Sciencx (2025-01-28T22:29:36+00:00) Running multiple MySQL versions on macOS: A Step-by-Step Guide. Retrieved from https://www.scien.cx/2025/01/28/running-multiple-mysql-versions-on-macos-a-step-by-step-guide/
Please log in to upload a file.
There are no updates yet.
Click the Upload button above to add an update.