Amazon RDS – MySQL Connecting to DB

To connect to Amazon RDS MySQL DB we need a client software. In this case we use MySQL Workbench.

After it is successfully installed we follow the steps below to connect it to the Amazon RDS.

Step-1

From the DB instance details get the end point.

mysql_end_point_dtls.JPG

Step-2

Use the end point and the master user credentials as the connection details.

mysqlconn.jpg

Step-3

Once connected, we get the following window.

mysql_sucefully_connected.JPG

Step-4

We can browse the DB and query the DB now.

mysql_query.jpg