MySQL在Linux找不到表名-处理忽略大小写

Linux找到my.cnf文件

# find / -name my.cnf

修改解决大小写问题

在文件中补充：lower_case_table_names=1

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
lower_case_table_names=1

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

重启Mysql生效

#service mysqld start  
#service mysqld stop