Configuration of MySQL database under Mac

Here's a note.

Before using the Brew install MySQL installation on the Mac, but found that the password is not good to modify after the installation, search the Internet found under the MAC using the command line to install MySQL is really a lot of problems, this is far less convenient than Ubuntu.

Online advice is to go to the MySQL official website to download, the official version is used here.

1. Download to MySQL website

http://dev.mysql.com/downloads/mysql/download it on this page, then install and drag.

2. Start MySQL

Click Preferences at the bottom to see the MySQL configuration.

Such as:

And:

3. Start MySQL at the command line

After the installation is complete, we can no longer command the line to start MySQL.

You can enter in the shell:

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

In order to be effective, we keep it in ~/.ZSHRC. (I'm using zsh)

4. Reset Password

MySQL current version of the default password I do not know, some articles said that the password is also root, I tried the next is not OK.

The MySQL version I am using is:

Server version:5.6.23 MySQL Community Server (GPL)

The Mac version is the latest Yosemite 10.10.2

Here, reset the password using:

/usr/local/mysql/bin/mysqladmin-u Root Password New password

5. MySQL Workbench can be installed and also downloaded from official website.

The configuration of MySQL under Mac is basically complete.

Configuration of MySQL database under Mac