I am trying to enable BINARY LOGs on a MySQL RDS instance.
CALL mysql.rds_set_configuration('binlog retention hours', 24) without encountering an error.
CALL mysql.rds_show_configuration says "binlog retention hours" value is 24
SHOW BINARY LOGS says "#1381 - You are not using binary logging"
Am I missing something ?
Additional information :
SHOW GRANTSresults in
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP...
- I tried rebooting the instance. It didn't work.
- automatic backups are enabled with a 1 day retention