Case sensitivity of mysql sub-table names in linux

I used windows for development, so I didn't feel a problem when I deployed my yii project to linux today, if the rbac table of yii cannot be found, the following error occurs: www.2cto.com CDbCommand cannot run the SQL statement: SQLSTATE [42S02]: Base Table or view not found: 1146 table 'si _ manager. authAssignment 'doesn' t exist. the SQL statement executed was: SELECT * FROM 'authassignment 'WHERE userid =: userid, but I went to see that my linux machine has this data table.
Www.2cto.com: The case is slightly different, and then the statements with errors are executed manually, therefore, it was determined that the case was the case sensitivity issue. Therefore, google learned that the names of mysql tables in linux are case-insensitive. However, it is very simple to change the configuration to not distinguish between/etc/my. add lower_case_table_names = 1 under [mysqld] In cnf.