Connecting to Amazon RDS MySQL Database

In this article, we are going to demonstrate the easiest way of how to connect to the Amazon RDS MySQL instance with dbForge Studio for MySQL. Follow us through the steps to successfully configure the RDS MySQL Environment in AWS.

Amazon RDS is a secure and reliable web-based service, which greatly simplifies the process of deploying, managing, and scaling relational databases in the cloud, thus, allowing you to connect at any time and from any place where Internet access is available.

Empowered by Amazon RDS for MySQL databases, you can:

  • Create, manage and scale MySQL databases in the cloud
  • Perform automated backups, snapshots and recoveries
  • Store and monitor database instances with a few clicks
  • Enhance performance and strengthen database security

How to deploy a MySQL database instance in Amazon RDS


Step 1. Open Amazon RDS console

First of all, you should sign in to the AWS Management Console, just as shown on the screenshot below.

Next, find RDS in the Database section of All Services and click to open the Amazon RDS Console.

Amazon RDS Console

Step 2. Create an Amazon MySQL instance

To create a MySQL database instance in AWS, go to Databases on the side menu and click Create database. In this step, you will need to pick a database creation method, configure engine options, and select a database version.

Please note that when selecting the Standard database creation method, you will have an opportunity to configure database options, including the advanced ones.

Afterwards, choose the MySQL engine and select the version below.
Creating AWS MySQL

Step 3. Select a template

Next, you will need to select a sample template for your future MySQL instance on Amazon RDS.

Depending on your use case, choose between the Production, Dev/Test, and Free tier option.

Pay attention that the Amazon RDS Free Tier is available for 12 months, and under this offer, you will receive 750 hours of RDS, 20 GB of general-purpose storage, and 20 GB for backups each month.

 Select MySQL on AWS template

Step 4-1. Provide settings for your MySQL database on AWS

In this step, you will need to define the instance settings.

First, provide a unique name for your instance.

After that, think of a suitable master username and password. Make sure you save them as you are going to use them later to connect to Amazon RDS via dbForge Studio for MySQL.

AWS MySQL settings

Step 4-2. Continue configuring your MySQL instance

After you have set up the credentials for your instance, let's go ahead and define your future Amazon MySQL instance size and storage options.

Pick a DB instance class, storage type, and allocated storage that fulfill your workload requirements.

Note that you can expand the allocated storage to a maximum of 65 TB with Amazon RDS for MySQL.

Continue configuring AWS MySQL

Step 4-3. Define connectivity options

We have now reached the Connectivity section. Here, you can provide all the necessary connectivity configurations for your MySQL instance on AWS RDS.

Please note that you can not change Virtual Private Cloud after you create the database.

Connectivity settings

Step 5. Define advanced settings for your MySQL on AWS

In this step, you will need to configure additional database options required for AWS RDS to launch your MySQL DB instance. You can enable database backup, enhanced monitoring, and maintenance.

In the Maintenance section, we suggest selecting Enable auto minor version upgrade to receive automatic updates as soon as they become available.

Please, note that if the Enable deletion protection option is enabled, you won't be able to delete the created database.

MySQL on AWS. Advanced settings

Step 6. Launch MySQL instance on AWS

After you have defined all the settings, you can finally click Launch DB Instance.

As soon as the instance process is finished (it might take some time), you will be able to check the status, together with some other configuration information in the corresponding window as shown on the screenshot.

To view the details of your MySQL instance, click the database instance name.

Check the details and click Create database to finalize the process.

View the created AWS MySQL database

Step 7. View MySQL instance details

Now, as we approached the Summary section, we can see the dashboard, as demonstrated on the screenshot. It provides MySQL instance details concerning recent events, including CPU Utilization, DB connections, Free Storage Space.

To check the necessary information, switch between the tabs. For instance, on the Connectivity & security tab, you can access the information that relates to MySQL Endpoint.

Note that you will later need to specify both the DNS address from the instance endpoint (as host) and the port number (as port) in the connection string to connect to the MySQL instance.

When the status of the instance is available, which means that the database instance has been deployed, you can go to dbForge Studio for MySQL to connect to Amazon RDS.

View MySQL instance details

Using dbForge Studio for MySQL to connect to Amazon RDS MySQL database instance

Connect to an Amazon RDS MySQL database

dbForge Studio is an excellent solution for SQL developers as it enables you to connect to AWS RDS instance from a local machine and facilitates your database experience with its powerful built-in features. To configure remote access to your Amazon RDS instance via dbForge Studio for MySQL, do the following:

1. In Database Explorer, click Database Connection. Optionally, you can go to Database on the Main Menu and click New Connection.

2. In the Database Connection Properties window, specify the Type of the connection, enter the Hostname, Port, User, and Password.

3. Once all the settings are configured, click OK.

Now that you have successfully set remote connections to AWS RDS, you may want to dive deep and learn how to import MySQL data to Amazon RDS and export data from Amazon RDS to the on-premises MySQL database.

Use dbForge Studio for MySQL to connect to MySQL database

Currently, Amazon RDS provides support for such database engines as Amazon Aurora, MySQL, MariaDB, PostgreSQL, Oracle, and Microsoft SQL Server. You can find detailed information on how to connect to the Amazon RDS MariaDB Database.

It stands to mention that dbForge Studio for MySQL can boast broad compatibility and connectivity options that are not limited just to Amazon RDS support.

Conclusion

As you can see for yourself, it does not pose any difficulties to connect to Amazon RDS: the process is pretty quick and requires just several clicks. After you have deployed the database instance, you can start managing your database and making the necessary modifications. Note that with such a useful assistant as dbForge Studio for MySQL, you can create queries, measure and improve performance, compare data and schemas, and a lot more!

dbForge Studio for MySQL

The best MySQL GUI tool for effective DB development