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.
精彩评论