Mac system OS X10.10 version installs the latest 5.7.9mysql method _mysql

Friends with the Mac are reflected very good, not only beautiful, good performance, the key is that the bottom of his system for developers, is undoubtedly one of the greatest benefits, with the habit of Linux people know the powerful Mac.

But there is also a bit of the most pain is that the habit of the Mac and Windows two concepts, accustomed to Windows, will inevitably be a bit overwhelmed. Even the installation of software can be very different.

Recently installed SVN, and then installed MySQL, toss to not like the face, and finally look at the official documents and information on the network, only slowly understand.

About the current MySQL version of the problem and the Mac system under the 10.10 MySQL problem, online almost no data, after two days of repeated installation tests, finally finished.

In fact, mysql5.7 because many places are different from the old version, the content installed on the Mac is also different, but the installation of the matter and windows on the mysql5.7 can be used as a reference.

Here's what I'm doing.

1. Download and install the MySQL main program

First go to the official website to download MySQL, currently my Mac version is 10.10.5 OS X Yosemite, for this version of MySQL on the corresponding version is 5.7.9.

To add a few points here, after 5.7 MySQL no longer need to install the MySQL boot: mysql_startupitem.pkg.

So under MySQL there is only one DMG master file.

After downloading and installing, go to the last line in your preferences to see the MySQL service, which is the channel to manually open/close the service.

Here Please note: MySQL installed after 5.7 no longer uses the old version of the default password: root, the installation process will appear a window prompts, there is a temporary password, please copy out to save, will need to use it later,

He is the default password.

2. Modify the default password

After the installation of the successful use of temporary password login to MySQL, see if you can log in, if possible, the following will be the temporary password changes.

(Warm reminder: Operation MySQL command There are two ways, one is to set the MySQL environment variables, so you can directly use the MySQL command without the need to enter the mysql/.) The/bin directory executes. The other is to go directly to the/usr/local/mysql/bin/to execute the script)

Using the temporary password login after success there will be such a hint: You must reset your password using ALTER USER statement before executing this statement.

This is a hint that you need to reset the password.

Execute this command:

Copy Code code as follows:

Mysqladmin-u root-p Password

Then enter your temporary password, after success will

Copy Code code as follows:

New Password:
Confirm New Password:

Let you enter the new password.

The next occurrence is since password will is sent to server in plain text, with the use of SSL connection to ensure password. This is just a hint that can be ignored.

Next you can go back in with the new password login mysql, if there are mysql> out, indicating successful landing.

Here, I've been tossing things up for two days, and it's done.