Скачать или смотреть How To: Connect RDS MySQL From Local Machine (2 Min) | AWS

In this tutorial, you'll learn how to connect to AWS RDS MySQL database from a local host.

—
Facebook:   / gokcedbsql  
—
Video Transcript:
_
Hi guys, this is Abhi from Gokcedb. In this video, you are going to learn how to connect to the RDS MySQL Database from your local machine. Let’s start by searching for RDS on the AWS Console then click on Databases.

It creates a database and then selects MySQL with a prettier template. Give your DB instant a name then select the username and password. I am going to leave the default values for most of the configuration options.

However, for public access, I am going to say yes. After hitting the Create Database button, you should see the instant name and creating status. Once the status changes to back up, you are ready to connect.

Next, click on your database instance and copy the endpoint.  Now, open the Database Client from your local machine for example Dbeaver. Right-click on the connection, then hit create connection.

Select MySQL then click on next. Paste your endpoint in this server host text box, then enter your username and password.  Before you click test connection, go back to AWS and click on your VPC Security Group.

Click on the Inbound Rules tab, then hit edit Inbound Rules. Click on Add rule, then for Custom TCP enter 3306 for Port. For Source, you can select anywhere IP or my IP then hit save.

Since I already have a similar Rule, I’m getting an already excess error. So, I’m just going to click cancel. Go back to Dbeaver and hit the test connection.  Seems to be working as expected, hit the finish and now you should be able to expand your connection.

Looks like there is a default database called Says, there already exists. So, I am going to right-click on it and click on Open SQL Script. Here, you can write a query like select start from sys. sys underscore config and executed it.

There you have it. Make sure you like, subscribe, and turn on the notification bell. Until next time.