Install MySQL 5.7 on macOS

In this article I will guide you how to install MySQL 5.7 on macOS using Homebrew package manager for macOS.

Install Homebrew

Install Homebrew if you do not have already installed.

$ /usr/bin/ruby -e "$(curl -fsSL"

Install brew services

Install brew services using following terminal command.

$ brew tap homebrew/services

Install MySQL 5.7

List the default MySQL available formulae in main repository.

$ brew info mysql@5.7

Install MySQL 5.7 using brew install command.

$ brew install mysql@5.7

Load and start the MySQL service

Start MySQL service using brew services start command.

$ brew services start mysql@5.7

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

Verify the newly installed instance of MySQL server.

$ mysql -V

The output of mysql -V will be like following one.

mysql  Ver 14.14 Distrib 5.7.24, for osx10.14 (x86_64) using  EditLine wrapper

Configuration of MySQL 5.7 server

Open terminal and execute the following command to set the root password.

mysqladmin -u root password 'yourpassword'

MySQL 5.7 Database Management

You can use Sequel Pro GUI client to manage MySQL



brew services start mysql@5.7

Above mentioned instruction is same as executing following commands individually.

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

That’s it, hope you enjoyed it. You like this article, have any questions or suggestions please let us know in the comments section.

Thanks and Happy Learning!

Shoket Mahmood Ahmed

Leave a Reply

Back to top