All Products
Search

This Product

    Elastic Compute Service:Deploy a MySQL database on a Windows ECS instance

    Document Center

    Elastic Compute Service:Deploy a MySQL database on a Windows ECS instance

    Last Updated:May 15, 2025

    MySQL is an open source relational database management system that supports SQL language and is suitable for the development of various applications. This topic describes how to manually deploy a specific version of MySQL database on an Elastic Compute Service (ECS) instance that runs Windows.

    Prerequisites

    • A public IP address is automatically assigned to the ECS instance. Alternatively, an elastic IP address (EIP) is associated with the ECS instance. For instructions on how to enable public bandwidth, see Enable public bandwidth.

    • An inbound rule is added to a security group of the ECS instance to allow traffic on port 3389. For more information, see Add a security group rule.

    Procedure

    Note

    In this example, Windows Server 2025 and MySQL 8.0 are used.

    1. Use Workbench to connect to a Windows instance over RDP.

    2. Go to the official MySQL website to download the MySQL installation package.image

    3. Open the installation package, select Server only to install only the server, and then click Next.image

    4. Click Execute to check the environment. If some components are missing, the system displays the installation wizard. Follow the wizard to complete the installation. After the check is complete, click Next.image

    5. Click Execute to run the installation program. After the installation is complete, click Next.image

    6. Click Next to enter the setup wizard.image

    7. Continue clicking Next until you go to the Accounts and Roles page and then specify the root user password.image

    8. Click Next, confirm the settings, and then click Execute.image

    9. Click Next and then click Finish to complete the database installation.image

    10. Search for mysql in the Start menu, find and open the MySQL command line client to verify that you can connect to the MySQL database as expected.image

    References

    • You can use ApsaraDB RDS to efficiently manage your databases and build a managed database service that provides high availability, reliability, security, and scalability. ApsaraDB RDS is a stable, reliable, and scalable relational database service provided by Alibaba Cloud. ApsaraDB RDS supports the MySQL, SQL Server, PostgreSQL, and MariaDB database engines and provides solutions for scenarios such as disaster recovery, backup, restoration, and migration. For more information, see What is ApsaraDB RDS?

    • You can use Alibaba Cloud Data Transmission Service (DTS) to smoothly migrate data from self-managed databases to Alibaba Cloud databases. For more information, see Overview of data migration scenarios and Migrate data from a self-managed MySQL database to an ApsaraDB RDS for MySQL instance.