Download and install MySQL Workbench.
Open MySQL Workbench.
Select MySQL New Connection and enter a connection name.
Choose the Connection Method, and select Standard TCP/IP over SSH.
For SSH Hostname, enter the public IP address of your EC2 instance.
For SSH Username, enter the default SSH user name to connect to your EC2 instance.
Choose SSH Key File, and select the .pem file used to connect from your file system.
For MySQL Hostname, enter the database endpoint name.
To find the endpoint name:
Login in AWS console.
Click Services, and search for RDS (Managed Relational Database Service).
Click on Databases.
Click on the DB Identifier under the cluster DB Identifier you to connect to using MySql Workbench.
The endpoint for that database will be displayed under Connectivity & security.
For MySQL Server Port, enter the port number that you use to connect to your database.
This will be in the same location as the identifier.
For Username, enter the user name that you use to connect to your database.
For Password, enter the MySQL user password.
Choose Test Connection. After the test is successful, choose OK to save the connection.
No comments yet.