RPM方式安装MySQL5.7

注：本教程以CentOS7为例，没错我就是那个爱折腾的人😜。

1、下载需要的rpm包

使用华为镜像分别下载 MySQL5.7的common 、libs 、client 、server 4个RPM包：

wget https://repo.huaweicloud.com/mysql/Downloads/MySQL-5.7/mysql-community-common-5.7.33-1.el6.x86_64.rpm

wget https://repo.huaweicloud.com/mysql/Downloads/MySQL-5.7/mysql-community-libs-5.7.33-1.el6.x86_64.rpm

wget https://repo.huaweicloud.com/mysql/Downloads/MySQL-5.7/mysql-community-client-5.7.33-1.el6.x86_64.rpm

wget https://repo.huaweicloud.com/mysql/Downloads/MySQL-5.7/mysql-community-server-5.7.33-1.el6.x86_64.rpm

2、安装4个RPM包

按照依赖顺序依次安装rpm包，依赖关系为common->libs->client->server

# --nodeps表示安装时不检查依赖关系 
# --force 表示强制安装
rpm -ivh mysql-community-common-5.7.33-1.el6.x86_64.rpm --force --nodeps 

rpm -ivh mysql-community-libs-5.7.33-1.el6.x86_64.rpm --force --nodeps

rpm -ivh mysql-community-client-5.7.33-1.el6.x86_64.rpm --force --nodeps

rpm -ivh mysql-community-server-5.7.33-1.el6.x86_64.rpm --force --nodeps

3、启动MySQL服务

# 启动MySQL服务
service mysqld start  # 扩展：关闭mysql服务命令 service mysqld stop

# 查看MySQL服务状态
service mysqld status

4、查看mysql默认生成的初始密码

cat /var/log/mysqld.log |grep password

5、登录MySQL服务器

mysql -uroot -pZeCkKsglg7+Z   # mysql -u账号 -p密码

6、修改root登录密码

# 设置密码校验强度为最低级别
set global validate_password_policy=0;

# 设置密码长度最少为4个字符 
set global validate_password_length=4;

# 修改密码
alter user 'root'@'localhost' identified by '123456';

# 刷新权限 
flush privileges; 

7、允许远程登录

# 查看mysql所有用户权限
select host,user from user;

# 设置root账户允许远程登录访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

# 刷新权限
flush privileges;

ok ，我们可以远程访问啦！

数据库文件默认存储在/var/lib/mysql目录下。

解决：远程连接还是无法访问题（关闭防火墙或者开放3306端口）

# 关闭防火墙
systemctl stop firewalld.service  

# 设置开机禁用防火墙
systemctl disable firewalld.service

# 检查防火墙状态
systemctl status firewalld 

---

完结撒花！！！