linux yum 安装 MySql5.7

1.下载 mysql 源安装包
在 MySQL 官网中下载 YUM 源 rpm 安装包：http://dev.mysql.com/downloads/repo/yum/

wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

2.安装 mysql 源

yum localinstall mysql57-community-release-el7-8.noarch.rpm

3.检查 mysql 源是否安装成功

yum repolist enabled | grep "mysql.-community.*"

4.改变默认安装的 mysql 版本

vim /etc/yum.repos.d/mysql-community.repo
比如要安装 5.7 版本，将 5.6 源的 enabled=1 改成 enabled=0。然后再将 5.7 源的 enabled=0 改成 enabled=1
[mysql56-community]
name=MySQL 5.6 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/7/$basearch/
enabled=0
gpgcheck=1
gpgkey=
[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/
enabled=1
gpgcheck=1
gpgkey=

5.安装 mysql

yum install mysql-community-server

7.启动 mysql

systemctl start mysqld

8.开机启动

systemctl enable mysqld
systemctl daemon-reload

9.修改 root 本地登录密码

mysql -uroot -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
或者
mysql> set password for 'root'@'localhost'=password('MyNewPass4!');

注意：mysql5.7 默认安装了密码安全检查插件（validate_password），默认密码检查策略要求密码必须包含：大小写字母、数字和特殊符号，并且长度不能少于 8 位。否则会提示 ERROR 1819 (HY000): Your password does not satisfy the current policy requirements 错误

10.远程登录

GRANT ALL PRIVILEGES ON . TO '用户'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;