EX — 7b SETUP A RDS MYSQL SERVER IN AWS

My experience regarding setting up of RDS MySQL server in AWS. The pre-requisites required for the following are

  • An AWS account
  • MySQL workbench

The steps performed by me are as follows

  1. Navigate to Amazon RDS service and create a database as follows keep all the settings in default as chosen by AWS but remember to change the access to public




2. And the second change that one has to consider is creation of new security group with the following rules

3. After the database status becomes healthy, open MySQL workbench and click on the plus symbol to create a new connection copy the host name from newly created database in RDS and use the master password for creation of database in connection settings



Now perform all the required operation as you need from MySQL workbench




Comments

Post a Comment

Popular posts from this blog

EX — 6 Hosting a static website on Amazon S3 ​

Image
 H osting of static website on Amazon s3. The pre-requisites required for the following are An AWS account Static webpage that is previously created by you Navigate to s3 services in AWS console and create a new bucket providing the website name and make sure that you provide public access to the bucket during creation 2. Open the created bucket and enable website hosting under static website hosting options 3. In the fields of index and error document provide landing page file name and 404 page file name 4. Now its time to upload static website files so inside the bucket choose upload option and upload all the files required for hosting 5. Now navigate to permissions tab and enter bucket policy tab and type the following command but do not forget to change the resource field with you bucket ARN { "Version" : "2012-10-17" , "Statement" : [ { "Sid" : "PublicReadGetObject" , "Effect" : "Allow" , "Principal...
Read more

Cloud Computing and it’s future.

Image
  Cloud Computing and it’s future. The first “cloud” image on Google The term ‘cloud’ is quite widespread today in computer science and information technology. There are numerous cloud service providers that are commonly known, which include AWS, Microsoft Azure and the Google Cloud among many others. But what exactly is the cloud and how is computing associated to it? Wikipedia describes it as on-demand computer system resources such as storage or computational power which can be used by any user without its management. This refers to the on-demand delivery of IT and computing resources, applications and data centers via the internet on a pay-for-use basis. This means that computational intensive work can be offloaded onto someone else’s computer which works on your behalf. So, this way we could get work done without owning expensive equipment or trouble ourselves with its maintenance hence reducing capital expenses. The mentioned cloud service providers need to have...
Read more