3 Respuestas
- Más nuevo
- Más votos
- Más comentarios
0
Now I can connect to MySql which is running on EC2 instance.
What we did:
- replaced NAT instance with NAT gateway
- Set security group to EC2 instance
respondido hace 6 años
0
Hello Masahiko,
Can you please help me how you were able to connect to MySQL running on EC2. I am having difficulty for the same.
here is what I have done so far -
- Launched Linux Public EC2.
- Launched Linux Private EC2. Created NAT Gateway.
- Connected private EC2 through Public EC2 and Installed MySQL Server on private EC2.
- Created Database Employee on MySQL Server.
- GRANT ALL PRIVILEGES ON Employee.* TO 'root'@'<Private EC2 IP>' IDENTIFIED BY '<password>';
- Inbound Security group attached to Private EC2 instance -
All TCP TCP 0 - 65535 sg-<SG ID>
MYSQL/Aurora TCP 3306 0.0.0.0/0 - JDBC URL while setting up connection from Glue to MySQL DB
jdbc:mysql://ip-<ip address>.ec2.internal:3306/Employee
Error I am getting is - "Host 'ip-<ip address>.ec2.internal' is not allowed to connect to this MySQL server"
Can you please help?
Please let me know if I need to provide any more details about it.
Thanks,
Dhiraj
respondido hace 5 años
0
I am able to connect to MySQL DB installed on Private EC2 instance now. Performed everything from scratch right from dropping and recreating VPC and all steps I mentioned in earlier post. Able to crawl MySQL Tables into Glue Catalog DB now.
Thanks,
Dhiraj
respondido hace 5 años
Contenido relevante
- OFICIAL DE AWSActualizada hace 8 meses
- OFICIAL DE AWSActualizada hace 3 años