MySQL Installer 8.0.21 installation tutorial with pictures and text

1. Reason

I just needed to reinstall MySQL on a new system, so I wrote a download and installation tutorial for your reference in case you forget the details in the future.

2. Version Notes

MySQL Installer 8.0.21

3. Download the installation package

Method 1: Download from the official website

Go to the official website to download the required installation package: https://www.mysql.com/ (as shown below), or directly click https://dev.mysql.com/downloads/windows/installer/ to view the latest version.

insert image description here

Method 2: Mirror download

The download speed of the official website is too slow. Finally, I found a mirror download from Beijing Institute of Technology: http://mirror.bit.edu.cn/mysql/downloads/MySQLInstaller/

insert image description here

4. Installation steps

Step 1: Select the installation type according to your personal needs

insert image description here

Step 2: Select the content to be installed

insert image description here

Step 3: Customize the installation path

insert image description here

Step 4: Check the requirements and install them if the required environment does not exist

insert image description here

Step 5: Execute the installation

insert image description here

Step 6: Configure MySQL

insert image description here

① Select the data storage engine

insert image description here

② Select the configuration type and database connection method

insert image description here

③ Select the authentication method

insert image description here

④ Set account password

insert image description here

⑤ Configure Windows Service (ie: configure MySQL Server as Windows Service)

insert image description here

⑥ Application configuration content

insert image description here

★Problems caused by configuration

Question 1: How to delete the Window Service that caused the error

The configuration failed. I wanted to go back to the previous step to see if it was because I did not check the option to automatically start the system at startup. Then I found that I could not go back to the Apply Configuration page. I had to change the name of the Window Service to MySQL8021. This caused a Window Service that failed before. I wanted to delete it.

Solution:

Step 1: Use cmd batch command to uninstall (Note: cmd must be run in "Run as Administrator" mode, otherwise it will produce "[SC] OpenService 失敗5:拒絕訪問" error)

Net Stop ServiceName //If the service is not started, you can skip this step sc delete ServiceName //Uninstall the service

Step 2: Find the system registry, delete the registry information of the service, find MySQL80 under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete the file

Step 3: The MySQL80 service is still displayed in the service list. Use administrator privileges to open the cmd command sc delete serviceName . If the prompt " the specified service is marked as deletion " is displayed, close the Window Service panel and reopen it. You will find that the MySQL80 service has disappeared.

Question 2: How to solve the error when starting the server?

After changing the name of the Window Service to MySQL8021 and returning to the Apply Configuration page, an error still occurred at the Starting the server step.

insert image description here

By checking the log, you can find:

insert image description here

Solution: Find the MySQL8021 service, right-click "Properties" → "Login" → Select "Local System Account"

insert image description here

Go back to the installation program and click Execute again. You will find that you can successfully reach the Finish page.

insert image description here

Step 7: Configure MySQL environment variables ① Configure MYSQL_HOME variable

insert image description here

② Configure Path variables

Find the path and edit: Enter %MYSQL_HOME%\bin

insert image description here

Open cmd and enter mysql –u root –p
Enter the root password. Strangely, the password set during installation seems to be invalid. I guess it is because of the login settings in window services.

insert image description here

References:

MySQL 8.0.21.0 Community Edition Installation Tutorial (Detailed Illustrations)

https://www.jb51.net/article/193126.htm

How to completely delete and uninstall MySQL in Windows 10

https://www.jb51.net/article/118052.htm

MySQL 8.0.20 installation tutorial and detailed tutorial on installation issues

https://www.jb51.net/article/186202.htm

Summarize

This is the end of this article about the detailed graphic installation tutorial of MySQL Installer 8.0.21. For more relevant MySQL Installer 8.0.21 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!

You may also be interested in: