Menu
I have created an e-commerce site in angular js. And I need to host the same in amazon web service.
So inorder to host the same I created an ec2 instance first. Now after that added an rds instance with a security group of VPC by allowing all ip's as outbound and inbound. While creating security group I specified for mysql and for all connection. Still after I remotely loged into the instance and try to connect to the end point from rds instance using
mysql -u username -p password -h ********.ap-southeast-1.rds.amazonaws.com:3306
I get an error
ERROR 2005 (HY000): Unknown MySQL server host xxxxxxxxx (0)
I created the instance from Asia Pacific (singapore) region since I am a resident of india.
666
Amazon Aurora with MySQL compatibility is also built using MySQL, and Amazon RDS supports the popular MySQL fork project, MariaDB. You can also host MySQL on Amazon EC2 and self-manage the database, or browse the 3rd party MySQL offerings on AWS Marketplace.
Amazon RDS for MySQL is a managed database service that makes it easy to set up and run MySQL deployments in the cloud. It's easy to get started. Sign up for the AWS Free Tier and create your own MySQL database in minutes. For more information, review the Getting Started Guide.
Follow the steps below to connect MySQL Workbench to your Amazon RDS DB instance: Download and install MySQL Workbench. Open MySQL Workbench, and then choose the ⊕ sign beside MySQL Connections to set up a new connection. In the Setup New Connection dialog box, enter a name for your connection.
It should be ********.ap-southeast-1.rds.amazonaws.com instead of ********.ap-southeast-1.rds.amazonaws.com:3306
You do not need the port number in the end.
113
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
