Now let's create our first instance by calling the createDBInstance(): amazonRDS.createDBInstance(request) The list is available hereĬreateDBInstanceRequest request = new CreateDBInstanceRequest()
Once you hit Enter, your password will be needed. Step 8 : Open your MySQL shell, and paste the command with your username, endpoint, and port number. Both are required for connecting with the local shell. In the below screenshot, Number 1 is the endpoint value and Number 2 is the port number. Step 7 : Now as it is available, you are going to connect it with your local MySQL shell.īefore connecting it to the shell, click on your database, copy the endpoint of your database, and paste it in a notepad file.
Click on the View DB instance details button Step 6 : Now, wait till the database is created and the status changes to Available. Else, whenever you want to delete a database, you could just modify Deletion protection and delete it. If you are just practicing and will delete the database after creation, then disable Deletion protection. If you do not provide a database name in this stage, you can create one after connecting with the local shellĪfter that, go down to Backup, select the Backup retention period as 0 days, and uncheck the Copy tags to snapshots box below Step 5 : In the Configure Advanced Settings section, go down to Database options and provide Database name. Just go down to the end and provide DB instance identifier, Master username, which is given as intellipaat here, and Master password.
Step 4 : Don’t change any settings in the Specify DB details section.
Then, choose MySQL database engine and select the Only enable options eligible for RDS Free Usage Tier checkbox Step 2 : Click on RDS in the Services drop-down
Hands-on: Creating a MySQL RDS Instance and Connecting It to Your MySQL Shell Interested in learning AWS? Go through this AWS Tutorial! Now that we understand what is Amazon RDS and what are its benefits, let’s move on with this Amazon RDS tutorial and learn about various Database engines that RDS offers.
AWS automatically installs the latest software patches to the RDS instance which you have launched.