MySQL 8.0.17 installation and simple configuration tutorial under macOS

If you don’t understand what I wrote, there may be no tutorials on the Internet that you can understand.

Although this article is for version 8.0.x, the methods for MySQL configuration are still universal.

Environmental information and scope of application#

Environmental Information

Scope of application

Step 0: Clear the previous MySQL#

(Unless you want to install multiple versions)

Open the terminal, enter the following code, and execute

sudo rm -rf /Library/Recipts/mysql* sudo rm -rf /Library/Receipts/MySQL* sudo rm -rf /private/var/db/receipts/*mysql*

Step 1: Download the installation package#

Go to the official download address: https://www.mysql.com/downloads/, then at the bottom of the page, click to enter the community version download interface (as shown below 👇)

Select MySQL Community Server (as shown below 👇)

Select the version. Here, I selected version 8.0.17, and selected the macOS version according to the current system. For the convenience of installation, I directly selected the DMG format file (as shown below 👇)

MySQL Installation#

Double-click mysql-8.0.17-macos10.14-x86_64.dmg to start the installation (as shown below 👇)

Click 'Continue' (as shown below 👇)

If you need to change the installation location, you can modify it in this step (as shown below 👇). Here, just click Install according to the default configuration

If you select the first option (encrypt with a strong password), you can only connect to MySQL 8. It is recommended to select the second option (encrypt with traditional method) to be compatible with MySQL 5.x (as shown below). However, even if you select the first option, you can modify it later (see the second step of the MySQL management interface below)

If you choose according to the above picture, you will need to set a password of more than 8 characters with mixed numbers, letters or symbols (need to remember) (as shown below 👇)

Installation successful (as shown below 👇)

MySQL Management Interface#

After successful installation, the MySQL icon will appear at the bottom of the system preferences (as shown below 👇)

For the introduction of the management interface, click Start MySQL Server to start it. If you are afraid of trouble, you can set it to start automatically at boot. What needs to be emphasized here is that you can change the encryption method by clicking Initialize Database (as shown below 👇)

Click the installation location in the picture above to jump to the installation location (as shown below 👇)

Click Configuration in the management interface to configure the file location (as shown below 👇). Note the location of the Data Directory.

Configuring MySQL#

Open the terminal, the default shell is dash, you can use the following line 👇 code to change it to zsh, (most of the previous commands remain unchanged)

chsh -s /bin/zsh

If you want to switch back, use the following code to switch back to bash

chsh -s /bin/bash

It should be noted that after the replacement, you need to exit and reopen the terminal to take effect

View the shell currently used by MacOS, enter and execute the following line of code:

echo $SHELL # If the output result is /bin/zsh, refer to zsh terminal operation method. # If the output result is /bin/bash, refer to bash terminal operation method.

Terminal operation mode

If the shell is changed to zsh

Open the terminal, enter and execute the following code:

vim ~/.zshrc

If not changed, the default bash is used

Enter and execute the following code:

vim ~/.bash_profile

Then you will be in the vim editing configuration interface (as shown below 👇), type i, pay attention to the lower left corner, now enter the INSERT input mode

Then enter the following code to add the MySQL installation path to the environment variable.

export PATH=$PATH:/usr/local/mysql/bin

At the same time, you can also add the following two lines of code to set a shortcut command to open or close the MySQL server (as shown below 👇)

alias mysqlstart='sudo /usr/local/mysql/support-files/mysql.server start' alias mysqlstop='sudo /usr/local/mysql/support-files/mysql.server stop'

You can also change the mysqlstart and mysqlstop commands above to the commands you are familiar with, corresponding to the opening and closing of the server respectively.

After that, press esc to exit insert mode and enter :wq (there is :oh) (note the lower left corner as shown below)

After executing the above figure, you will exit the vim editing interface, then enter and run the following 👇 code to save the previous configuration (as shown below 👇)

source ~/.zshrc

If not changed, the default bash is used

Enter and execute the following code:

source ~/.bash_profile

Finally, you can enter and execute the following code to confirm whether the addition is successful:

echo $PATH

If the addition is successful, the sentence /usr/local/mysql/bin will appear

Start MySQL Service#

Method 1: Follow the shortcut method mentioned in Configuring MySQL. You can start MySQL by typing mysqlstart in the terminal.

Method 2: Start the MySQL service according to the method described in the MySQL management interface above (as shown below 👇)

Method 3: Alternatively, enter and run the following 👇 code in the terminal: (You will be asked to enter the macOS login password)

sudo /usr/local/mysql/support-files/mysql.server start

You can also start the MySQL server

Tips

Starting MySQL
.Logging to '/usr/local/mysql/data/Kit-away.local.err'.
SUCCESS!

After that, enter and run the following 👇 code: (You will be asked to enter the password of more than 8 characters set when installing MySQL)

mysql -uroot -p

Then successfully start the MySQL client

You can try to execute the following code:

show databases;

If the following is displayed, it means that it is successfully run as an administrator

+--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ 4 rows in set (0.01 sec)

Download Link:

https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.17-macos10.14-x86_64.dmg

Summarize

The above is the illustrated tutorial of MySQL 8.0.17 installation and simple configuration under macOS introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!