centos7安裝mysql5.7(rpm方式)

1. 下载rpm

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

wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm

2. 安装

 sudo yum localinstall mysql80-community-release-el7-3.noarch.rpm

3. 查看列表

yum repolist all | grep mysql

4. 选择合适的版本(2种方式)

• 命令方式

#禁用8.0版本，启用5.7版本  
sudo yum -y install yum-utils
sudo yum-config-manager --disable mysql80-community
sudo yum-config-manager --enable mysql57-community

• 修改配置文件方式

#查看编辑文件
 vi /etc/yum.repos.d/mysql-community.repo 
 
#enabled 为0时表示禁用，为1表示启用
# Enable to use MySQL 5.7
[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

#禁用8.0版本，将对应的enabled改为0
# ...

5. 查看启用的列表

yum repolist enabled | grep mysql

6. 禁用mysql默认模块(可选，(EL8 systems only) )

sudo yum module disable mysql

7. 安装mysql

#安装
sudo yum install mysql-community-server

8. 启动mysql

#首选（对于基于EL7和EL8的平台，这是首选命令）
sudo systemctl start mysqld.service
#次选
sudo service mysqld start

9. 查看运行状态

#首选（对于基于EL7和EL8的平台，这是首选命令）
sudo systemctl status mysqld.service
#次选
sudo service mysqld status

10. 查看root密码

sudo grep 'temporary password' /var/log/mysqld.log

11. 连接mysql

mysql -uroot -p

12. 修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

13. 创建用户并授权

CREATE USER 'admin'@'localhost' IDENTIFIED BY 'PASSword@123';
GRANT ALL ON *.*  TO 'admin'@'localhost';

CREATE USER 'admin'@'127.0.0.1' IDENTIFIED BY 'PASSword@123';
GRANT ALL ON *.* TO 'admin'@'127.0.0.1';
#创建admin用户并授权远程登录
CREATE USER 'admin'@'%' IDENTIFIED BY 'PASSword@123';
GRANT ALL ON *.* TO 'admin'@'%';

CREATE USER 'admin'@'192.168.28.1' IDENTIFIED BY 'PASSword@123';
GRANT ALL ON *.* TO 'admin'@'192.168.28.1';

flush privileges;