MySQL Database Settings table name is case sensitive

Friends who use MySQL sometimes encounter case-insensitive table names, which can be cumbersome to import data or back up a database.

How to set the MySQL database table name is case-sensitive, configured as follows:

1. Modify the MySQL configuration file My.ini

My.ini file included in

Character_set_server=utf8
lower_case_table_names=2

2. Uninstalling the MySQL service

3. Installing the MySQL Service

Switch to the MySQL command line and execute the install command

Mysqld--install MySQL--defaults-file= "D:\Program Files (x86) \mysql\my.ini"

Accomplishment reference までに, よろしくお willing いします.

MySQL Database Settings table name is case sensitive