Install MySQL on MAC

install Mysql
Installation method using visual interface .
1、 Sign in Mysql Its official website ,mysql Download the official website

2、 download “ Community version of Mysql”, Click on Mysql Community(GPL) Downloads.

3、 And then choose Mysql Community Server.

4、 Next, go to the present page , Here is a link to this download , We choose “DMG Format ” Download link for . Be careful ： Be sure to choose macOS System .

5、 Downloaded dmg After installing the package in format , The next installation is relatively simple , It should be noted that ：
（1） Be sure to choose Use Legacy Password Encryption.（ remarks ： Because I've chosen... Before Use Strong Password Encryption, But sometimes there will be problems running the project ）

（2） Be sure to enter the password , This password is also login mysql Password , It's very important . remarks ： If it is 8.23 After version Mysql, Then when entering the password, you need to enter at least 8 position .

6、 For the rest of the installation, just click continue .
7、 see Mysql Is the installation successful , Need to click “MAC System preferences in ”, And then click Mysql Icon

  Get into Mysql After the interface , If it's two green circular icons , shows Mysql It has been installed successfully .

install Workbench
Recommend a visual operation software Workbench（ Can not be installed ）

To configure Mysql
If you need to input... In the terminal Mysql command , Then the following configuration is required .

1、 Open file ：vi ~/.bash_profile
2、 Add the statement ：PATH=$PATH:/usr/local/mysql/bin
3、 Make the configured statement effective ：source ~/.bash_profile

If the configuration is successful , So enter the command ：mysql -uroot -p, The operation effect is as follows ：

  At this point, enter the login password and you can use .
If the above running picture cannot appear , It indicates that the configuration of the environment failed .

To configure Mysql Pit encountered by environment variable
We were in bash Configuration in environment Mysql, So when the computer restarts or shuts down, it may appear mysql In case of command failure . This is also a pit I encountered , The solution is as follows ：

stay ~/.zshrc At the end of the document , Add a row ：
source ~/.bash_profile
1、 without ~/.zshrc file , Then you need to execute the command touch ~/.zshrc; conversely , If there is zsh file , Then you can skip this step , Go straight to 2 Step .
2、 perform vi ~/.zshrc command , Then add source ~/.bash_profile that will do ; As shown in the figure below ：

3、 Then you can solve the problem after the computer restarts mysql The problem of command failure .