benlinton/multiple_mysql_versions_for_development.md

Last active August 15, 2025 21:37

Star (291) You must be signed in to star a gist
Fork (79) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/benlinton/d24471729ed6c2ace731.js"></script>
Save benlinton/d24471729ed6c2ace731 to your computer and use it in GitHub Desktop.

Download ZIP

Multiple MySQL Versions with Homebrew

Raw

multiple_mysql_versions_for_development.md

Multiple MySQL Versions for Development

Options included below:

Using Docker docker-compose
Using Homebrew brew

Using Docker (recommended)

This gist was originally created for Homebrew before the rise of Docker, yet it may be best to avoid installing mysql via brew any longer. Instead consider adding a barebones docker-compose.yml for each project and run docker-compose up to start each project's mysql service.

docker-compose.yml

version: "3.7"
services:

  db:
    image: mysql:5.6
    restart: always
    ports:
      - "3306:3306"
    volumes:
      - "db_data:/var/lib/mysql"

volumes:
  db_data: null

Please visit https://hub.docker.com/_/mysql for environment variables that you can optionally set (e.g. username, password, etc.)

To start the your mysql service.

docker-compose up

To stop your mysql service.

docker-compose down  # or ctrl-c if service is running in foreground

Using Homebrew

Disclaimer: Your milage may vary, I've updated this gist based on comments below but haven't tested it myself since switching to Docker. Please see comments below and/or gist history for additional details.

I was using homebrew version 0.9.5 when writing this gist.

brew -v # => Homebrew 0.9.5

Install the current version of mysql.

# Install current mysql version
brew install mysql

# Start agent for current version of mysql
brew services start mysql

Install the older version of mysql.

# Install older mysql version
brew install [email protected]

# Start agent for older version of mysql
brew services stop mysql
brew services start mysql56

Then to switch to the older version.

# Unlink current mysql version
brew unlink mysql 

# Check older mysql version
ls /usr/local/Cellar/mysql56 # => 5.6.27

# Link the older version
brew switch [email protected] 5.6.27

And to switch back to the current version.

# Unlink older mysql version
brew unlink mysql56 

# Check current mysql version
ls /usr/local/Cellar/mysql # => 5.7.10

# Link the current version
brew switch mysql 5.7.10

To verify which mysql version you're on at any time.

# Check which version of mysql is currently symlinked
ls -l /usr/local/bin/mysql # => /usr/local/bin/mysql@ -> ../Cellar/mysql56/5.6.27/bin/mysql

# Or using the mysql command
mysql --version

jsweeney commented Apr 24, 2017

@jpmelguizo I also had your problem. My issue was that the [email protected] was trying to boot the mysql 5.7 database (installed in the default /usr/local/var folder). If you want to run both in parallel on their own distinct databases, there are a few more steps to do.

Create a new (separate) data directory and database for the 5.6 version
Run /usr/local/Cellar/[email protected]/5.6.36/bin/mysql_install_db --user=root --datadir=/usr/local/var/mysql56
Change the configuration to start the 5.6 version pointing to this database
Edit /usr/local/Cellar/[email protected]/5.6.36/[email protected] to change both /usr/local/var/mysql instances to /usr/local/var/mysql56 (I didn't put the @ in the folder name just in case it would cause issues).

<plist version="1.0">
<dict>
  <key>KeepAlive</key>
  <true/>
  <key>Label</key>
  <string>[email protected]</string>
  <key>ProgramArguments</key>
  <array>
    <string>/usr/local/opt/[email protected]/bin/mysqld_safe</string>
    <string>--bind-address=127.0.0.1</string>
    <string>--datadir=/usr/local/var/mysql56</string> <!-- <<<<<<<<<<<<<<<<<< HERE -->
  </array>
  <key>RunAtLoad</key>
  <true/>
  <key>WorkingDirectory</key>
  <string>/usr/local/var/mysql56</string> <!-- <<<<<<<<<<<<<<<<<< AND HERE -->
</dict>
</plist>

Change the port of the 5.6 server - if ever you want to start both at the same time.
Edit /usr/local/Cellar/[email protected]/5.6.36/my.cnf, uncomment port and change it to some other value than 3306.

# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
port = 3356
# server_id = .....
# socket = .....

NOTE A little caveat about connecting to the MySQL instances after such a setup. Using any kind of driver will work out of the box if you set the correct port. However, at the command line, mysql ignores the --port value by default, so you need something like this
mysql -uroot --port=3356 --protocol=TCP
See this article for more details: https://dev.mysql.com/doc/refman/5.7/en/connecting.html

ghost commented Apr 26, 2017

@JSweeny your solution worked like a charm! now I can switch from one to the other using aliases and without having to dump/import anything. Really helpful when you have to work with Craft2 (has problems with MySQL >5.7.5) Thank you so much!

gerard-morera commented May 4, 2017

Love u

maijaz01 commented Sep 23, 2017

while giving command > mysql

ERROR 1045 (28000): Access denied for user 'sheikhaijaz'@'localhost' (using password: NO)
can you please help on this

unlessbamboo commented Jan 4, 2018

Good.

quberok commented Jun 21, 2018 •

edited

Loading

@jsweeney thanks, your solution is awesome. But before run the first, you must go to /usr/local/Cellar/[email protected]/5.6.36 dir, otherwise you will see mysql_install_db not found error.

cd /usr/local/Cellar/[email protected]/5.6.36

And it works only for mysql 5.6. for mysql 5.7 will be

/usr/local/Cellar/[email protected]/5.7.22/bin/mysqld --initialize --user=root --datadir=/usr/local/var/mysql57

And for mysql 5.5

cd /usr/local/Cellar/[email protected]/5.5.60
/usr/local/Cellar/[email protected]/5.5.60/scripts/mysql_install_db --user=root --datadir=/usr/local/var/mysql55

rdp commented Jul 12, 2018

these days it's more like brew install [email protected] but got me going on the right track, thanks!

ivange94 commented Jul 16, 2018 •

edited

Loading

I followed this now I'm getting mysql command not found.

This helped me instead https://gist.github.com/6temes/3c52f8a472f61d9676e7218a98812286

ricketybridge commented Jul 25, 2018

Why is it necessary to have the agents running before doing the relinking and such?

At any rate, this is giving me a "file not found" error:

ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

esirK commented Feb 19, 2019

Received the error
Error: homebrew/versions was deprecated. This tap is now empty as all its formulae were migrated.
You need to use
brew install [email protected] instead.

ryanomor commented Jun 10, 2019

I had the same issue @esirK. I think this needs to be updated to reflect that change

Author

benlinton commented Jun 11, 2019

@LoranceChen @geryit @ryanomor Thanks for you feedback! I edited the gist to apply your recommendations.

For everyone else, I did not test these changes out since I now use Docker to solve this problem. So your milage may vary.

bpolster commented Jun 21, 2019

When switching back to mysql55 I needed to additionally do:

brew link mysql55 --force

Similar for me. brew link [email protected] --force. Before, was getting mysql No such file or directory.

4unkur commented Oct 4, 2019

Check https://dbngin.com/
It has MySQL 5.7 and 8. I'm using it only for 5.7 with different port, so I have both MySQL versions running at the same time

f-l-s commented Feb 3, 2021 •

edited

Loading

The Homebrew section is still useful many years later... Thank you very much ! :)

