Install MySQL on El Capitan using Homebrew
Normally the installation of MySQL can be achieved with a single command, which executes a script provided by MacMiniVault :
bash <(curl -Ls http://git.io/eUx7rg)
However, at the time of writing the script is not compatible with OS X El Capitan (10.11)
An alternative to the aforementioned installation script is installing MySQL using Homebrew. This gist assumes you already have Homebrew installed, if not first read the article "Homebrew and El Capitan"
Make sure Homebrew has the latest formulae, so run brew update
first
-OR- make sure Homebrew has MySQL version 5.6.27 as default formulae in its main repository :
brew info mysql
Next install MySQL with : brew install mysql
###Additional configuration Open Terminal and execute the following commands :
ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
.bash_profile
:export MYSQL_PATH=/usr/local/Cellar/mysql/5.6.27
export PATH=$PATH:$MYSQL_PATH/bin
mysql -v
to confirmmysql> \q
###Configure 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 OS X