ubuntu mysql 设置大小写不敏感

Posted on | In ,

1.进入目录径：/etc/mysql/mysql.conf.d
2.修改mysqld.cnf文件，在标签[mysqld]下添加lower_case_table_names=1 

1
2
3
4
5
6
7
8
9
10
11
[mysqld]
#skip-grant-tables
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
log-error       = /var/log/mysql/error.log
# By default we only accept connections from localhost
bind-address    = 127.0.0.1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
lower_case_table_names=1

注意： 该配置会强制将表名改为小写，如果当前存在大写的表，请将大写的表改为小写再改配置，否则原来大写的表无法删除，小写的表名也无法创建

3.重启mysql,使用命令:/etc/init.d/mysql restart

Donate comment here