开发者

Setting MySQL "lower_case_table_name" server variable

开发者 https://www.devze.com 2023-02-04 10:31 出处:网络
Running MYSQL 5.1 on windows 7. . . how do I change the server variable for \'lower_case_table_names\'.Need to set it to 0.I\'ve tried to set it from the command prompt using mysqld.exe, and I\'ve tri

Running MYSQL 5.1 on windows 7. . . how do I change the server variable for 'lower_case_table_names'. Need to set it to 0. I've tried to set it from the command prompt using mysqld.exe, and I've tried manually changing the my.ini file. . . no luck.

Does anyone have some sure-fire/straight-forward do-this, and then this instru开发者_如何学运维ctions ?


Figured it out. . . couldn't change the variable w/ mysql workbench running. Closed it out, restarted the service and the changes took effect. Weird.


As far as I know this will only affect new tables, existing tables will not be affected by this property.

0

精彩评论

暂无评论...
验证码 换一张
取 消