mac System OS X version 10.10 How to install the latest 5.7.9mysql

Friends who have used mac report that it is very easy to use, not only beautiful, good performance, the key is that the bottom layer of his system for developers, is undoubtedly one of the biggest benefits, linux people used to know the power of mac.

But one of the worst things about mac is that it's the same as windows, so it's hard not to know what to do with windows. Even the installation of software varies greatly.

Recently, After loading svn and then LOADING mysql, I did not look like a human being. Finally, I got to know it slowly after reading the official documents and information on the Internet.

As for the problems of the latest version of mysql and the problems of mysql of 10.10 in mac system, there is almost no information on the Internet. After two days of repeated installation and testing, the problem is finally solved.

In fact, es20EN 5.7 is different from the old version in many aspects, and the installation content on mac is also different, but the installation matters are different from es23EN 5.7 on windows.

Here's how I did it.

1. Download and install mysql main program

First, go to the official website to download mysql. At present, my VERSION of mac is 10.10.5 OS X Yosemite, and the corresponding version of mysql is 5.7.9 for this version.

It is worth adding that mysql after 5.7 no longer needs to install the startup of MySql: MySQL_StartupItem.pkg.

So the next mysql has only one dmg master file.

After downloading and installing, go to the last line of preferences to see service for mysql, which is the channel to manually turn on/off the service.

Please note here: mysql installed after 5.7 will no longer use the default password of the old version: root. During the installation process, a popup prompt will appear. There is a temporary password, please copy and save it, and it will be needed later.

It's the default password.

2. Change the default password

After the installation is successful, log in to mysql with a temporary password and see if you can log in. If you can, the temporary password will be changed below.

(Warm reminder: There are two ways to operate the mysql command, one is to set the mysql environment variable, so that you can use the mysql command directly without entering the mysql/.. /bin directory. The other one is to directly enter/usr/local/mysql bin/execute the script below)

When you login successfully with a temporary password, you will receive a prompt like this: You must reset ES801en ALTER USER statement executing this statement.

This is a reminder that you need to reset your password.

Execute the command:

mysqladmin -u root -p password  

Then enter your temporary password. It will be successful

New password:  

Confirm new password:  

Let you enter a new password.

This was followed by Since password will be sent to server plain text, use ssl password safety. This is just a hint. You can ignore it.

You can then go back in and login mysql with your new password, if you have mysql > Come out, that means you've landed successfully.

So here, what I've done in two days is done.