centos7虚拟机中安装mysql5.7

https://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html

1. 添加mysql的yum仓库

wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm
sudo yum localinstall mysql80-community-release-el7-3.noarch.rpm
# 查看默认启动的版本安装包组件
yum repolist enabled | grep "mysql.*-community.*"

2. 选择版本

# 查看所有支持的版本
yum repolist all | grep mysql
# 安装yum管理工具，以便使用命令yum-config-manager
yum install yum-utils

# 禁用mysql8.0，启用mysql5.7
sudo yum-config-manager --disable mysql80-community
sudo yum-config-manager --enable mysql57-community
# 查看当前已启动的组件
yum repolist enabled | grep mysql

# 也可以通过直接修改配置文件来禁用mysql8.0，启用mysql5.7
# vi /etc/yum.repos.d/mysql-community.repo

3. 安装

sudo yum install mysql-community-server

4. 运行启动

# 启动mysql
sudo service mysqld start 
# 查看mysql运行状态
sudo service mysqld status

5. 修改root密码

# 查看初始的root密码
sudo grep 'temporary password' /var/log/mysqld.log
# 使用初始密码登录mysql
mysql -uroot -p
# 修改root用户密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Abc123456?';

6. root远程登录

# 本地登录mysql
mysql -uroot -p
# 查看用户表信息
use mysql;
select host,user from user;

# 授权远程登录
update user set host ='%' where user ='root';

# 修改权限
grant all on *.*  to 'root'@'%' identified by 'Abc123456?' with grant option;

flush privileges;

7. 添加其他用户test

# root用户登录
mysql -uroot -p
# 创建test用户
CREATE USER 'test'@'%' IDENTIFIED WITH mysql_native_password BY 'Test12@!';
# 给test用户授权（所有权限）
GRANT ALL PRIVILEGES ON *.* TO 'test'@'%';
flush privileges;