Connect MySQL Workbench to RDS via SSH Tunnel
How to Connect MySQL Workbench to Amazon RDS Using an SSH Tunnel?
What is an SSH tunnel?
SSH tunnel is utilized mainly for securely accessing a private database like MySQL RDS DB without exposing it to the public internet directly.
What should I check for before setting up the connection?
You need the following before establishing a connection:
- The SSH hostname (public IP or DNS of your bastion EC2 instance).
- The SSH username and the corresponding private key file (.pem or .ppk).
- The MySQL RDS endpoint URL and port number (default is 3060 or 3306).
- The MySQL database username and password.
- Standard TCP/IP over SSH connection method
Also, before creating the connectivity, verify that the following are properly configured to permit communication between your EC2 instance and the RDS DB instance.
- The security group inbound rules
- Network access control lists (network ACLs)
- Route tables
How to connect MySQL Workbench to RDS?
Additionally, confirm that your EC2 instance is accessible from your local computer via the internet using its public IP address.
Now,
- Open MySQL Workbench
- Choose MySQL New Connection
- Enter a name for the connection
- Select the connection method as Standard TCP/IP over SSH.
- To enter the SSH hostname, use your EC2 instance’s public IP address
- Next, we must use the default SSH username for the EC2 instance.
- Select the .pem file from your file system and also the SSH Key File to connect.
- For MySQL Hostname, we have to enter the database endpoint name.
- In the MySQL Server Port field, type the port number used to connect to the DB.
- In the Username field, enter the username the database was connected to.
- Then input the MySQL user password in the password field.
- Choose the dropdown menu→Test connection.
- Check whether the connection is successful.
- If successful, click OK to save the connection.
After configuring the connection, we can use SSH tunnel to connect MySQL Workbench to an MySQL RDS DB in AWS.
At Velan Remote IT Support, our server support team helps you establish the connection between MySQL Workbench and a MySQL RDS DB instance. As an experienced managed service provider with ISO 9001 and ISO 27001 certifications, we place a high priority on security and process quality in all of our remote IT support solutions.
Contact us at [email protected]
Need help with MySQL Workbench and MySQL RDS support?
Our server support specialists configure secure tunnelling, troubleshoot connectivity issues, and optimize your MySQL RDS environment for reliable database access.
Commonly Asked Questions on MySQL Workbench to an MySQL RDS DB Connection Using SSH Tunneling
Velan Remote IT Support offers expert AWS support solutions for global businesses. Our offerings cover support for Amazon RDS for MySQL, PostgreSQL, Oracle, MariaDB, and Amazon Aurora. Our team helps businesses deploy and manage databases based on their requirements.
We identify and resolve issues related to
SSH authentication
database credentials
security groups
network ACLs
route tables
firewall settings
database endpoints.
Our server experts diagnose the issue by checking connection configuration and authentication settings to restore connectivity quickly.
We check
SSH keys
EC2 instance accessibility
MySQL configuration
RDS endpoints
Network rules
Categories
- Applications 09
