RDS MYSQL 8.0 parameter group value is not updating
0
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.
asked 5 months ago15 views
1 Answers
2
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
answered 5 months ago
Relevant questions
Why does default max_connections differ in the default parameter groups for RDS MySQL and RDS MariaDB?
asked 5 months agoRDS Mysql console stats do not match monitoring stats reported on overview
asked 3 months agoHow to change parameter partial_revokes
Accepted Answerasked 6 months agoAWS RDS Aurora MySql Serverless: ft_min_word_len is not being recognized
asked 2 months agoPerformance Insights and MySQL 5.7.22
Accepted Answerasked 3 years agoRDS MYSQL 8.0 parameter group value is not updating
asked 5 months agoCannot enable gtid_mode in parameter group
Accepted Answerasked 6 months agoChanging pg_trgm.similarity_threshold in RDS
asked 2 months agoProblem with deadlock on AWS RDS MySQL
asked 4 years agoWhy the LoginFailures metric showing no data for RDS MySQL instance?
asked 3 years ago