| Bug #90814 | MySQL Service not restarting after changing lower case table names. | ||
|---|---|---|---|
| Submitted: | 9 May 2018 20:53 | Modified: | 9 May 2018 20:57 |
| Reporter: | Anthony Burriss | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 8.0.11 | OS: | Windows |
| Assigned to: | CPU Architecture: | x86 | |
[9 May 2018 20:57]
MySQL Verification Team
Thank you for the bug report. See https://bugs.mysql.com/bug.php?id=90695 and below explanation of developer: [2 May 7:29] Ståle Deraas Posted by developer: After initialization, is is not allowed to change this setting. https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_tab... So "lower_case_table_names" needs to be set together with --initialize .
[4 Apr 2019 6:55]
fefegrt fdgfhdg
what the my.ini? I havent this file...
[3 Jun 2023 14:44]
Steve Nelson
The same thing is happening to me. If I set lower_case_table_names=2 or lower_case_table_names=0 the mysql service won't start. But if it is set to: lower_case_table_names=1 it runs just fine. It says: "The MySQL80 service on Local COmputer started and then stopped. Some services stop automatically if they are not in use by other services or programs."
Description: After adding lower_case_table_names=2 under [mysqld] in the my.ini file. I restart the MySQL80 service and the service does not restart. Received the following error message: 2018-05-09T20:37:24.231843Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('2') and data dictionary ('1'). 2018-05-09T20:37:24.233862Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2018-05-09T20:37:24.234810Z 0 [ERROR] [MY-010119] [Server] Aborting How to repeat: Edit my.ini file. Add lower_case_table_names=2 under [mysqld]. Save .ini file. Restart MySQL80 service.