Fixing MySQL Error Code 1419 on AWS RDS: Missing SUPER Privilege with Binary Logging Enabled If you’ve ever tried to create a stored function or trigger in MySQL on Amazon RDS and encountered the error below, you’re not alone: Error Code: 1419. You do not have the SUPER privilege and binary logging is enabled (you …

Rotating SSL/TLS Certificate Current Certificate Expiry: If application connects to an RDS DB instance using Secure Socket Layer (SSL) or Transport Layer Security (TLS), certificate must be rotated before March 5, 2020 Problem Description: As of September 19, 2019, Amazon RDS has published new Certificate Authority …

Today we will Learn "How to delete an AWS RDS Snapshot using Lambda and Cloudwatch". So that we can automate the AWS RDS Snapshot deletion process as per our requirement. Please follow the below steps to achieve this. Step 1: Create IAM policy for an IAM Role. Copy the below policy and paste it in your IAM policy. 1{ 2 …

Today I will show you, how you can start and stop your AWS RDS instance using Lambda and Cloudwatch. Step 1: Create a Policy which has RDS, start-stop permission and has Cloudwatch permission. Create new Policy and paste the below policy in it: 1{ 2 "Version": "2012-10-17", 3 "Statement": [ 4 { 5 "Effect": "Allow", 6 …