MAC OS system installation MySQL

MAC OS10.11 Install and configure MySQL, mainly diagram, step I briefly explain.

First visit the MySQL official website and download the installation program, of course, before downloading you need to register a line account.

Website address: MySQL download page, download two installer: MySQL Community Server, MySQL Workbench.

MySQL Community Server

Click to go to the download page, at the bottom of the page, there are download options, please confirm that the selected platform is Mac OS X, and then download the installation package marked with a red box. You will need to log in when downloading.

After download run, run mysql.pkg directly, in this process need to pay attention to a little, note, the password in the notification box, you can copy the password information into the memo.

After the installation is complete, you can find MySQL, open and run in System preferences.

Then, click Run MySQL Server, the general self-boot is on by default, if you do not need the same as me, can be canceled.

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 are two issues that may be the following:

1, connection failure in Workbench connection, and prompt: You must reset your password using ALTER USER statement ....

2, in terminal terminal Connection prompt: Error 1820 (HY000): You must reset your password using ALTER USER statement before executing ment.

The main thing is to reset the password again, Pit Daddy Ah!!!

Open 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 TenServer Version:5.7. ACopyright (c) -, ., Oracle and/or its affiliates. All rights reserved. Oracle isA registered trademark of Oracle Corporation and/or Itsaffiliates. Other names trademarks of their respectiveowners. Type'Help ;'Or'\h'  forHelp. Type'\c'To clear the current input statement.mysql>#SET PASSWORD= PASSWORD ('New Password');

Next download and install, the basic steps are as follows:

MySQL Workbench

Drag the workbench into the.

After opening, please look at the main interface, the main interface after MySQL followed by two buttons: The first plus button indicates new MySQL connection, the second represents the edit MySQL connections modification.

Create a new one and enter the password. When Test connection is successful, click OK.

After that.

MAC OS system installation MySQL