Convert .pem to .ppk using PuTTY to connect to Amazon EC2 instance from Windows. Amazon provides a .pem private key which cannot be directly used in PuTTY.
Here’s how you can connect to MySQL on Amazon EC2 from Windows without opening any port.
Here’s how you can connect to Amazon EC2 Linux instance from Windows laptop using PuTTy
Usually remote access to MySQL database is disabled for security reasons. However, if you need to provide remote access to MySQL, just follow these steps.