Some changes in this section should be done with Homebrew 2.7.7 :

1- Use in every command the notation "[email protected]" instead of "mysql56"
For example :
brew services start [email protected]

2- Command brew Switch is disabled. You need to use :
# Unlink the actual linked version
brew unlink [email protected]
# Unlink the new version you want to use
brew link [email protected]

One useful command to add to this guide :
# List all installed versions of mysql
brew list --versions | grep mysql*

pvangala-mdsol commented Mar 10, 2021 •

edited

Loading

Use brew link [email protected] in case you have error like Error: Unknown command: switch

wizhou commented Oct 12, 2021

Thanks a lot

benlinton/multiple_mysql_versions_for_development.md

Multiple MySQL Versions for Development

Using Docker (recommended)

Using Homebrew

jsweeney commented Apr 24, 2017

Uh oh!

ghost commented Apr 26, 2017

Uh oh!

gerard-morera commented May 4, 2017

Uh oh!

maijaz01 commented Sep 23, 2017

Uh oh!

unlessbamboo commented Jan 4, 2018

Uh oh!

quberok commented Jun 21, 2018 •

edited

Loading

Uh oh!

rdp commented Jul 12, 2018

Uh oh!

ivange94 commented Jul 16, 2018 •

edited

Loading

Uh oh!

ricketybridge commented Jul 25, 2018

Uh oh!

esirK commented Feb 19, 2019

Uh oh!

ryanomor commented Jun 10, 2019

Uh oh!

benlinton commented Jun 11, 2019

Uh oh!

bpolster commented Jun 21, 2019

Uh oh!

4unkur commented Oct 4, 2019

Uh oh!

f-l-s commented Feb 3, 2021 •

edited

Loading

Uh oh!

pvangala-mdsol commented Mar 10, 2021 •

edited

Loading

Uh oh!

wizhou commented Oct 12, 2021

Uh oh!

benlinton/multiple_mysql_versions_for_development.md

Multiple MySQL Versions for Development

Using Docker (recommended)

Using Homebrew

jsweeney commented Apr 24, 2017

Uh oh!

ghost commented Apr 26, 2017

Uh oh!

gerard-morera commented May 4, 2017

Uh oh!

maijaz01 commented Sep 23, 2017

Uh oh!

unlessbamboo commented Jan 4, 2018

Uh oh!

quberok commented Jun 21, 2018 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

rdp commented Jul 12, 2018

Uh oh!

ivange94 commented Jul 16, 2018 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

ricketybridge commented Jul 25, 2018

Uh oh!

esirK commented Feb 19, 2019

Uh oh!

ryanomor commented Jun 10, 2019

Uh oh!

benlinton commented Jun 11, 2019

Uh oh!

bpolster commented Jun 21, 2019

Uh oh!

4unkur commented Oct 4, 2019

Uh oh!

f-l-s commented Feb 3, 2021 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

pvangala-mdsol commented Mar 10, 2021 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

wizhou commented Oct 12, 2021

Uh oh!

quberok commented Jun 21, 2018 •

edited

Loading

ivange94 commented Jul 16, 2018 •

edited

Loading

f-l-s commented Feb 3, 2021 •

edited

Loading

pvangala-mdsol commented Mar 10, 2021 •

edited

Loading