Here’s how you can connect to MySQL on Amazon EC2 from Linux / Mac without opening any port by forwarding your local port over SSH
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
Here’s how you can connect to Amazon EC2 Linux instance from your Linux/Mac laptop, using SSH.
When working with MySQL, you may need to backup and restore MySQL database regularly to recover in case of accidents. Here’s how you can do it.
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.
Sometimes you need to create a read-only MySQL user. You can follow these steps and use these ready made commands to create a read-only MySQL user.