lower_case_table_name错误 [英] lower_case_table_name Error

问题描述

我正在尝试将lower_case_table_name值设置为2，因为它是Windows服务器.但是，当我启动MySQL Workbench并连接到服务器时，出现以下错误:

I'm trying to set the lower_case_table_name value to 2, since it is a Windows server. But when I start MySQL Workbench and connect to my server I get the following error:

服务器所在的系统未正确支持所选的lower_case_table_names选项值.

Windows服务器不应该支持2的值吗?我正在Windows Server 2012上运行MySQL 5.6，并使用MySQL Workbench 6.3.

Shouldn't a Windows server support a value of 2? I'm running MySQL 5.6 on Windows Server 2012 and using MySQL Workbench 6.3.

推荐答案

您可以放心地忽略此错误.

You can safely ignore this error.

我最近在新的Windows计算机上安装了MySQL，并将lower_case_table_names设置为2后也收到了此错误.我不记得以前看过它.但是，尽管有错误，它似乎仍能正常工作.创建具有适当大小写的表，并且我可以执行不区分大小写的查找.

I recently installed MySQL on a new Windows computer and got this error as well after setting lower_case_table_names to 2. I don't remember seeing it previously. However, despite the error it seems to be working properly..tables are created with the proper case and I can do case-insensitive lookups.

这篇关于lower_case_table_name错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！