linux mariadb 大小写,树莓派mariadb关闭大小写区分

pi@raspberrypi:~ $ mysql -u root -p

Enter password:

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 11

Server version: 10.3.27-MariaDB-0+deb10u1 Raspbian 10

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show variables like '%lower_case_table_names';

+------------------------+-------+

| Variable_name | Value |

+------------------------+-------+

| lower_case_table_names | 1 |

+------------------------+-------+

1 row in set (0.004 sec)

MariaDB [(none)]>

通过上面的命令 show variables like '%lower_case_table_names';可以查看到lower_case_table_names为1默认为0

0 大小写敏感

1 大小写不敏感

2 表名存储为给定的大小写但是比较的时候是小写的

设置方法

修改/etc/mysql/mariadb.conf.d/50-server.cnf 加入下面一行内容#

# These groups are read by MariaDB server.

# Use it for options that only the server (but not clients) should see

#

# See the examples of server my.cnf files in /usr/share/mysql

# this is read by the standalone daemon and embedded servers

[server]

# this is only for the mysqld standalone daemon

[mysqld]

lower_case_table_names=1

在 [mysqld] 下面加入 lower_case_table_names=1 然后重启数据库 sudo systemctl restart mariadb 就关闭了大小写的区分