RDS MYSQL 8.0 parameter group value is not updating

Question

I have recently launched a RDS instance MYSQL 8.0 and When I modify the parameter explicit_defaults_for_timestamp = 0, In AWS console values shows updated. But in MYSQL console values are still not getting updated, Have tried rebooting, start/stop of the instance but still facing this issue.

When I try the same with MySQL 5.7 able to update the same parameter, Lookslike issues with AWS RDS. Need help on this.

When I try the same with MySQL 5.7 able to update the same parameter, Lookslike issues with AWS RDS.  Need help on this.

Answer

Probably it is because "explicit_defaults_for_timestamp" is deprecated in MYSQL 8.0 here is the reference from MYSQL website.
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp

RDS MYSQL 8.0 parameter group value is not updating

관련 콘텐츠