Connect MySQL Workbench to EC2 Instance
In addition, we need to confirm that the instance can connect to the internet using its public IP address from the local machine.
Moving ahead:
1. Initially, we open the MySQL Workbench.
2. Then we select MySQL New Connection and enter a connection name.
3. Here we can select the Connection Method and Standard TCP/IP over SSH.
4. After that, for SSH Hostname, we enter the public IP address of the instance.
5. And for SSH Username, we enter the default SSH user name to connect to the instance.
6. Then, we select SSH Key File and the .pem file used to connect from the file system.
7. For MySQL Hostname, we enter the database endpoint name.
8. Similarly, for the MySQL Server Port, we enter the port number that we use to connect to the database.
9. Then, for Username, we enter the user name that we use to connect to the database.
10. For Password, we enter the MySQL user password.
11. Finally, we select Test Connection. After the test is successful, we select OK to save the connection.
Once we configure the connection, we can connect to the private RDS DB instance using an SSH tunnel.
