How the SQL file table name exported to MySQL under Windows is case-sensitive

Solutions under Windows:

My.ini inside the mysqld part
Join lower_case_table_names=2

[Mysqld]
lower_case_table_names=2
Set-variable=lower_case_table_names=0
Port= 3306

Note: 1 indicates that case-insensitive 2 indicates case sensitivity

Then reboot the MYSQLD server and reboot the MYSQLD service in XAMPP to the XAMPP directory Mysql_start.bat
After restarting the MYSQLD service, the command line enters MySQL, confirming that the Lower_case_table_names value has been changed to 2.


Mysql> Show variables like '%low% ';
+------------------------+---------+
| variable_name | Value |
+------------------------+---------+
| log_slow_queries | Off |
| Low_priority_updates | Off |
| Lower_case_file_system | On |
| Lower_case_table_names | 2 |
| Max_allowed_packet | 1047552 |
| Slow_launch_time | 2 |
+------------------------+---------+
6 rows in Set (0.06 sec)

Import again Product.sql discovery has been able to be case-sensitive.