Aurora serverless not connecting from CLI and mysql workbrench

Question

I make a Aurora serverless cluster and trying to connect it from command line using command

mysql --user=mightycpa --password -h serverless.cluster-xxxxxx

but it can't connect and gives an error

ERROR 2003 (HY000): Can't connect to MySQL server 

I tried with mysql workbench also but not works. I checked VPC group and security groups and give it accessible form anywhere.

For testing I create Aurora Rds with serverless with same VPC and security groups and it connects fine.

Can we connect severless from local CLI or not? if yes then any change needed?

Answer 1

We can't connect it from ssh or using local machine etc. For it we need to use Cloud9 and list all databases there