3 個答案
- 最新
- 最多得票
- 最多評論
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
已回答 6 年前
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
已回答 5 年前
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
已回答 5 年前
相關內容
- AWS 官方已更新 1 年前
- AWS 官方已更新 2 年前