mysql不区分大小写设置_mysql设置不区分大小写

r囧r小猫 2022-10-05 04:54 277阅读 0赞

windows下mysql默认是不区分大小写的，但是linux会区分大小写，所以当执行的sql语句有大小写区别时需要注意。
    
    那么怎么设置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/
    
    编辑my.cnf文件
    
    vi my.cnf
    
    最后一行加上下面一句
    
    lower_case_table_names=1
    
    效果如下
    
    # 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 = 2M
    
    datadir=/var/lib/mysql
    
    socket=/var/lib/mysql/mysql.sock
    
    # Disabling symbolic-links is recommended to prevent assorted security risks
    
    symbolic-links=0log-error=/var/log/mysqld.log
    
    pid-file=/var/run/mysqld/mysqld.pidlower_case_table_names=1
    
    重启mysql：
    
    systemctl restart mysqld