MySQL 8.0.12中的lower_case_table_names设置 [英] lower_case_table_names Settings in MySQL 8.0.12

问题描述

我刚刚在Ubuntu 16.0.4中编译了MySQL 8.0.12版本.

I've just compiled the version MySQL 8.0.12 in a Ubuntu 16.0.4.

按照网站上的说明并制作以下​​my.cnf文件后:

After following the instructions in the website and making the following my.cnf file:

[mysqld]
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
port=3306
log-error=/usr/local/mysql/data/localhost.localdomain.err
user=mysql
secure_file_priv=/usr/local/mysql/mysql-files
local_infile=OFF

log_error = /var/log/mysql/error.log

# Remove case sensitive in table names
lower_case_table_names=1

我收到以下错误:

2018-08-11T19:45:06.461585Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('1') and data dictionary ('0').

我应该更改什么以使数据字典与服务器设置保持一致?

What should I change so that data dictionary is aligned to server settings?

推荐答案

按照此链接，lower_case_table_names应该与--initialize选项一起设置.

As per this link, lower_case_table_names should be set together with --initialize option.

这篇关于MySQL 8.0.12中的lower_case_table_names设置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！