Installation of MySQL under Mac

My Computer system OS X 10.10 above, new system.

Download mysql:http://dev.mysql.com/downloads/mysql/

I downloaded more than 10.10 of the DMG installation version, compressed version is also available. Setup is relatively cumbersome and is not introduced here.

Download the good MySQL version of the DMG after the next step of the Fool-type.

！ Install to the end there will be a temporary password please remember it

After installing, click on the top left corner of the Apple icon---Mysql->start MySQL server button, and then MySQL starts

Open Terminal Command->vi. Bash_profile (MySQL installs the environment variables of its own users after installation)

If it is your user name: ~ Such words open VI. Bash_profile and the new computer is nothing.

Press the I key

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

Press ESC and press ENTER: Wq return.

Reboot the terminal and you're ready.

Change Password:

Open the terminal input again mysqladmin-u root-p password your new password OK

Enter the temporary password above and the password will be changed.

Log in to MySQL:

Root User Login->mysql-u root-p

Enter your password (enter) to log in to your MySQL

New users are optional, depending on their own circumstances

Create a user

mysql> create user ' your username '; (carriage return)

\q (Exit)

->mysqladmin-u your new username-p password your new password

To enter the password this direct return can be, we did not set the password for the new user.

Then mysql-u your new user name-P

Enter the password for your new username, and it's OK.

For the perfect I downloaded the official database management tool MySQL Workbench

Address: http://dev.mysql.com/downloads/workbench/

Install direct drag on OK

Then your application panel will have MySQL Workbench

Enjoy the Tour!!

Installation of MySQL under Mac