How to Clear the Slow Query Log on AWS RDS MySQL/ MariaDB
Category : How-to
Here is a super simple little tip for clearing the mysql.slow_log in MySQL or MariaDB when running an RDS on Amazon AWS.
For more information on AWS RDS, please see: https://aws.amazon.com/codedeploy/
Unfortunately the usual approach of simply DELETing or TRUNCATING data from the table doesn’t work due to a permission error. This is true, even for the AWS created master database user.
Error Code: 1044. Access denied for user 'masteruser'@'%' to database 'mysql'
Luckily, the Amazon AWS team have put together a package that clears out the table for us.