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

Procedure

1. Create an ECS instance that runs Windows Server 2012. For more information, see Create an instance on the Custom Launch tab.

2. Connect to an ECS instance.

   For more information, see Connect to a Windows instance by using a password or key.

3. Add an inbound rule to a security group of the ECS instance to allow traffic on port 3306. For more information, see Add a security group rule.

4. Download a MySQL installation package from the official MySQL website.

   In this topic, the MySQL 5.6.15.0 installation package is used.

5. Install MySQL on the ECS instance.

   1. Double-click mysql-installer-community-5.6.15.0.msi to install MySQL.

   2. Select Install MySQL Products.

      

   3. Select I accept the license terms and skip the update check, click Next, and then select Custom. In the right pane, specify the installation location and database location of MySQL, and click Next.

      In this example, the default installation location and database location of MySQL are used.

   4. In the dialog box that appears, select I have read and accept the license terms. and click Install.

   5. After the installation is complete, click Finish.

   6. Retain the default values, click Next, and then click Execute to install MySQL.

      

   7. Click Next to go to the Configuration Overview page. Then, click Next.

      

   8. Select Server Machine from the Config Type drop-down list.

      

   9. Retain the default values, click Next, and then enter the password for the MySQL administrator (root) user to complete the installation.

   After you install MySQL, the MySQL Command-Line Client icon appears on the start page.

6. On the Windows Server 2012 desktop, click the icon and then click the icon. On the Apps page, double-click MySQL 5.6 Command Line Client.

7. In the dialog box that appears, enter the password for the MySQL administrator (root) user to log on to MySQL.