Install MySQL on Mac

August 02, 2014

1 min. read

  • Download from MySQL official website. Some bugs has been reported by people that use Homebrew to install MySQL.

  • Open and install it. There is only one file to install now, not three!

  • Edit ~/.zshrc and add the following lines:

alias mysql="/usr/local/mysql/bin/mysql"
alias mysqladmin="/usr/local/mysql/bin/mysqladmin"

  • Run mysqladmin -u root password "yourpassword" in iTerm2.

  • Go to MySQL in System Preference and turn it on.

  • Download, install and open Sequel Pro. In Host, fill in 127.0.0.1, username root and then password, tap Connect. By the way, the default port is 3306.

  • File > Import your .sql file.

← Subl and Zsh

Published 02 Aug 2014

Win Apps I Use Jul 2014 →

Published 15 Jul 2014