This is a peculiar error with Mariadb on RDS, this problem does not happen if you select the MySQL or Aurora Engine. If you try to run a GRANT ALL ON query you get an error like
Category Archives: AWS
LetsEncrypt SSL Certificate with AWS Route53 DNS using certbot-dns-route53
There are situation when its not possible to setup LetsEncrypt SSL certificates using certbot’s apache or nginx plugin. If your DNS is hosted on AWS Route53, Cloudflare, Google DNS, DigitalOcean we can take advantage of DNS-challenge authorization method to get the SSL certificates from LetsEncrypt.org. Lets see how we can do this if the DNS […]
Media conversion pipeline with AWS Transcoder, Lambda and S3
In a media streaming service, it is not recommended to stream one large media file, this slows down the user experience, also not all media formats are ideal for streaming. In this tutorial we will see the procedure to convert media to a format which is fit for streaming.
AWS RDS You do not have the SUPER Privilege and Binary Logging is Enabled
When importing a mysql database dump to RDS you receive this error “You do not have the SUPER Privilege and Binary Logging is Enabled”. This usually happens when your database has views or triggers defined. Although MySQL/Mariadb/Aurora RDS supports them but they are disabled by default. Lets see how we can enable them.