centos6.10 mysql 5.7_如何在CentOS6.10安装MySQL5.7

由于MySQL5.7没有带配置文件，自己手动增加一个配置文件，放在/etc/my.cnf，配置文件参数可根据实际情况修改

vim /etc/my.cnf

[client]

port   = 3306

socket  = /home/data/mysql/mysql.sock

default-character-set = utf8

[mysqld]

user    = mysql

port    = 3306

socket  = /home/data/mysql/mysql.sock

basedir = /opt/mysql

datadir = /home/data/mysql/data

character-set-server = utf8

server-id=123306

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

log-bin = /home/data/mysql/log/mysql-bin

relay-log = /home/data/mysql/log/relay-log

relay-log-info-file = /home/data/mysql/log/relay-log.info

binlog_format=ROW

gtid_mode=on

enforce_gtid_consistency=1

log_slave_updates=1

wait_timeout = 5

interactive_timeout = 5

max_connections=100

master_info_repository=TABLE

relay_log_info_repository=TABLE

sync_master_info=1

slave_parallel_workers=2

binlog_checksum=CRC32

master_verify_checksum=1

slave_sql_verify_checksum=1

binlog_rows_query_log_events=1

log_bin=mysql-bin.log

#replicate_do_db=tt

slave_parallel_type=logical_clock

sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

[mysqld_safe]

log-error=/home/data/mysql/mysql.err