更改参数"lower_case_table_names"无效 [英] Changing parameter 'lower_case_table_names' has no effect

问题描述

你好，

我刚刚设置了一个运行良好的MySQL服务器.但是，我想将"lower_case_table_names"参数的值从1(默认)更改为2.

I just set up a MySQL server, which is running fine. However, I would like to change the value of the 'lower_case_table_names' parameter from 1 (default) to 2.

我在门户网站中这样做并保存了.但是，当与MySQL Workbench连接并检查设置时，它仍显示1作为值.通常，更改该参数后需要重新启动，但是门户网站中没有其他选择.

I did so in the Portal and saved. However, when connecting with MySQL Workbench and checking the settings, it's still showing 1 as value. Usually, a restart would be needed after changing that parameter, but there is no option to do so in the Portal.

我还尝试将值重置为默认值，然后重试，这没有帮助.另外，我尝试使用CLI设置值.每次，它在Portal和CLI中都显示为值2，但是仍然可以通过MySQL Workbench从服务器获取它. 显示旧值.

I also tried resetting the value to default and trying again, which didn't help. Also, I tried setting the value using CLI. Every time, it's displayed with the value 2 in the Portal and CLI, but fetching it from the server through MySQL Workbench is still showing the old value.

有什么方法可以重新启动服务器?或者，如果不需要，为什么此设置更改无效?

Is there any way to restart the server? Or, if not required, why is this setting change not working?

谢谢！

推荐答案

大卫，

我正在跟进，将就此与您联系.

I'm following up and will get back to you on this. 

谢谢

林安德(Andrea Lam)

Andrea Lam

程序管理器

Azure数据组

这篇关于更改参数"lower_case_table_names"无效的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！