Docs

Elastic Compute Service

Deploying databases

Manually deploying MySQL databases on Windows instances

This topic describes how to manually deploy MySQL on Windows instances using the "mysql-installer-community" installation tool.

tip

This topic involves third-party product information, which is for reference only. VolcanoEngine does not make any implied guarantees or other forms of commitments for the performance, reliability, or potential impacts of operations that involve any third-party product.

Prerequisite

You have purchased a Windows-based instance. For more information, refer to Purchasing an instance by following the wizard.

In the example provided in this topic, Windows Server 2019 is used. The operating system may differ slightly depending on the version.

Go to the MySQL official website.

Select the target version, click the "Download" button to download the mysql-installer-community installation package.

This practice uses the "mysql-installer-community-8.0.42.0.msi" version as an example. Different versions may vary slightly.

Install the installation package downloaded.

Double-click the installation package "mysql-installer-community".

tip

If the installation package opens automatically after being downloaded, skip this step.

Select "Custom", and click the "Next" button.

In the product directory on the left, select the version "MySQL Server 8.0.42-X64" to be installed, and the corresponding "MySQL Documentation" and "Samples and Examples". Then, click "Next" to proceed to the next step.

tip

As needed, you can select the MySQL version of the product to be installed from the product directory on the left and add it to the installation list on the right. To ensure compatibility, we recommend that you keep selected items such as "MySQL Documentation", "Samples and Examples", and other items in the same version as the MySQL version.

MySQL Documentation: provides MySQL documentation covering information such as detailed descriptions and user guides. You can install it based on your needs.

Samples and Examples: provides example codes and example databases, which help you quickly understand and get started with MySQL features. You can install it based on your needs.

Check dependencies

If any uninstalled dependency package is detected, please click the "Execute" button to download it.

After the download is complete, you will automatically enter the dependency package installation interface. Select "I agree to the license terms and conditions", and click the "Install" button.

After the dependency package is installed, click the "Close" button.

Click the "Next" button. Verify that the list of products about to be installed is correct, and then click the "Execute" button.

Wait until the installation succeeds, then click "Next".

Configure MySQL Server

On the "Product Configuration" page, click the "Next" button.

Click the "Config Type" drop-down list and select "Server Computer". Then, click "Next".

For other configurations, we recommend that you use the default settings, or you can configure them as needed.

Keep the default values, and click the "Next" button.

Set the MySQL root account password, and then click the "Next" button.

tip

The root account in MySQL is a super administrator account. It has all database permissions, such as creating databases, modifying user permissions, and reading/writing any data.

Please keep your root account password safe for future use, such as logging in to MySQL.

You can also click "Add User" to create a new account as needed.

Keep the default settings on the "Windows Server" page, and click "Next".

Keep the default settings on the "Server File Permissions" page, and click "Next".

Click the "Execute" button to configure the application. Wait until the application is configured, and then click "Finish" to complete the configuration of MySQL Server.

Click the "Next" button to configure "Samples and Examples".

Enter the root account password configured in the previous steps, and then click the "Check" button to verify the connectivity of the MySQL database.

When a check mark (✔) and the message "Connection successful" are displayed, the installer has confirmed that the root password is correct and the local MySQL service has been started. Click "Next" to proceed.

Click the "Execute" button to configure the application.

Wait until the application is configured, click "Finish" to complete the configuration.

On the "Product Configuration" page, click the "Next" button.

Click the "Finish" button to complete the installation.

Verify deployment results

In the Windows menu, select "MySQL > MySQL 8.0 Command Line Client" to open the MySQL command line page.

Enter the root account password configured in the previous steps, and press the "Enter" key to log in to MySQL.

If the following information is displayed, the MySQL database has been deployed.

Last updated: 2026.06.18 17:48:27