How to set Amazon RDS SQL_MODE with multiple values

mysql amazon-web-services rds sql-mode
jago picture jago · Jun 25, 2015 · Viewed 14.6k times · Source

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.

Answer

Ross Scrivener picture Ross Scrivener · Oct 18, 2016

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

Related questions

AWS RDS Writer Endpoint vs Reader Endpoint

I created an Amazon Aurora instance in my VPC. When the instance was created, it came with 2 endpoints, a writer and a reader endpoint. The instance is using a security policy with an ingress rule (Type: All Traffic, Protocol: All, …

Read More
AWS Aurora: What is 'delayed send/commit ok done' process state

I am using AWS aurora instance and in process list I saw many processes with state 'delayed send ok done' and 'delayed commit ok done' and these are in sleep mode. These are not MySQL state so looks like these …

Read More
Access denied; you need (at least one of) the SUPER privilege(s) for this operation

So I try to import sql file into rds (1G MEM, 1 CPU). The sql file is like 1.4G mysql -h xxxx.rds.amazonaws.com -u user -ppass --max-allowed-packet=33554432 db < db.sql It got stuck at: ERROR 1227 (42000) at line 374: Access …

Read More