Shulou(Shulou.com)06/01 Report--

Mysql ignores case in linux environment

Mysql database ignores case by default in window environment, but on the contrary in linux environment, the normal use of application engineering may be affected after database migration.

Solution:

After logging in with your root account, add lower_case_table_names=1 after "mysqld] in / etc/my.cnf, and restart the MYSQL service (/ etc/init.d/mysqld restart). At this time, the setting is successful: table names are not case-sensitive.

Detailed description of lower_case_table_names parameters:

Lower_case_table_names = 0

Where 0: case sensitive, 1: case insensitive

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.