Mysql5.7 yum安装

1. 官方下载yum源

https://dev.mysql.com/downloads/repo/yum/
![1.jpg](https://img.haomeiwen.com/i16514370/8245dcc1cacb4072.jpg?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)

# 下载后为这个文件，上传到linux
mysql80-community-release-el7-5.noarch.rpm

2. 安装yum源

2.1. 安装前先卸载mysql

# 查看是否存在历史安装
yum list installed mysql*
# 删除安装包
yum remove mysql-community-client    mysql-community-common mysql-community-libs mysql-community-libs-compat mysql-community-server mysql57-community-release       
# 删除配置文件
rm -rf /var/lib/mysql       
rm /etc/my.cnf  

2.1. 安装mysql

yum install mysql80-community-release-el7-5.noarch.rpm

3. 修改yum源8.0=>5.7

vim /etc/yum.repos.d/mysql-community.repo
# 打开mysql5.7 关闭mysql8.0
![5.7.jpg](https://img.haomeiwen.com/i16514370/6e2d7783eece5575.jpg?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)
# 查看yum源是否为5.7
yum list |grep mysql

4. 安装mysql5.7

yum -y install mysql-community-server
# 启动命令
systemctl start mysqld
systemctl status mysqld
systemctl restart mysqld     
# 设置开机自启
systemctl enable mysqld
# 刷新systemctl配置
systemctl daemon-reload
# 查看mysql默认初始密码
grep 'temporary password' /var/log/mysqld.log

# 连接MySQL并设置密码、权限
mysql -uroot -p
set global validate_password_policy=0;

set password for 'root'@'localhost'=password('zhkj$2019123');

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'zhkj$2019123' WITH GRANT OPTION;

flush privileges;

5. 修改mysql 配置文件

5.1 修改数据存放目录

# 1 查看当前目录
 select @@datadir;  // /var/lib/mysql 
# 2 目录迁移
# 先关闭mysql,后迁移
停用mysql服务  systemctl stop mysqld
 rsync -av /var/lib/mysql   /mnt/data;
 mv /var/lib/mysql /var/lib/mysql.bak  ;

5.2修改mysql配置文件

vim /etc/my.cnf
#修改[mysqld]

default-time_zone = '+8:00'   
character-set-server = utf8mb4         
collation-server = utf8mb4_bin                

datadir=/mnt/data/mysql

socket=/mnt/data/mysql/mysql.sock

 #设置端口号
port=3306 
socket=/mnt/data/mysql/mysql.sock  

6.开启binlog

#log_bin 为 on 则已开启
show variables like '%log_bin%'; 
# 开启binlog，设置一下配置文件
vim /etc/my.cnf
server-id=12345
log-bin=/mnt/binlog/mysql-bin
binlog_format=mixed
sync-binlog=1000
#若启动mysql报错，需要给mysql 设置权限
chown -R mysql.mysql /mnt/mysqlog