samedi 26 avril 2014

les services web Amazon - impossible de se connecter au serveur mysql sur AWS RDS - Stack Overflow


I am new to AWS RDS. I have created RDS instance.But i dont know, how can i connect this DB. I tried like this


mysql -h awsinstanamehere.rds.amazonaws.com -P 3306 -u username -p

After i entered password and i am getting some error like this



ERROR 2003 (HY000): Can't connect to MySQL server on 'awsinstanamehere.rds.amazonaws.com' (110)



Need to set any security setting in AWS console?


Note: I want to import tables for that DB


Thanks




RDS has a security group - in the AWS console, RDS, there's an entry for security groups.


If you didn't explicitly create a security group, you are probably using "default". You should probably have one group per RDS instance.


You will need to make sure that port 3306 is open to your local network, as well as whatever application you will be using to connect to it. You can allow access by IP or by security group.



I am new to AWS RDS. I have created RDS instance.But i dont know, how can i connect this DB. I tried like this


mysql -h awsinstanamehere.rds.amazonaws.com -P 3306 -u username -p

After i entered password and i am getting some error like this



ERROR 2003 (HY000): Can't connect to MySQL server on 'awsinstanamehere.rds.amazonaws.com' (110)



Need to set any security setting in AWS console?


Note: I want to import tables for that DB


Thanks



RDS has a security group - in the AWS console, RDS, there's an entry for security groups.


If you didn't explicitly create a security group, you are probably using "default". You should probably have one group per RDS instance.


You will need to make sure that port 3306 is open to your local network, as well as whatever application you will be using to connect to it. You can allow access by IP or by security group.


0 commentaires:

Enregistrer un commentaire