在Windows 10上运行的MySQL 8.0.12中,似乎不可能将lower_case_table_names设置为2,以便在Workbench中实现混合大小写DB和表名的外观.我意识到在引擎盖下这些物体可能保持小写,这很好.但我希望它在Workbench中看起来正确,我总是可以在以前版本的MysqL中实现这一点.当我尝试这样做并重新启动服务以使其生效时,服务崩溃并停止.在MysqL日志中我看到了这个：
Different lower_case_table_names settings for server (‘2’) and data
dictionary (‘1’).Data Dictionary initialization Failed.
对于很多人来说,这似乎是一个普遍的问题.
So
lower_case_table_namesneeds to be set together with
–initialize.
It is now prohibited to start the server with a lower_case_table_names setting that is different from the setting used when the server was initialized. The restriction is necessary because collations used by data dictionary table fields are based on the setting defined when the server is initialized,and restarting the server with a different setting would introduce inconsistencies with respect to how identifiers are ordered and compared. (Bug #27309094,Bug #89035)
另见：https://bugs.mysql.com/bug.php?id=89035
通过–initialized,它指的是8.0的初始安装.怎么做的？