Connect to the Amazon Relational Database Service (RDS)

You can connect to the Amazon RDS database from the runtime server (the EC2 instance running the application) or the principal server, that includes the mysql client tool. Follow the steps below:

  • Obtain the hostname for your RDS instance from the “Endpoint” field in the RDS dashboard, as shown below:

    RDS host information

  • Log in to the runtime server console via SSH.

  • Use the mysql command-line tool to connect to the Amazon RDS database, as shown below. Replace the HOSTNAME placeholder with the actual hostname for the Amazon RDS instance.

      $ mysql -u root -p -h HOSTNAME

    You will be prompted to enter the root user password. This is the same password you configured when deploying the Multi-Tier Solution.

Last modification March 6, 2020