Installation on Mac

Install RVM

{% hint style="info" %} follow step here : https://rvm.io/rvm/install {% endhint %} Install Ruby version with openssl rvm install ruby-2.3.8 --with-openssl-dir=$HOME/.rvm/usr 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 1
• 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! update /etc/mysql/my.cnf to update the sql_mode

[mysqld]
sql_mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"