"possum cam testing" (CC BY-NC-SA 2.0) by leogaggl

One common task for my Raspberry Pi Zero with (infrared) Camera is to do still image capture in regular intervals and upload the images for storage and post-processing. A simple way to achieve this with standard software tools available in the Raspberry Pi OS repositories is to use the S3 CLI tools and a simple bash script run by a scheduled cron job.

Every once in a while it is handy to be able to access an Amazon RDS Database Instance remotely from a desktop.

ssh -i <strong>YOUR-AMAZON-PRIVATE-KEY</strong>.pem -l <strong>YOUR-AMAZON-RDS-USERNAME</strong> -L 33060:<strong>YOUR-AMAZON-RDS-PRIVATE-IPADDRESS</strong>:3306 -N ec2-usr@<strong>YOUR-AMAZON-EC2-INSTANCE-PUBLIC-ADDRESS</strong>

Note: YOURAMAZONRDSPRIVATEIPADDRESS needs to be the AWS internal RDS IP Address – not the external hostname

You can then connect to RDS using mysql commands or any GUI tool such as MySQL Workbench via localhost:33060

Thanks to: Dirk Taggesell via AWS Forums