200字范文,内容丰富有趣,生活中的好帮手!
200字范文 > 如何设置mysql不区分大小写 ?

如何设置mysql不区分大小写 ?

时间:2020-02-27 09:11:31

相关推荐

如何设置mysql不区分大小写 ?

驰骋工作流引擎ccbpm不支持区分大小写模式,如何设置mysql不区分大小写 ?请参考如下文档。

1.windows下

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

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

lower_case_table_names=1

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

复制代码

重启mysql

2.linux下

进入etc下面

cd /etc/

编辑f文件

vi f

最后一行加上下面一句

lower_case_table_names=1

效果如下

复制代码

# For advice on how to change settings please see

# /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 = 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:

systemctl restart mysqld

下载各个版本的开源驰骋工作流引擎请点击 /down.htm

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。