mysql如何设置不区分⼤⼩写
mysql设置不区分⼤⼩写windows下
到安装mysql的⽬录，修改my.ini⽂件在⽂件最后⼀⾏加上下⾯⼀句话
lower_case_table_names=1说明 0：区分⼤⼩写，1：不区分⼤⼩写效果如下
[mysqld] port = 3306
basedir=F:/mysql-5.7.21-winxdatadir=F:/mysql-5.7.21-winx/datamax_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效果如下
[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 = 2Mdatadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pidlower_case_table_names=1重启mysql：
systemctl restart mysqld
到此这篇关于mysql如何设置不区分⼤⼩写的⽂章就介绍到这了,更多相关mysql设置不区分⼤⼩写内容请搜索以前的⽂章或继续浏览下⾯的相关⽂章希望⼤家以后多多⽀持！
