Clever Geek Handbook

How do I connect to Amazon Web Service RDS in MySQL Workbench?

I installed a DB instance on AWS and looked around all the tutorials, I should now be able to run MySQL Workbench and connect successfully since I have hostname, port, user id and password.

However, when I enter all the details that I provided when instantiating the instance, I get an error:

Failed to connect to MySQL with user

then below it says the same error with (10060) in parentheses. I looked at this error but couldn't find a suitable solution.

+3


source to share


2 answers


Two common reasons for failing to connect to a new database instance are:

  • The DB instance was created using a security group that does not allow connections from the device or Amazon EC2 instance where the MySQL application or utility is running. If the DB instance was created in a VPC, it must have a VPC security group that allows connections. If the DB instance was created outside the VPC, it must have a DB security group that allows connections.

  • The DB instance was created using the default port 3306, and your company has firewall rules blocking connections to this port from devices on your company's network. To resolve this error, re-create the instance with a different port.

You can use SSL encryption when connecting to your Amazon RDS MySQL DB instance. For more information, see Using SSL with a MySQL DB Instance.



I recommend reading the document below, it will help fix your problem.

Connecting to a DB Instance Starting MySQL Database Engine

+7


source


Error code 10060 indicates a connection problem, have a look at these settings / configuration -



  • Check the port configured for listening - 3306 (or some other port)
  • The security group will be open to the above port for your IP (make it 0.0.0.0/0 as an acid test)
  • If the RDS is inside a VPC, you need a route table entry with an internet gateway
0


source






More articles:


All Articles