Can't connect to AWS RDS MySQL using mysql CLI

Question

I'm trying to access my new MySQL database using my Linux ubuntu command line prompt and can't guess why i get an error message:
-Command lines: mysql -h cryptoboss.ciugn9m0bdta.eu-west-1.rds.amazonaws.com -P 3306 -u cryptoboss -p
-error message: ERROR 2003 (HY000): Can't connect to MySQL server on 'cryptoboss.ciugn9m0bdta.eu-west-1.rds.amazonaws.com:3306' (110)
-Investigated: I've been investigating firewall,  adding new group security rules on my IP address, etc but nothing works properly

Accepted Answer

Is this Rds public facing? If so is it in a public subnet with a route to an IGW?

If it’s public facing you would have to add your public ip to the security group rules on the Rds instance. Your private IP would not work.

Answer

Hello,

I've been adding my public address to my security group (following your recommendations).

Unfortunately i still get this answer after i typed this command line: mysql -h cryptoboss.ciugn9m0bdta.eu-west-1.rds.amazonaws.com -P 3306 -u cryptoboss -p
Enter password:
 
ERROR 2003 (HY000): Can't connect to MySQL server on 'cryptoboss.ciugn9m0bdta.eu-west-1.rds.amazonaws.com:3306' (110)

Thank you!

Can't connect to AWS RDS MySQL using mysql CLI

相關內容