mysql如何设置不区分大小写

数据运维 2023-04-30 Escape 手机阅读

mysql设置不区分大小写 windows下到安装mysql的目录，修改my.ini文件在文件最后一行加上下面一句话 lower_case_table_names=1 说明 0：区分大小写，1：不区分大小写效果如下 [mysqld] port = 3306

                        <p>mysql设置不区分大小写</p>

windows下

到安装mysql的目录，修改my.ini文件

在文件最后一行加上下面一句话

lower_case_table_names=1

说明 0：区分大小写，1：不区分大小写

效果如下

[mysqld] port = 3306 basedir=F:/mysql-5.7.21-winx64 datadir=F:/mysql-5.7.21-winx64/data max_connections=200 character-set-server=utf8 default-storage-engine=INNODB sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES [mysql] default-character-set=utf8 lower_case_table_names=1

内容扩展：

linux下

进入etc下面

cd /etc/

编辑my.cnf文件

vi my.cnf

最后一行加上下面一句

lower_case_table_names=1

效果如下

# For advice on how to change settings please see 1. http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

[mysqld] 1. 1. Remove leading # and set to the amount of RAM for the most important data 1. cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. 1. innodb_buffer_pool_size = 128M 1. 1. Remove leading # to turn on a very important data integrity option: logging 1. changes to the binary log between backups. 1. log_bin 1. 1. Remove leading # to set options mainly useful for reporting servers. 1. The server defaults are faster for transactions and fast SELECTs. 1. Adjust sizes as needed, experiment to find the optimal values. 1. join_buffer_size = 128M 1. sort_buffer_size = 2M 1. read_rnd_buffer_size = 2M datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0

log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid lower_case_table_names=1

重启mysql：