linux mysql 大小写问题

1.sudo vim /etc/mysql/my.cnf

在[mysqld]下添加
lower_case_table_names=1
[mysqld]
#
# * Basic Settings
#
user            = mysql
#ower_case_table_names = 1
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
lower_case_table_names=1

2.重启mysql 

sudo /etc/init.d/mysql restart