docker 安装mysql5.6.29_docker安装mysql5.7

[mysqld]

pid-file= /var/run/mysqld/mysqld.pid

socket= /var/run/mysqld/mysqld.sock

datadir= /var/lib/mysql

#log-error= /var/log/mysql/error.log

# By default we only accept connections from localhost

#bind-address= 127.0.0.1

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

sql_mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

lower_case_table_names=1

问题原因:

Linux系统下Mysql数据表大小写敏感

解决办法

修改Mysql配置文件, 在[mysqld]在下面增加一行

lower_case_table_names=1 (0:大小写敏感;1:大小写不敏感)