安装MySQL5.7

1. 安装yum源

wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
rpm -ivh mysql57-community-release-el7-8.noarch.rpm
yum repolist enabled | grep "mysql.-community."

yum repolist enable | grep "mysql.-comunity" 命令相当于修改yum默认安装的MySQL,可以分解如下两步：

1. 查看yum默认安装的MySQL 使用命令yum repolist all| grep mysql进行查看
2. 修改默认安装 使用命令vi /etc/yum.repos.d/mysql-community.repo，进行修改
3. 再次查看默认安装 使用命令yum repolist all| grep mysql进行再次查看

2. 使用yum安装MySQL5.7

yum -y install mysql-community-server

3. 编辑配置文件my.cnf

使用vi编辑/etc/my.cnf，并且添加下面几行

[client]
port = 3306

[mysqld]
port = 3306
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
init_connect=‘SET NAMES utf8mb4‘

4. 启动MySQL

systemctl start mysqld

5. 修改密码和访问HOST

1. 查看初始化密码：grep 'temporary password' /var/log/mysqld.log
2. 使用初始化密码登陆：mysql -uroot -p
3. 修改密码，注意由于MySQL密码强度要求，必须包含大小写特殊字符和数字，所以密码要稍稍复杂些

 SET PASSWORD = PASSWORD('admin123@QQ.com');

4. 修改访问root用户的HOST

 UPDATE mysql.user set host = '%' where user ='root';

5. 刷新并退出设置

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

6. 设置开启自动启动

# 启动和查看启动状态
systemctl start mysqld
systemctl status mysqld

# 开机启动
systemctl enable mysqld
systemctl daemon-reload