安装MySQL57数据库后,更改my.ini文件使数据库表实现区分大小写。在修改my.ini后导致MySQL57服务无法启动,服务没有报告任何错误 最后各种尝试发现是配置参数错误导致MySQL57服务无法启动。
查看了官方文档:
Use lower_case_table_names=1 on all systems. The main disadvantage with this is that when you use SHOW TABLES or SHOW DATABASES, you do not see the names in their original lettercase.
Use lower_case_table_names=0 on Unix and lower_case_table_names=2 on Windows. This preserves the lettercase of database and table names. The disadvantage of this is that you must ensure that your statements always refer to your database and table names with the correct lettercase on Windows. If you transfer your statements to Unix, where lettercase is significant, they do not work if the lettercase is incorrect.
在Windows下配置 lower_case_table_names=2。