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 mysql@5.7
• Expected output: mysql@5.7: stable 5.7.22 (bottled) [keg-only]

To install MySQL enter : $ brew install mysql@5.7

Additional configuration

Homebrew

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

• Load and start the MySQL service : $ brew services start mysql@5.7.
  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 mysql@5.7 --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 mysql@5.7 - instruction is equal to :

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

root

very thanks~
helpful~

Still seeing the "Can't connect to local MySQL server..."

Tried Greggle's link to fully remove a previous install of MySQL 8, but after a restart the problem persists

# brew services start mysql@5.7
==> Successfully started `mysql@5.7` (label: homebrew.mxcl.mysql@5.7)

# launchctl list | grep mysql
-	0	homebrew.mxcl.mysql@5.7

Brew services is reporting the service started, but Launchctl is not showing a PID.

Here is the log output

lee@kezzico:~# tail /usr/local/var/mysql/kezzico.local.err 
2018-10-03T21:57:10.986146Z 0 [ERROR] Can't start server: can't check PID filepath: No such file or directory
2018-10-03T21:57:11.6NZ mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

Finally got the service to start by creating a folder for the PID, and setting the permission on the folder to global read/write/x.

# sudo mkdir /var/run/mysqld
# chmod 777 /var/run/mysqld

Not sure why this is necessary. There may be security implications to this. Hopefully someone has a better solution.

Also you can change the mysql folder permissions to the current user.

sudo chown -Rv "$USER":admin /usr/local/var/mysql

Works great until I attempt to create a password for root:

$ mysqladmin -u root password 'yourpassword'

I get the following error:

... Failed! Error: Column count of mysql.user is wrong. Expected 45, found 43. Created with MySQL 50615, now running 50732. Please use mysql_upgrade to fix this error.

Any advice would be much appreciated?

Works great until I attempt to create a password for root:

$ mysqladmin -u root password 'yourpassword'

I get the following error:

... Failed! Error: Column count of mysql.user is wrong. Expected 45, found 43. Created with MySQL 50615, now running 50732. Please use mysql_upgrade to fix this error.

Any advice would be much appreciated?

run this command, it will prompt a form about setting up root password

mysql_secure_installation

Works great until I attempt to create a password for root:
$ mysqladmin -u root password 'yourpassword'
I get the following error:
... Failed! Error: Column count of mysql.user is wrong. Expected 45, found 43. Created with MySQL 50615, now running 50732. Please use mysql_upgrade to fix this error.
Any advice would be much appreciated?

run this command, it will prompt a form about setting up root password

mysql_secure_installation

Did the trick, thanks!

Thanks a lot!!!

I followed the instructions and did a clean install.
I got to the same "mysqladmin" point, but failed differently...

% mysqladmin -u root password '---redacted---'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

To get past this, here's what I ended up having to do:

• Enter mysql and add a password for “root” user:

  • mysql -u root -p
  • It will prompt for password. THERE IS NO PASSWORD YET, SO JUST HIT ENTER
  • you should get the mysql> prompt

• At the mysql> prompt:

  • mysql> use mysql;
  • mysql> update user set authentication_string=password("<desired root password>") where user="root";
  • mysql> exit

• Restart the service to pick up the change:

  • brew services stop mysql@5.7
  • brew services start mysql@5.7

Now, when you do mysql -u root -p it will prompt for password and accept the new password you set above.

I had to do below steps after following the given instructions:-
sudo mkdir /usr/local/var/mysql
sudo chmod 777 /usr/local/var/mysql
brew services restart mysql@5.7

When setting up my Apple M1 Macbook Pro I was experiencing the issue of the following error message being thrown:

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

My fix was to modify the MySQL config file:

nano /usr/local/etc/my.cnf

Append the following lines:

tmpdir=/tmp
user=root

Then run:

brew services restart mysql@5.7

This fixed my issue, and I was then able to connect successfully with my DB client.

Thank you, It worked on macOS Monterey.

Not working for me on mac os m2 ventura.

I did start mysql@5.7 and gives me Successfully started mysql@5.7 (label: homebrew.mxcl.mysql@5.7) message. But, when I tried to view the list of services to check if it's really started, I got this status below which is stopped.

