MySQL的lower_case_table_names不会改变 [英] MySQL's lower_case_table_names won't change

问题描述

我在MySQL 5.6中更改lower_case_table_names变量值时遇到问题... 我做了

I have a problem with changing lower_case_table_names variable value in MySQL 5.6 ... I did all that says in Where to change the value of lower_case_table_names=2 on windows xampp.

我的Windows 7的默认值为"1".我想将其切换为"2".

The default value on my Windows 7 is '1'. I want to switch it to '2'.

尝试了几种方法，我所做的是:

Tried several ways, what I did is:

1. 通过将 lower_case_table_names = 2 添加到我可能的地方(没有#符号ofc)来编辑C:\ Program Files \ MySQL \ MySQL Server 5.6 \ my-default.ini
2. 复制my-default.ini并粘贴到同一目录，但重命名为my.ini
3. 将my.ini复制到\ bin文件夹
4. 几次重新启动MySQL56服务

1. Edited C:\Program Files\MySQL\MySQL Server 5.6\my-default.ini by adding lower_case_table_names = 2 to wherever I could (without # symbol ofc)
2. Copied my-default.ini and pasted to the same directory, but renamed to my.ini
3. Copied my.ini to \bin folder
4. Restarted MySQL56 service couple times

现在，当我读到"SELECT @@ lower_case_table_names"时，它仍然显示1，而我的数据库的行为就像是1 ...

Now, when I read "SELECT @@lower_case_table_names" it still says 1, and my db behaves like it is 1...

有什么想法吗?

推荐答案

我用在下面找到的文件解决了此问题

I solved this with a file I found under

C:\ ProgramData \ MySQL \ MySQL Server 5.6 \ my.ini

C:\ProgramData\MySQL\MySQL Server 5.6\my.ini

因此，它是 ProgramData ，而不是Program Files.我从MySQL Workbench->管理服务器实例-> [tab]系统配置文件->配置文件中获得了此路径.猜猜这是应该在其中查找当前配置文件路径的地方.

So, it was ProgramData, not Program Files. I got this path from MySQL Workbench -> Manage Server Instances -> [tab] System Profile -> Configuration File. Guess this is the place where one should look for the current config filepath.

这篇关于MySQL的lower_case_table_names不会改变的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！