1. 解压

tar -xzvf mysql-5.7.11-linux-glibc2.5-x86_64.tar.gz -C /usr/local      #  解压到  /usr/local 目录
mv /usr/local/mysql-5.7.11-linux-glibc2.5-x86_64 mysql    # 安装目录重命名

2. 设置配置文件参数：my.cnf 文件

vi /etc/my.cnf 
打开之后，拷贝如下内容替换原有文件

[client]

port            = 3306

socket          = /usr/local/mysql/data/mysql.sock

default-character-set=utf8mb4

[mysqld]

port            = 3306

socket          = /usr/local/mysql/data/mysql.sock

skip-slave-start

skip-external-locking

key_buffer_size = 256M

sort_buffer_size = 2M

read_buffer_size = 2M

read_rnd_buffer_size = 4M

query_cache_size= 32M

max_allowed_packet = 16M

myisam_sort_buffer_size=128M

tmp_table_size=32M

table_open_cache = 512

thread_cache_size = 8

wait_timeout = 86400

interactive_timeout = 86400

max_connections = 600

# Try number of CPU's*2 for thread_concurrency

#thread_concurrency = 32

#isolation level and default engine

default-storage-engine = INNODB

transaction-isolation = READ-COMMITTED

server-id  = 1739

basedir    = /usr/local/mysql

datadir    = /usr/local/mysql/data

pid-file    = /usr/local/mysql/data/hostname.pid

#open performance schema

log-warnings

sysdate-is-now

binlog_format = ROW

log_bin_trust_function_creators=1

log-error  = /usr/local/mysql/data/hostname.err

log-bin = /usr/local/mysql/arch/mysql-bin

expire_logs_days = 7

innodb_write_io_threads=16

relay-log  = /usr/local/mysql/relay_log/relay-log

relay-log-index = /usr/local/mysql/relay_log/relay-log.index

relay_log_info_file= /usr/local/mysql/relay_log/relay-log.info

log_slave_updates=1

gtid_mode=OFF

enforce_gtid_consistency=OFF

# slave

slave-parallel-type=LOGICAL_CLOCK

slave-parallel-workers=4

master_info_repository=TABLE

relay_log_info_repository=TABLE

relay_log_recovery=ON

#other logs

#general_log =1

#general_log_file  = /usr/local/mysql/data/general_log.err

#slow_query_log=1

#slow_query_log_file=/usr/local/mysql/data/slow_log.err

#for replication slave

sync_binlog = 500

#for innodb options

innodb_data_home_dir = /usr/local/mysql/data/

innodb_data_file_path = ibdata1:1G;ibdata2:1G:autoextend

innodb_log_group_home_dir = /usr/local/mysql/arch

innodb_log_files_in_group = 4

innodb_log_file_size = 1G

innodb_log_buffer_size = 200M

#根据生产需要，调整pool size

innodb_buffer_pool_size = 2G

#innodb_additional_mem_pool_size = 50M #deprecated in 5.6

tmpdir = /usr/local/mysql/tmp

innodb_lock_wait_timeout = 1000

#innodb_thread_concurrency = 0

innodb_flush_log_at_trx_commit = 2

innodb_locks_unsafe_for_binlog=1

#innodb io features: add for mysql5.5.8

performance_schema

innodb_read_io_threads=4

innodb-write-io-threads=4

innodb-io-capacity=200

#purge threads change default(0) to 1 for purge

innodb_purge_threads=1

innodb_use_native_aio=on

#case-sensitive file names and separate tablespace

innodb_file_per_table = 1

lower_case_table_names=1

[mysqldump]

quick

max_allowed_packet = 128M

[mysql]

no-auto-rehash

default-character-set=utf8mb4

[mysqlhotcopy]

interactive-timeout

[myisamchk]

key_buffer_size = 256M

sort_buffer_size = 256M

read_buffer = 2M

write_buffer = 2M

涉及到需要调整的参数时，自行修改

3.创建用户和用户组

    groupadd -g 101 dba    #创建用户组

    useradd -u 514 -g dba -G root -d /usr/local/mysql mysqladmin  # 创建用户，绑定到dba用户组

    usermod -u 514 -g dba -G root -d /usr/local/mysql mysqladmin

4.复制环境变量文件到mysqladmin用户家目录

cp /etc/skel/.* /usr/local/mysql
打开本地环境变量文件，配置 MySQL 的变量
vi /usr/local/mysq/.bashrc  进入文件，增加如下2行
export MYSQL_BASE=/usr/local/mysql
export PATH=$MYSQL_BASE/bin:$PATH

5. 赋权

chown mysqladmin:dba /etc/my.cnf 
chmod 640 /etc/my.cnf 
chown -R mysqladmin:dba /usr/local/mysql    # 文件夹赋用户和用户组
chmod -R 755 /usr/local/mysql               #文件夹赋权限

6.配置服务开机自启动

cd /usr/local/mysql
cp support-files/mysql.server /etc/rc.d/init.d/mysql  # 复制服务文件到init.d目录并改名为 mysql
chmod +x /etc/rc.d/init.d/mysql  # 赋予可执行权限
chkconfig --del mysql
chkconfig --add mysql
chkconfig --level 345 mysql on

7.安装libaio及安装mysql的初始db

yum -y install libaio
sudo su - mysqladmin  # 切换用户
进入：/usr/local/mysql/bin 目录执行:
mysqld \
--defaults-file=/etc/my.cnf \
--user=mysqladmin \
--basedir=/usr/local/mysql/ \
--datadir=/usr/local/mysql/data/ \
--initialize
初始化成功后，查看root用户临时密码：
cat /usr/local/mysql/data/hostname.err | grep password 

mysql_pwd.png

上述密码只是本人密码，你的密码许自行查找

8.登录

/usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf &

9. 登录及修改密码

mysql -uroot -p'自己查到的临时密码'
登录成功，进入操作界面后，执行：
alter user root@localhost identified by '新密码';  #  修改密码
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '新密码' ; # 设置所有ip通过 root 和 新密码 可以连接数据库
flush privileges;  # 刷新权限
exit;  # 退出
service mysql restart   # 重启mysql服务
mysql -uroot -p新密码  # root 用户登录

10.设置开机自启动

vi /etc/rc.local        # root 用户编辑
su - mysqladmin -c "/etc/init.d/mysql start --federated"  # 增加这一行，切换用户为 mysqladmin 时会启动mysql