1、vi /etc/my.cnf
2、在 [mysqld] 下面添加 :
sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
lower-case-table-names = 1
(mysql表名大小写不敏感)
3、修改之后重启mysql
附注:sql_mode详解见https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html