Resolves an issue where MySQL table names are automatically turned into lowercase under windows

Because the web uses MVC, the database uses MySQL. In order to facilitate development, under the Windows7 also installed a MySQL, today in the creation of the table, encountered a tricky problem. All the table names turn into lowercase, which is not what I want, and as Virgo, there is no tolerance for such things. After a toss-up, finally solved, the method is as follows.

First step: First select console in Navicat tools, then enter: Show variables like ' lower_case_table_names '; notice the semicolon

If the value of the output Lower_case_table_names is 1, it will automatically become lowercase. What we need is to change this value to 2.

The second step: Enter in the run: Services.msc Open the Service Manager, right-click on the MySQL service, select Properties, in the General tab, there is an "executable path", in which to find the My.ini directory

The third step: Open the My.ini, and then under [mysqld] Add: "lower_case_tables_names=0" So a sentence can be, then save, close.

Fourth step: Restart the MySQL service

Fifth step: Re-execute the first step to see if the value of Lower_case_table_names is 2, and if so, it's done.

Resolves an issue where MySQL table names are automatically turned into lowercase under windows