Connecting to a DB Instance from a Windows Server

Step 1: Test Connectivity and Install MySQL-Front

1. On the Instances page of the RDS console, click the DB instance name.
2. Choose Connectivity & Security from the navigation pane. In the Connection Information area, obtain the EIP and database port of the DB instance.
   Figure 1 Connection information
   

   If no EIP has been bound to the DB instance, see Binding an EIP.

3. Open the cmd window on your local server and check whether the EIP and database port of the DB instance can be connected.

   telnet EIP 3306

   • If yes, network connectivity is normal.
   • If no, check the security group rules.

     Check inbound rules in the security group of the DB instance. Add an inbound rule to allow the EIP and port of the DB instance. For details, see Configuring Security Group Rules.

4. Open a browser, and download and install the MySQL-Front tool locally (version 5.4 is used as an example).

Step 2: Connect to the DB Instance Using MySQL-Front

1. Start MySQL-Front.
2. In the displayed dialog box, click New.
   Figure 2 Connection management
   
3. Enter the information of the DB instance to be connected and click Ok.
   Figure 3 Adding an account
   

   Table 1 Parameter description

   Parameter	Description
   Name	Name of the database connection task. If you do not specify this parameter, it will be the same as that configured for Host by default.
   Host	EIP obtained in 2.
   Port	Database port obtained in 2. The default value is 3306.
   User	Name of the user who will access the DB instance. The default user is root.
   Password	Password of the account for accessing the DB instance.

4. In the displayed window, select the connection that you have created in 3 and click Open. If the connection information is correct, the DB instance will be connected.
   Figure 4 Opening a session
   

FAQs

What Should I Do If I Can't Connect to My RDS DB Instance?

Follow-up Operations

After logging in to the DB instance, you can create or migrate your databases.

• Creating a Database Using the Console
• Creating a Database Using an API
• Managing Databases Using DAS
• Migrating Data to RDS for MySQL