Making MySQL connection on AWS

Question

I am writing MySQL code using Python using MySQL Connector. Code is -

I have implemented this locally, and it is working properly. Now I want to deploy this file on AWS server. Its not working over there. What changes should I make, so that this code work on AWS server as well.

Thank you!!

Mayank Raj · Accepted Answer · 2020-06-30 04:40:27Z

3

Depending on where you are hosting the database, the connection details would change accordingly:

Hosting Database yourself on the server itself (not recomended): If your database instance lies on the same server then your code should work as it is. This is because the host will still be localhost and you have configured the credentials appropriately. In cloud enviornment this is not recomended for various reasons - if your instance goes down, the database goes down as well and more importantly you will have to manage the database which includes things like backups, mirroring, scaling etc
Use Amazon Relational Database service - RDS (recomended): Depending on the type of security you want to implement, you can take any one of the routes mentioned here. Essentially you use the endpoint of the RDS instance as the host. As for authentication, you can go the normal route of configuring username and password when configuring the instance.

RDS is the recomended way to go as being a managed service, you offload a lot of heavy lifting that comes with managing a database to AWS. If you are starting out, RDs also Free Tier bundle (link)

Note: While provisioning the RDS instance or whike updating it, be sure to mark the option of "Enable Internet Access". This will make it possible for you to access the database via the internet eg outside the VPC, from your home etc

answered Jun 30, 2020 at 4:40

Mayank Raj

1,62412 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gaurav Gupta Over a year ago

I am using RDP for my server deployment.

Achyut Vyas · Accepted Answer · 2020-06-30 07:05:09Z

1

@Mayank Raj's answer is right, although I want to add something. if you want to deploy database server on RDS or any other server make sure you allow Port 3306 (MySQL Port) in the security group of EC2 instance.

answered Jun 30, 2020 at 7:05

Achyut Vyas

5011 gold badge7 silver badges19 bronze badges

Collectives™ on Stack Overflow

Making MySQL connection on AWS

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related