Percona MySQL 8.0.25-15 | [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('1') and data dictionary ('0') & [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. | lower-case-table-names = 1

Hi there,
When starting MySQL8.0.25-15 with the parameter lower-case-table-names = 1 in the config file,Below is the error faced.
How to start MySQL …?

2021-09-06T18:43:13.945448+05:30 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-15) starting as process 22086
2021-09-06T18:43:13.953842+05:30 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-09-06T18:43:22.218936+05:30 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-09-06T18:43:22.230577+05:30 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('1') and data dictionary ('0')                                     .
2021-09-06T18:43:22.231016+05:30 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-09-06T18:43:22.231515+05:30 0 [ERROR] [MY-010119] [Server] Aborting
2021-09-06T18:43:23.483201+05:30 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.25-15)  Percona Server (GPL), Relea                                     se 15, Revision a558ec2.

Based on documentation it is prohibited to start the server with lower_case_table_names different from the value when the data directory was initialized. If you need to change lower_case_table_names to 1 from 0 you’ll need to reinitialize the data directory but prior to that you will want to backup the data prior to re-initializing the data directory.
Reference: MySQL :: MySQL 8.0 Reference Manual :: 5.1.8 Server System Variables

1 Like