mysql 忽略表明字母大小写 window默认是1 忽略 Linux不忽略需要增加

2017-01-05 11:16:17来源:oschina作者:林伟琨人点击



**用root帐号登录后,在/etc/my.cnf 中的[mysqld]后添加添加lower_case_table_names=1,重启MYSQL服务( /etc/init.d/mysqld restart),这时已设置成功:不区分表名的大小写;**# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
port=3306
datadir=/home/data/mysql
server_id=1
socket=/home/data/mysql/mysql.sock
character-set-server=utf8
lower_case_table_names=1
#skip-grant-tables
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
validate-password=OFF
# Recommended in standard MySQL setup
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
#
log-bin
[client]
socket=/home/data/mysql/mysql.sock
default-character-set=utf8
[mysqld_safe]
log-error=/home/data/mysql/log/mysqld.log
pid-file=/home/data/mysql/mysqld.pid

最新文章

123

最新摄影

微信扫一扫

第七城市微信公众平台