mysqlamazon-web-servicesrdssql-mode

How to set Amazon RDS SQL_MODE with multiple values

MySQL allows parameter SQL_MODE to be set to multiple values in the my.cnf file. How can I do the same on Amazon RDS?

UPDATE: This problem has been fixed...see below.

Solution

  • Helpfully it looks like Amazon have fixed this as of May 24th 2016

    The sql_mode parameter can now be set to a list of values for all MySQL and MariaDB versions. The list of values should be correct in all regions as well.

    https://forums.aws.amazon.com/thread.jspa?threadID=232266