mysql 5.7配置兼容5.6_mysql的配置文件适用5.6与5.7

根据inside君的配置文件整理而来。[mysql]

port            = 3306

socket          = /data/mysql/3306/mysql_3306.sock

default-character-set=utf8

prompt = [\\u@\\h][\\d]>\\_

[mysqld]

# basic settings #

user=nobody                  #调整为实际user

sql_mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER"

autocommit = 1

character_set_server=utf8

transaction_isolation = READ-COMMITTED

explicit_defaults_for_timestamp = 1

max_allowed_packet = 16M

event_scheduler = 1

server-id = 123383306        #在主从环境中需要调整

datadir=/data/mysql/3306     #调整为实际的数据目录

default_storage_engine=InnoDB

lower_case_table_names = 1

federated

port            = 3306

socket          = /data/mysql/3306/mysql_3306.sock

back_log = 150

bulk_insert_buffer_size = 64M

max_heap_table_size = 64M

# connection #

interactive_timeout = 1800

wait_timeout = 1800

lock_wait_timeout = 1800

skip_name_reso