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

时间 2019-12-14 标签 mysql linux 找不到表名处理忽略大小写

[b]Linux找到my.cnf文件[/b]

# find / -name my.cnf

[b]修改解决大小写问题[/b]

在文件中补充：[color=red]lower_case_table_names=1[/color]


[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

[b]重启Mysql生效[/b]

#service mysqld start  #service mysqld stop