much good!

Any suggestions since 2024-08-01?
% brew install mysql@5.7 Error: mysql@5.7 has been disabled because it is not supported upstream! It will be disabled on 2024-08-01.

@milo-lamar Have you managed to resolve this

No but adjustments had already been made to allow 8.0 to work for me so I was allowed to move on with my life.. If worse comes to worse, you can find an old copy of 5.7 somewhere I'm sure.

…

On Thu, Aug 15, 2024 at 6:13 PM Ibad Khan ***@***.***> wrote: ***@***.**** commented on this gist. ------------------------------ @milo-lamar <https://github.com/milo-lamar> Have you managed to resolve this — Reply to this email directly, view it on GitHub <https://gist.github.com/robhrt7/392614486ce4421063b9dece4dfe6c21#gistcomment-5155865> or unsubscribe <https://github.com/notifications/unsubscribe-auth/BKDPDE2LRWQWZGX5HFYED7LZRVG5NBFKMF2HI4TJMJ2XIZLTSKBKK5TBNR2WLJDUOJ2WLJDOMFWWLO3UNBZGKYLEL5YGC4TUNFRWS4DBNZ2F6YLDORUXM2LUPGBKK5TBNR2WLJDHNFZXJJDOMFWWLK3UNBZGKYLEL52HS4DFVRZXKYTKMVRXIX3UPFYGLK2HNFZXIQ3PNVWWK3TUUZ2G64DJMNZZDAVEOR4XAZNEM5UXG5FFOZQWY5LFVA4TAOBQGIYTINNHORZGSZ3HMVZKMY3SMVQXIZI> . You are receiving this email because you were mentioned. Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub> .

@ibadk5304 I was able to get part of the way to installing 5.7 again, but ended up reaching an error I couldn't resolve. Like Milo, I was able to switch to 8.0, but if you can't, I hope this might get you partway there:

• Install Homebrew's packages locally: brew tap homebrew/core --force
• open /opt/homebrew/Library/Taps/homebrew/homebrew-core/Formula/m/mysql@5.7.rb and comment out the line disabling the formula (line 22). In my experience, Homebrew kept overwriting this change, so you might have better luck copying the file to some new name instead.
• HOMEBREW_NO_INSTALL_FROM_API=1 brew install --build-from-source /opt/homebrew/Library/Taps/homebrew/homebrew-core/Formula/m/mysql@5.7.rb Or use the new file copy if you created one in the last step.

This approach allowed MySQL to start installing, but I still ran into an error:

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

... and I couldn't figure out how to solve that issue. The non-existent file here seems like it's something Homebrew is supposed to add during the installation process. When I created the file myself, Homebrew thought mysql@5.7 was "already installed."

What I did here was to use instead mariadb@10.11, which is greatly compatible with MySQL 5.7 - so instead of using mysql@5.7 you can just use mariadb@10.11 to replace it 🎉

brew tap homebrew/core --force
brew edit mysql@5.7
# Remove disable! line
HOMEBREW_NO_INSTALL_FROM_API=1 brew install mysql@5.7

@Pezmc you solution worked great. I tried upgrading to mysql 8 and had issues but I had already uninstalled 5.7 :(

Error: An exception occurred within a child process:
  Errno::ENOENT: No such file or directory @ apply2files - /opt/homebrew/Cellar/mysql@5.7/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 mysql@5.7

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 "openssl@1.1" 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 mysql@5.7

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/mysql@5.7.rb to install from source
5. when install, Maybe throw error likeError: openssl@1.1 has been disabled because it is not supported upstream! It was disabled on 2024-10-24., use same way . brew edit openssl@1.1 to comment this line # disable! date: "2024-10-24", because: :unsupported
6. after step5 ,now install openssl@1.1 from source code HOMEBREW_NO_INSTALL_FROM_API=1 brew install --build-from-source /opt/homebrew/Library/Taps/homebrew/homebrew-core/Formula/o/openssl@1.1.rb
7. after success install openssl ,reinstall mysql@5.7 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 mysql@5.7
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 mysql@5.7
rm -rf /opt/homebrew/var/mysql
mysqld --initialize-insecure --user=`whoami`
brew services start mysql@5.7

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 mysql@5.7