|« PreviousNext »|
|Did this page help you? Yes | No | Tell us about it...|
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.
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
On the My DB Instances page of the AWS management Console, select the check box next to the DB Instance named "mydbinstance."
On the Description tab of the lower panel, note the endpoint of the DB Instance to use in the next step.
The endpoint for your DB Instance isn't available until your DB Instance is in the available state.
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>
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.