mysql如何设置不区分大小写
mysql设置不区分大小写
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文件
vimy.cnf
最后一行加上下面一句
lower_case_table_names=1
效果如下
#Foradviceonhowtochangesettingspleasesee
#http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html[mysqld]
#
#Removeleading#andsettotheamountofRAMforthemostimportantdata
#cacheinMySQL.Startat70%oftotalRAMfordedicatedserver,else10%.
#innodb_buffer_pool_size=128M
#
#Removeleading#toturnonaveryimportantdataintegrityoption:logging
#changestothebinarylogbetweenbackups.
#log_bin
#
#Removeleading#tosetoptionsmainlyusefulforreportingservers.
#TheserverdefaultsarefasterfortransactionsandfastSELECTs.
#Adjustsizesasneeded,experimenttofindtheoptimalvalues.
#join_buffer_size=128M
#sort_buffer_size=2M
#read_rnd_buffer_size=2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock#Disablingsymbolic-linksisrecommendedtopreventassortedsecurityrisks
symbolic-links=0log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
lower_case_table_names=1
重启mysql:
systemctlrestartmysqld
到此这篇关于mysql如何设置不区分大小写的文章就介绍到这了,更多相关mysql设置不区分大小写内容请搜索毛票票以前的文章或继续浏览下面的相关文章希望大家以后多多支持毛票票!