How to install and configure mysql5.7.12 in Mac OS10.11: graphic tutorial, os10.11mysql5.7.12

How to install and configure mysql5.7.12 in Mac OS10.11: graphic tutorial, os10.11mysql5.7.12

Install and configure MySQL on Mac OS10.11, as shown in the figure below.

First, visit the mysql official website and download the installation program. Of course, you need to register an account before downloading it.

Website address: MySQL download page. Download two installation programs: MySQL Community Server and MySQL Workbench.

MySQL Community Server

Click to enter the download page. At the bottom of the page, there is a download option. Make sure that the selected platform is Mac OS X, and then download the installation package marked in the red box. You need to log on to the account for download.

Run mysql. pkg directly after downloading. Note that the mysql password in the prompt box can be copied to the memo.

After the installation is complete, you can find MySQL in the system preference settings, open and run it.

Then, click Run MySQL Server. Generally, it is on by default when you start it. If you don't need it like me, you can cancel it.

After this step, you also need to know how to open MySQL from the terminal, because we still need to do a job.

Otherwise, there may be two problems:

1. Connection fails during Workbench connection, andTip:You must reset your password using alter user statement ....

2. When the Terminal is connectedTip:ERROR 1820 (HY000): You must reset your password using alter user statement before executing this statement.

I need to reset the password again !!!

Open the terminal and enter the following command:

PATH = "$ PATH":/usr/local/mysql/binmysql-u root-p # enter the password # Terminal display # Welcome to the MySQL monitor. commands end with; or \ g. your MySQL connection id is 10 Server version: 5.7.12Copyright (c) 2000,201 6, Oracle and/or its affiliates. all rights reserved. oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. other names may be trademarks of their respectiveowners. type 'help; 'or' \ H' for help. type '\ C' to clear the current input statement. mysql> # set password = PASSWORD ('new password ');

Next, download and install the SDK. The steps are as follows:

MySQL Workbench

Drag workbench.

After opening, check the main interface. MySQL in the main interface is followed by two buttons: The first plus button indicates that new MySQL Connection is created, and the second button indicates that Edit MySQL Connections is modified.

Create a new one and enter the password. After the Test Connection is successful, click OK.

This is the case later.

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.