Install MySQL on Sierra using Homebrew

MySQL_macOS_Sierra.md

Install MySQL on macOS Sierra

This procedure explains how to install MySQL using Homebrew on macOS Sierra 10.12

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 5.7.15 as default formulae in its main repository :

• Enter the following command : $ brew info mysql
• Expected output: mysql: stable 5.7.15 (bottled)

To install MySQL enter : $ brew install mysql

Additional configuration

Homebrew

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

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

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

• Verify the installed MySQL instance : $ mysql -V.
  Expected output : Ver 14.14 Distrib 5.7.15, for osx10.12 (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 - instruction is equal to :

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

I recommend a better way to fix it:

(The main reason is that the older version mysql@5.7 not stopped while you upgrade mysql by homebrew, and something inside mysql data was broken. So you should reinstall older version mysql and stop the mysql services first. Then upgrade mysql data by mysql_upgrade to fix the broken data. Then you can uninstall older version or not, and latest version can be used yet.)

$ brew install mysql@5.7
$ brew services stop mysql && brew services start mysql@5.7
$ brew services stop mysql@5.7 && brew services start mysql
$ mysql_upgrade -u root -p
$ brew uninstall mysql@5.7

Thanks !

hi ,
how to change this mysql localhost to other ip in local mac os ???

On my mac when I try to run mysql -V then I am getting the following error.

mysql: Can't read dir of '/etc/mysql/conf.d/' (OS errno 2 - No such file or directory)
mysql: [ERROR] Fatal error in defaults handling. Program aborted!

Can anyone help me with this?

This is what's needed from a coolestguides link above:

Fix the looming 2002 socket error – which is linking where MySQL places the socket and where macOS thinks it should be, MySQL puts it in /tmp and macOS looks for it in /var/mysql the socket is a type of file that allows mysql client/server communication.

sudo mkdir /var/mysql

Then

sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock

Use brew install mysql --client-only install mysql client only

No matter what I attempt I keep getting this error

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

I followed the above instructions:

Install MySQL

At this time of writing, Homebrew has MySQL version 5.7.15 as default formulae in its main repository :

Enter the following command : $ brew info mysql
Expected output: mysql: stable 5.7.15 (bottled)
To install MySQL enter : $ brew install mysql

Additional configuration

Homebrew

Install brew services first : $ brew tap homebrew/services

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

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

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

MySQL

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

I still get this error :

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Please help.

mysql_upgrade -u root

Thank you a lot!

MySQL8 seems to be the default version now. Be aware that Sequel Pro seems to have some problems connecting and does not support MySQL 8. https://gist.github.com/operatino/392614486ce4421063b9dece4dfe6c21

Thank you

Thank you guy, it was very helpful!!

@fabionofre Thanks for the crystal clear solution.

I applied solution from this video.

https://youtu.be/isFl1SGKuKM

Hope this helps, If anyone wants to use a mysql installation file.

but that is not enough. So, I have to follow your answer also @fabionofre

laradock/laradock#1392 (comment)

Helpful, thanks!

None of the above worked for me, if you are still getting the socket error this worked for me:

1. remove /usr/local/var/mysql/
2. uninstall mysql
3. install mysql

Seems like I had 5.7 previously installed, then uninstalled it and my fresh installation was not working properly.

modify owner of mysql_upgrade_info in /usr/local/var/mysql, to solve the issue of /tmp/mysql.sock'

You no longer have to install services manually via brew tap homebrew/services FWIW...

Thanks!

Thanks bro

This is what's needed from a coolestguides link above:

Fix the looming 2002 socket error – which is linking where MySQL places the socket and where macOS thinks it should be, MySQL puts it in /tmp and macOS looks for it in /var/mysql the socket is a type of file that allows mysql client/server communication.

sudo mkdir /var/mysql

Then

sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock

I second this. After my upgrade from High Sierra to Mojave, symlinking was the one step I had to do to fix my local LAMP projects for running. I broke my head on this for a good full day and quick searching didn't provide what I wanted. My specific case: brew handling apache2, mysql5.7 while php being the stock (php7*)...shipped with OS X. Mysql was running smoothly on its own via CLI, just that my php apps weren't handling mysql.

thanks, hate brew..

NOTE the -u and -p.....they have no spaces. This worked for me.
sudo mysql -uroot -ppassword

Thank You so much. This really Helped!!

Can someone help me with "mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root-ppassword'@'localhost' (using password: NO)'" cause I can't seem to move forward from here.

If you need help following these instructions on an Apple Silicon Mac, use these modified instructions.

I've also included a few scripts to automate some bothersome everyday tasks. The scripts are executable using the Shortcuts app (Shortcuts was developed by Apple and is currently available on the Mac App Store).

I am not using a Silicon Mac. Where are the scripts referred to below? -----Original Message----- From: Emmett Shaughnessy ***@***.***> Reply-To: ***@***.***" ***@***.***> Date: Wednesday, January 18, 2023 at 7:18 PM To: RealEmmettS ***@***.***> Cc: Comment ***@***.***> Subject: [External] Re: nrollr/MySQL_macOS_Sierra.md @RealEmmettS commented on this gist. ________________________________________ If you need help following these instructions on an Apple Silicon Mac, use these modified instructions <https://www.craft.do/s/Y3979XszHcl0Si>. I've also included a few scripts to automate some bothersome everyday tasks. The scripts are executable using the Shortcuts app) — Reply to this email directly, view it on GitHub <https://gist.github.com/3f57fc15ded7dddddcc4e82fe137b58e#gistcomment-4441821> or unsubscribe <https://github.com/notifications/unsubscribe-auth/AIS7OASF7CA6CRDVIB6NZ53WTCB3TBFKMF2HI4TJMJ2XIZLTSKBKK5TBNR2WLJDHNFZXJJDOMFWWLK3UNBZGKYLEL52HS4DFQKSXMYLMOVS2I5DSOVS2I3TBNVS3W5DIOJSWCZC7OBQXE5DJMNUXAYLOORPWCY3UNF3GS5DZVRZXKYTKMVRXIX3UPFYGLK2HNFZXIQ3PNVWWK3TUUZ2G64DJMNZZDAVEOR4XAZNEM5UXG5FFOZQWY5LFVA2DANZRHEYDGMNHORZGSZ3HMVZKMY3SMVQXIZI>. You are receiving this email because you commented on the thread. 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>. [{ ***@***.***": "http://schema.org", ***@***.***": "EmailMessage", "potentialAction": { ***@***.***": "ViewAction", "target": "https://gist.github.com/3f57fc15ded7dddddcc4e82fe137b58e#gistcomment-4441821", "url": "https://gist.github.com/3f57fc15ded7dddddcc4e82fe137b58e#gistcomment-4441821", "name": "View on GitHub" }, "description": "View on GitHub", "publisher": { ***@***.***": "Organization", "name": "GitHub", "url": "https://github.com" } }] Caution: This message originated from outside of the Tufts University organization. Please exercise caution when clicking links or opening attachments. When in doubt, email the TTS Service Desk at ***@***.*** or call them directly at 617-627-3376.

How to install mysql@5.7 and mysql-client@5.7 with brew in 2024:

1 ) Edit local brew folmula files - delete line: deprecate! date: "2023-09-11", because: :unsupported

brew edit mysql@5.7
brew edit mysql-client@5.7

2. install mysql-client with only local brew files

HOMEBREW_NO_INSTALL_FROM_API=1  brew install mysql-client@5.7 mysql@5.7

# and intall ruby gem mysql2 0.5.4 for mysql 5.7:
gem install mysql2 -v 0.5.4 -- --with-openssl-dir=$(brew --prefix openssl@1.1)  -- --with-mysql-dir=/usr/local/opt/mysql-client@5.7/