Can't connect to AWS RDS MySQL using mysql CLI

0

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

已提问 7 个月前500 查看次数
2 回答
2
已接受的回答

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.

profile picture
专家
已回答 7 个月前
profile picture
专家
已审核 9 天前
profile picture
专家
已审核 7 个月前
  • Many thanks, the Db wa not publicly accessible. The option to make it publicly accessible was a bit hidden and i've learnt some network basic procedure: database should be made public and inbound flows filtered on my public IP, not the private one because i navigate through the internet. Thank your very much

0

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!

已回答 7 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则