mysql5.7.27二进制安装

step1: yum安装所需相关依赖包

yum -y install gcc-c++ zlib zlib-devel pcre pcre-devel openssl-devel libaio-devel.x86_64

step2: 下载并解压

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz
tar -xf MySQL-5.7/mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz -C /usr/local/mysql

step3: 相关权限

groupadd mysql     						#先创建mysql组
useradd -r -g mysql -s /bin/false mysql #将MySQL用户加入mysql组
mkdir -p /u01/mysql/{data,log} #创建数据目录和存放日志目录 chown -R mysql:mysql /u01/mysql
chmod 750 /u01/mysql           #权限调整

step4: 编辑配置文件

[client]
port = 3306
socket = /u01/mysql/mysql.sock
[mysqld]
port = 3306
user = mysql
character-set-server = utf8mb4
default_storage_engine = innodb
log_timestamps = SYSTEM
socket = /u01/mysql/mysql.sock
basedir =/usr/local/mysql
datadir = /u01/mysql/data
pid-file = /u01/mysql/mysql.pid
max_connections = 1000
max_connect_errors = 1000
table_open_cache = 1024
max_allowed_packet = 128M
open_files_limit = 65535
server-id=10
gtid_mode=on
enforce_gtid_consistency=on
log-slave-updates=1
log-bin=master-bin
log-bin-index = master-bin.index
relay-log = relay-log
relay-log-index = relay-log.index
binlog_format=row
log_error = /u01/mysql/log/mysql-error.log
skip-name-resolve
log-slave-updates=1
relay_log_purge = 0
#慢查询日志配置
slow_query_log = 1
long_query_time = 1
slow_query_log_file = /u01/mysql/log/mysql-slow.log  

step5: 初始化

/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/u01/mysql/data
/usr/local/mysql/bin/mysql_ssl_rsa_setup --datadir=/u01/mysql/data  #创建ssl加密，可以不做

step6: 查看初始密码

grep 'password' /u01/mysql/log/mysql-error.log

step7: 拷贝和配置启动文件,并修改路径

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
vim /etc/init.d/mysqld
basedir=/usr/local/mysql
datadir=/u01/mysql/data

step8: 设置开机启动，并配置环境变量

chkconfig --add mysqld
chkconfig mysqld on
echo 'PATH=/usr/local/mysql/bin:$PATH'>>/etc/profile
tail -1 /etc/profile
source /etc/profile #让环境变量生效
echo $PATH #检查变量是否添加成功

step9: 启动mysql，并修改密码

service mysqld start
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';