Install MySQL 5.7 on macOS using Homebrew

MySQL_5-7_macOS.md

This is a fork of original gist https://gist.github.com/nrollr/3f57fc15ded7dddddcc4e82fe137b58e, with slight changes on pointing to 5.7 version branch, instead of 8 (latest default of MySQL in Hombrew).

Install MySQL 5.7 on macOS

This procedure explains how to install MySQL using Homebrew on macOS (Sierra 10.12 and up)

Install Homebrew

• Installing Homebrew is effortless, open Terminal and enter :
  $ /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
• Note: Homebrew will download and install Command Line Tools for Xcode 8.0 as part of the installation process.

Install MySQL

At this time of writing, Homebrew has MySQL version 8 as default, but as we're aiming to get 5.7, we'll need to append @5.7 to the default package key:

• Enter the following command : $ brew info [email protected]
• Expected output: [email protected]: stable 5.7.22 (bottled) [keg-only]

To install MySQL enter : $ brew install [email protected]

Additional configuration

Homebrew

• Install brew services first : $ brew tap homebrew/services

• Load and start the MySQL service : $ brew services start [email protected].
  Expected output : Successfully started mysql (label: homebrew.mxcl.mysql)

• Check of the MySQL service has been loaded : $ brew services list ¹

• Force link 5.7 version - $ brew link [email protected] --force

• Verify the installed MySQL instance : $ mysql -V.
  Expected output : Ver 14.14 Distrib 5.7.22, for osx10.13 (x86_64)

MySQL

Open Terminal and execute the following command to set the root password:
mysqladmin -u root password 'yourpassword'

Important : Use the single ‘quotes’ to surround the password and make sure to select a strong password!

Database Management

To manage your databases, I recommend using Sequel Pro, a MySQL management tool designed for macOS.
Current version available: 1.1.2

Comments

¹ The brew services start [email protected] - instruction is equal to :

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

Error: An exception occurred within a child process:
  Errno::ENOENT: No such file or directory @ apply2files - /opt/homebrew/Cellar/[email protected]/5.7.44_1/data

@newtrat To fix this, follow instructions from @Pezmc and also add this just before the system "cmake" line:

mkdir prefix/"data"

HOMEBREW_NO_INSTALL_FROM_API=1 brew install [email protected]

this works for me!

Thanks, everyone, for this thread! The steps from @Pezmc worked great for me. The only change I had to make was updating depends_on "[email protected]" to depends_on "openssl@3" when modifying the mysql formula in my set up.

I didn’t experience any breaking changes with this patch, but your mileage may vary.

Finally make mysql5.7 work on my m3 chip mac.

1. make sure you have uninstalled all other version mysql , follow this gist

brew remove mysql
rm -rf /opt/homebrew/var/mysql

2. follow @newtrat instruction

brew tap homebrew/core --force
brew edit [email protected]

3. use a old install rb script replace ,like this version https://github.com/Homebrew/homebrew-core/blob/c73c9d6baacb82c60df84cb07c1fe6209438cfc1/Formula/m/mysql%405.7.rb
4. now use HOMEBREW_NO_INSTALL_FROM_API=1 brew install --build-from-source /opt/homebrew/Library/Taps/homebrew/homebrew-core/Formula/m/[email protected] to install from source
5. when install, Maybe throw error likeError: [email protected] has been disabled because it is not supported upstream! It was disabled on 2024-10-24., use same way . brew edit [email protected] to comment this line # disable! date: "2024-10-24", because: :unsupported
6. after step5 ,now install [email protected] from source code HOMEBREW_NO_INSTALL_FROM_API=1 brew install --build-from-source /opt/homebrew/Library/Taps/homebrew/homebrew-core/Formula/o/[email protected]
7. after success install openssl ,reinstall [email protected] follow step 4
8. just wait, mysql compilation will takes some time
9. after mysql5.7 install success just start use brew brew services start [email protected]
10. use brew services list check mysql start success
11. if not ,read cat /opt/homebrew/var/mysql/${HOST}.err file to check the error
12. if throw like Table 'mysql.plugin' doesn't exist follow this

brew services stop [email protected]
rm -rf /opt/homebrew/var/mysql
mysqld --initialize-insecure --user=`whoami`
brew services start [email protected]

13. enjoy it

Just what @Pezmc did but instead of what @andrew-bierman said to change openssl version in the mysql formulae we edit the openssl 1.1 formula instead.

List of Steps

Force tap the homebrew core tap
Edit the mysql 5.7 formula to remove the disable line
mysql5.7 depends on openssl 1.1
edit openssl 1.1 as well using same way as above
and then use HOMEBREW_NO_INSTALL_FROM_API=1 to use the locally edited formulae
Then run-
brew install [email protected]