I am trying to import my .sql dump from a local machine to an AWS RDS db instance using the command:
C:\Program Files\MySQL\MySQL Server 5.5\bin>mysqldump --host=localhost --user=root --password=admin e_learning_system | mysql --host=mydbinstance.cyz1k1vacvdd.us-east-1.rds.amazonaws.com --user=root --password=adminadmin e_learning_system
but this causes this error:
ERROR 2003 (HY000): unable to connect to MySQL server on 'mydbinstance.cyz1k1vacvdd.us-east-1.rds.amazonaws.com' (10060) mysqldump: Got errno 22 when writing
How to fix it?
Yes, the Amazon Beanstalk application and the RDS security groups must be the same to connect the application to the database instance.
Right-click on the database instance and add a new security group using the beanstalk application.
- , , , RDS. , " ". , , , 0.0.0.0/0 ( accept from all), db. . , .
0.0.0.0/0
workbench MySQL. , .
.
MySQL workbench SQL Yog.
, .
1) MySQL Workbench.
2) AWS RDS. . . IP-.
3) Workbench MySQL, .
4) , .
5) - TCP/IP
6) RDS Hostname (mydbinstance.cyz1k1vacvdd.us-east-1.rds.amazonaws.com).
7) : 3306
8) : master username (, RDS) (root)
9) : (admin admin)
10) " ", .
11) , "".
12) .
13) "e_learning_system".
14) mysqldump . "". " ".
15) , , SQL SQL, , * ;
2003 mysql. , , RDS RDS.
, , mysql.exe... , .