In the UbuntuLinux system, MySQL table names are case-sensitive by default, while in Windows, MySQL tables are case-insensitive by default. The specific method for modifying MySQL is as follows: Java code sudovi/etc/mysql/my. cnf means to first find your MySQL my. the cnf configuration file is modified. Of course, if your path is not necessarily the same as mine, note that in Ubuntu Linux, the MySQL table name is case sensitive by default, in Windows, MySQL is case-insensitive by default.
The specific method for modifying MySQL is as follows:
Java code
- Sudo vi/etc/mysql/my. cnf
It means to first find and modify the my. cnf configuration file of your MySQL instance. Of course, if your path is not necessarily the same as mine, pay attention to this.
Add in [mysqld]
Java code
- Lower_case_table_names =1
After the configuration is complete, restart MySQL.
Java code
- Sudo/etc/init. d/mysql restart
The ignore size setting is complete in Linux.