MySQL 8.0.21.0 Community Edition Installation Tutorial (Detailed Illustrations)

1. Download MySQL

Log in to the MySQL official website and download the MSI Installer:

Click "Dnownload"

Click “No thanks, just start my download.”

2. Install MySQL

Step 1: Select the installation type

Choose one of the installation types based on your needs:
Developer Default Developer default installation
Server only Install only the server (recommended)
Client only Install only the client
Full Install everything
Custom installation (recommended)
Click “Next”

Step 2: Select the products and content to be installed

All product contents are listed in “Available Products”;
"Products/Features To Be Installed" is the selected installation content;
Click the middle arrow to add or remove items to be installed.
Two contents are selected here: the server "MySQL Server 8.0.0.21" and the database visualization interface "MySQL Workbench 8.0.21". If you only need the server, select "Server only" in Step 1.

Click “Next”

Step 3: Execute the installation

Click "Execute" and wait for the installation to complete

After the installation is complete, click "Next"

Step 4: Configure MySQL

Click "Next" to configure MySQL

Select a data storage engine.
After selecting the default "Standalone MySQL Server/Classic MySQL Replication" storage engine.
"Innodb Cluster" is a cluster storage engine composed of several different MySQL products and technologies. At least three MySQL services must be installed.

Select the configuration type and database connection method.

Select "Development Computer" for the configuration type; leave the connection method as default, and remember the "Port" number (3306 by default, which can be modified if a conflict occurs).

Select an authentication method

The first "Use Strong Password Encryption for Authentication" password encryption authentication is more secure;
The second "Use Legacy Authentication Method" is compatible with MySQL 5.x version and has good compatibility.

Set account password

Enter the Root password. This password is very important and you will use it frequently in the future. Write it down in a notebook!

Configure Windows Service and configure MySQL Server as Windows Service.

You can change the "Windows Service Name", the default is "MySQL80"; choose whether to start automatically at boot, etc.

Apply configuration.

Click "Execute" and wait for completion.

Complete the configuration. Click “Finish”

Configure other products. Click “Next”

The only installation content selected in Step 2 that needs to be configured is MySQL Server, so all configurations are now complete.

Step 5: Installation Complete

Click "Finish" to complete the installation

3. Configure environment variables

When you install MySQL for the first time, the default installation path is usually "C:\ProgramFiles\MySQL\MySQL Server 8.0", and the default data storage path is "C:\ProgramData\MySQL\MySQL Server 8.0" (ProgramData is a hidden folder)

After finding the MySQL installation path, start configuring environment variables.

Step 1: Right-click "This PC", select "Properties", select "Advanced System Settings", and select "Environment Variables"

Step 2: Double-click "Path" in the system variables

If "C:\Program Files\MySQL\MySQL Server 8.0\bin" already exists, it means that the installer has automatically configured the environment variables;
If "C:\Program Files\MySQL\MySQL Server 8.0\bin" does not exist, you need to add environment variables manually. Click New and copy and paste "C:\Program Files\MySQL\MySQL Server 8.0\bin" into it.

4. Start MySQL service

Method 1:
Right-click "This Computer", select "Manage", select "Services", find the Windows Service Name: MySQL80 in Step 4, Step 6 when configuring MySQL earlier, right-click "Start"

Method 2:
Run CMD as an administrator and enter "net start MySQL80"

5. Modify the MySQL data storage path

MySQL saves data to the C drive by default. If the storage space of the C drive is limited, it is recommended to save the data to other drives.
Step 1: Shut down the MySQL service

Step 2: Create a new data storage path <br /> In other disks with sufficient space, create folders of different levels according to the following addresses (here we take disk G as an example), such as "G:\ProgramData\MySQL\MySQL Server 8.0"

Step 3: Modify the configuration file my.ini

Open with Notepad and modify "C:\ProgramData\MySQL\MySQL Server 8.0\my.ini"

Step 4: Copy the Data folder <br /> Copy the Data folder (do not delete) in the original "C:/ProgramData/MySQL/MySQL Server 8.0" path to "G:/ProgramData/MySQL/MySQL Server 8.0".

Summarize

This is the end of this article about the detailed installation tutorial of MySQL 8.0.21.0 Community Edition. For more relevant MySQL 8.0.21.0 Community Edition installation content, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope everyone will support 123WORDPRESS.COM in the future!