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

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.