BenSlabbert

ssh -i ${key.pem} -L ${port.on.my.machine}:${rds.instance}:3306  ec2-user@${ec2.ip.address}

BenSlabbert

ssh -i ${instance.key} ec2-user@${ec2.ip}

BenSlabbert

chromium-browser --disable-web-security --user-data-dir

BenSlabbert

Flush Hosts on RDS instances when you cannot directly connect.


Reset the master password on the instance
SSH into an EC2 instance which can connect to the instance
install the mysql client (Amazon AMIs) sudo yum install mysql

connect to the db as roort:
mysql -h <<RDS HOST>> -u root -p

BenSlabbert

git tag -a v${version} -m "${message}"
git push origin --tags

BenSlabbert

db.vehicles.update({}, {$set: {dateCreated: Date.now()}}, {multi:true})

BenSlabbert

https://findusages.com/

https://www.programcreek.com/simple-java/

https://www.programcreek.com/java-api-examples/index.php?action=search

BenSlabbert

Dumping from RDS:

Below the command to get the dump from the RDS instance to EC2

mysqldump -C -K -h {{rds instance}} -P {{rds port}} -u {{user}} -p {{schema}} | zip > dump.zip

SFTP this zip archive to my local machine (I used FileZilla)

Then push this dump to local:

BenSlabbert

mysqldump -C -K -h {{rds_url}} -P {{rds_port}} -u {{user_name}} -p {{schema}} --ignore-table={{schema.table_name}} | zip > dump.zip

BenSlabbert

openssl req -x509 -newkey rsa:2048 -keyout private.pem -out cert.pem -days 365 -nodes
openssl rsa -in private.pem -out public.pem -outform PEM -pubout