wordpress快站,怎么样才能在网上卖东西,建设个人网页,上海模板建站平台windows下mysql默认是不区分大小写的#xff0c;但是linux会区分大小写#xff0c;所以当执行的sql语句有大小写区别时需要注意。那么怎么设置mysql不区分大小写。1.windows下到安装mysql的目录#xff0c;修改my.ini文件在文件最后一行加上下面一句话lower_case_table_name…windows下mysql默认是不区分大小写的但是linux会区分大小写所以当执行的sql语句有大小写区别时需要注意。那么怎么设置mysql不区分大小写。1.windows下到安装mysql的目录修改my.ini文件在文件最后一行加上下面一句话lower_case_table_names1lower_case_table_names 1说明 0区分大小写1不区分大小写效果如下[mysqld]port 3306 basedirF:/mysql-5.7.21-winx64datadirF:/mysql-5.7.21-winx64/datamax_connections200 character-set-serverutf8default-storage-engineINNODB sql_modeNO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES[mysql]default-character-setutf8 lower_case_table_names1重启mysql2.linux下进入etc下面cd /etc/编辑my.cnf文件vi my.cnf最后一行加上下面一句lower_case_table_names1效果如下# For advice on how to change settings please see# http://dev.mysql.com/doc/refman/5.7/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 2Mdatadir/var/lib/mysqlsocket/var/lib/mysql/mysql.sock# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links0log-error/var/log/mysqld.logpid-file/var/run/mysqld/mysqld.pidlower_case_table_names1重启mysqlsystemctl restart mysqld
