How to connect to aws rds with mysql?

Question

I want to connect MySQL using AWS RDS. How can I achieve this?

Answer 1

For connecting your RDS DB instance using the MySQL client, follow the commands in the command prompt.  Provide DNS name(endpoint) of your DB instance in -h, provide the port of your DB instance in -p and enter the master user with its respective password.

mysql -h mysql–instance1.123456789012.us-east-1.rds.amazonaws.com -P 3306 -u mymasteruser -p

Want to learn more about AWS, and become a master by enrolling for Intellipaat's AWS Solutions Architect Certification!

For more information, check out this AWS Tutorial.