Why the mysql 5.7-8.0 upgrade failed?

Question

I wanted to upgrade the mysql engine from 5.7 to 8.0, but I got the error 'The parameter value for lower_case_table_names can't be changed for MySQL 8.0 DB instances.' I've very carefully checked that there's no upper case charactors in any tablenames or schemas in my db instanse. So why I got this error, and how to solve it?

Didier_Durand · Accepted Answer

Hi,

you should read https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html

It will explain you the param `lower_case_table_names`.

Then, you should see which values it has in your config before the upgrade and check if you specified it explicitly or not. You probably have the default value. Then, you should enforce this value as explicit before the upgrade and rerun the upgrade.

Maybe 5.7 and 5.8 have a different default value for this parameter creating your problem.

Best,

Didier

Antonio_Lagrotteria · Answer

I d look into this: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.KnownIssuesAndLimitations.html#MySQL.Concepts.ParameterNotes

Why the mysql 5.7-8.0 upgrade failed?

Relevant content