james1
April 3, 2024, 10:03am
1
I have a same issue with this.
How can I connect to a MySQL service on one of my EC2 instances via SSH tunnel or a private IP?
This EC2 instance is on a public VPC with a public IP (Elastic IP) and I would like give QuickSight access to its MySQL service via a private IP of that EC2 instance, or connect to the MySQL service via SSH, as a localhost connection. and not open port 3306 publicly to the internet.
I have a EC2 server with Mysql8.0.
QS with VPC connection on same VPC network of EC2
I want to make Mysql dataset using EC2 server(mysql).
I open the security group, but it has same issue.
duncan
April 4, 2024, 3:26pm
2
Hello @james1 !
Did the marked solution in that post not work for you?
I created a connection to my private VPC
I added the relevant security groups to my EC2 (enabling access only from the QS subnet IPs)
I added a special SQ user with relevant permissions to the MySQL schema
I had to update my.cnf and disable bind-address, to allow connections from QS
I did not use SSL for the connection between QS and my EC2 MySQL
duncan
April 8, 2024, 6:50pm
3
Hello @james1 !
Are you still working on this issue or were you able to find a solution?
james1
April 9, 2024, 1:31am
4
Hello @duncan
I solved this issue, using disable SSL connection.
@james1 - Good to hear that you are no longer having the problem. Can you please mark the relevant post as Solution and close the thread. This will help the community to find guidance and answers to similar question. Thank you!
