What you will need is below:
- Sequal Pro Download
- install an
- Select SSH tab from Sequal Pro as above pic.
- Now you will able to view as below image
- Add your HOST, USERNAME and PASSWORD [You can select authentication key file by pressing Key Icon ] and PORT and 22 for EC2 Instances
- Do not select SSL if you only need to target SSH
- If you get error such as Permission Denied or Access restriction for your Authenticated private key file then follow below steps in your terminal or command prompt for windows
- ssh i [your private key file path] [HOST Name]
If you see above error then type below command
- chmod 400 [YOUR PRIVATE KEY FILE]
- Now try ssh i [your private key file path] [HOST Name]
- You will get succed now
Now again try to connect your sequal pro connection
Please make sure you enter password of your local host with password of your connection user name [SSH login password]

