Download mysql version 5.7.23 - for explanation
operatino/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 :
- 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 to the default package key:
- Enter the following command :
- Expected output: mysql@5.7: stable 5.7.22 (bottled) [keg-only]
To install MySQL enter :
Additional configuration
Homebrew
Install brew services first :
Load and start the MySQL service : .
Expected output : Successfully started (label: homebrew.mxcl.mysql)Check of the MySQL service has been loaded : 1
Force link 5.7 version -
Verify the installed MySQL instance : .
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:
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
1 The - instruction is equal to :
-