mysql 5.7 不等于_mysql-5.7.26 版本，表不区分区分大小写问题

log_timestamps = SYSTEM

socket = /home/ap/mysql/mysql.sock

basedir =/home/ap/mysql

datadir = /home/ap/mysql/data

pid-file = /home/ap/mysql/mysql.pid

max_connections = 1000

max_connect_errors = 1000

table_open_cache = 1024

max_allowed_packet = 128M

open_files_limit = 65535

server-id=1

gtid_mode=on

enforce_gtid_consistency=on

log-slave-updates=1

log-bin=master-bin

log-bin-index = master-bin.index

relay-log = relay-log

relay-log-index = relay-log.index

binlog_format=row

log_error = /home/ap/mysql/log/mysql-error.log

skip-name-resolve

log-slave-updates=1

relay_log_purge = 0

slow_query_log = 1

long_query_time = 1

slow_query_log_file = /home/ap/mysql/log/mysql-slow.log

3.1重启mysql命令

/etc/init.d/mysql restart

3.2再次验证

mysql> show variables like ‘%lower%‘;

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

| Variable_name | Value |

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

| lower_case_file_system | OFF |

| lower_case_table_names | 1 |

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

2 rows in set (0.00 sec)

mysql> select * from CM_VERSION;

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

| VERSION | GUID | LAST_UPDATE_INSTANT | TS | HOSTNAME | LAST_ACTIVE_TIMESTAMP |

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

| 5.13.3 | 1e440f97-6cea-403c-b712-f853b2a74752 | 1576748189778 | NULL | dataexa-cdh-test-01/192.168.1.228 | 1576830522188 |

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

1 row in set (0.00 sec)

mysql-5.7.26 版本，表不区分区分大小写问题

标签：socket   分区   cli   purge   cte   host   bin   utf8   sel

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：https://www.cnblogs.com/pythonx/p/12073814.html