Mac install MySQL

Mac installation MySQL is not as intelligent as win (no brain), but also requires some configuration steps. Online tutorials are not specific enough to find a few integrated to install, so leave a mark, help others reduce the time loss:

1. Go to the official website next MYSQL-*.*.*-OSX10.9-X86_64.DMG, pay attention to select the corresponding CPU bit number

2. After installation, change Password:/usr/local/mysql/bin/mysqladmin-u root password yourpassword

3. There are differences from this step:

(1) If you are using a Mac-terminal (this command line only loads the Bash_profile), then

Vim. Bash_profile

Add a sentence ( after unregistering the system.) Environment variable Talent effective ):

Export path= "$PATH:/usr/local/mysql/bin"

Make the path temporarily active (temporarily without logging off, can be temporarily effective with the following command, Exit command line is invalid):

Path= "$PATH":/usr/local/mysql/bin

View results:

Echo $PATH

(2) assume that the zsh (Z Shell) is used. Then change the loading file path to (for the first time with the Mac, I was a little bit of ignorance of the pit.

haha):

Vim ~/.ZSHRC

Other steps (1)

Mac install MySQL