Amazon Relational Database Service
Getting Started Guide (API Version 2013-02-12)
AWS Documentation » Amazon Relational Database Service (RDS) » Getting Started Guide » Connect to Your DB Instance
« PreviousNext »
View the PDF for this guide.Go to the AWS Discussion Forum for this product.Go to the Kindle Store to download this guide in Kindle format.Did this page help you?  Yes | No |  Tell us about it...

Connect to Your DB Instance

Connect to DB Instance

After you've authorized access to the DB Instance by creating a DB Security Group and your DB Instance is in the available state, you can connect to the DB Instance. The Amazon Relational Database Service takes care of the infrastructure management of your database instances. When a DB Instance is created, you can connect to it with any tools for the database engine that the instance supports.

Note

You must install any third-party database tools that you want to use with your Amazon RDS DB Instances; Amazon RDS does not provide or install any third-party tools or libraries.

In the following example, you use the MySQL command line tools to connect to the DB Instance you just created. The procedure is similar if you are connecting to an Oracle or Microsoft SQL Server DB Instance. For more information about using other DB engines, see the following topics in the Amazon Relational Database Service User Guide:

To connect to a DB Instance using the MySQL command line client

  1. On the My DB Instances page of the AWS management Console, select the check box next to the DB Instance named "mydbinstance."

  2. On the Description tab of the lower panel, note the endpoint of the DB Instance to use in the next step.

    Note

    The endpoint for your DB Instance isn't available until your DB Instance is in the available state.

    Console home

  3. Open a command prompt and enter the following command; make sure to use the endpoint of the DB Instance you created.

    PROMPT> mysql -h mydbinstance.c7hszkfowzmc.us-east-1.rds.amazonaws.com -P 3306 -u mymasteruser -p

    You will see output similar to the following.

    Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 350
Server version: 5.1.50-log MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

Note

If you are having trouble connecting, you may be having a problem with your firewall configuration. Contact your network security administrator to verify that you can connect to an external port on 3306.

Once you're finished with your new DB Instance, make sure to terminate it to avoid incurring further usage charges. Click the following button.

Get started

Document Conventions« PreviousNext »
Terms of UseDid this page help you?  Yes | No |  Tell us about it...