mysq5.7

[mysqld]
#不区分大小写
lower_case_table_names = 1
#不开启sql严格模式
sql_mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"

mysq8

[mysqld]
#不区分大小写
lower_case_table_names = 1
#不开启sql严格模式
sql_mode = STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION