Setup RDS MySQL server that is accessible over the internet

 Setup RDS MySQL server that is accessible over the internet

Steps:-

1. Search for RDS service in AWS console.


2. Create a database


3. Give appropriate name and password.


4. Make your Database publicly accessible.


5. Finally create database.


6. RDS successfully created.

    


7. Now let's connect to the RDS using AWS CLI. First generate the authentication token with following command

                       aws rds generate-db-auth-token \                                                                   
                    --hostname database-1.cn2qjigxwzyc.us-east-2.rds.amazonaws.com \
                    --port 3306 \
                    --region Ohio \
                    --username admin
8. Once token is generated, you may connect to Mysql using the following command





Comments

Post a Comment

Popular posts from this blog

Creating Virtual Machine in Oracle Virtual Box

Image
 Creating Virtual Machine - 19BCS009 Step1:Install Oracle VM VirtualBox Manager Step 2: Name the operating system as Serjeel and select the type as Ubuntu Step 3:Choose to create a virtual hard disk now Step 4:The hard disk type should be VDI that is Virtual Disk Image Step 5: A Virtual Machine with Name: Serjeel and Operating System: Ubuntu is created. Step 6: Installing Ubuntu Step 7: Installed Ubuntu
Read more

Setting up Replication in S3 Bucket

Image
 Setting up Replication in S3 Bucket Steps:- 1. Go to aws console for S3 bucket and select the bucket you want to replicate. 2. go to management tab and click on create replication rule. 3. Give name to replication rule 4. Apply rule to all objects in this bucket. 5. Create a new IAM role. 6. Choose another bucket replicate to. 7. Click on save 8. Enable versioning for this bucket. 9. Set job settings. Uncheck completion report. 10. The replication job was completed. 11. Replication rule was successfully set on bucket.
Read more

Setup DynamoDB and perform CRUD

Image
 Setup DynamoDB and perform CRUD operations Steps:-  1. Search for DynamoDB on AWS console 2.      Give appropriate name and primary key for your table. 3. Then create table 4. Create a new item  7. Give appropriate values to the fields in table. 8. Succefully inserted.
Read more