Unable to connect to localhost

Question

How do I connect to localhost from MySQL Workbench?
Cluster parameters: 
1. Engine: Aurora (MySQL 5.7) 2.10.3
2. VPC security group: default and allow-prod-corp-port-81928200
3. Database authentication: password authentication
MySQL Workbench parameters:
1. Connection method: Standard (TCP/IP)
2. Hostname: using correct host address
3. Port: 8192
4. Username: using correct master user name
5. Password: using correct master password 
Results:
1. From test connection: Failed to connect to MySQL at :8192 with user  . Unable to connect to localhost.
2. From open connection: Cannot connect to database server. Your connection attempt failed for  at :8192. Unable to connect to localhost.

Answer

I have seen this error: 'Unable to connect to localhost' in MySQL workbench, when trying to connect to an RDS Proxy.

In my case my VPC Endpoints associated with the RDS Proxy Endpoints had the wrong security group. You can find the vpc endpoint easily by doing an nslookup to the RDS Proxy Endpoint, and then search for it in VPC Web Console.

Answer

Hi,

If you want to connect to a private Amazon RDS DB instance from a local machine, see this article: https://repost.aws/knowledge-center/rds-connect-ec2-bastion-host.

Otherwise, you need to use the Aurora MySQL Endpoint. Here is a step by step workshop that shows how to connect to Aurora MySQL with MySQL Workbench : https://catalog.us-east-1.prod.workshops.aws/workshops/f4734fd8-d4ca-4926-a211-ac57679acfb4/en-US/04-sql-to-aurora-mysql/04-convalidate/04-auroraconnect.

The documentation should help as well: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Connecting.html

Regards,

Jon

Unable to connect to localhost

相關內容