CentOS7离线安装mysql5.7

1.安装前，先检查系统自带的mariadb是否存在，如存在则需要卸载

rpm -qa | grep mariadb
rpm -e --nodeps `rpm -qa | grep mariadb`

2.上传并解压缩mysql-5.7.33-1.el7.x86_64.rpm-bundle.tar

tar -zxvf mysql-5.7.33-1.el7.x86_64.rpm-bundle.tar

3.使用rpm方式一次安装mysql依赖

rpm -ivh mysql-community-common-5.7.33-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.33-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.33-1.el7.x86_64.rpm
rpm -ivh libaio-0.3.109-13.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.33-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.33-1.el7.x86_64.rpm

4.初始化数据库

mysql_install_db --datadir=/var/lib/mysql
mysqld --initialize

5.修改/etc/my.cnf配置文件

[client]
#默认连接端口　　　　　　　　　　　　　　　　
port = 3306
#用于本地连接的socket套接字
socket = /var/lib/mysql/mysql.sock
#编码
default-character-set = utf8mb4

[mysqld]
datadir=/var/lib/mysql/data
socket=/var/lib/mysql/mysql.sock
symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
#MySQL监听端口
port = 3306

6.更改mysql数据库目录的所属用户及其所属组，并启动mysql数据库

chown mysql:mysql /var/lib/mysql -R
systemctl start mysqld.service

7./etc/my.cnf文件中mysqld部分添加skip-grant-tables

#用于首次登录跳过密码校验
skip-grant-tables

8.重启mysql服务并登录

mysql

9.选择mysql数据库实例，并修改root密码

set global validate_password_policy=0;
set global validate_password_length=1;
#修改root密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';
#授权任何主机
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
#授权指定主机
GRANT ALL PRIVILEGES ON *.* TO 'xxxx'@’xx.xx.xx.xx’ IDENTIFIED BY 'xxxx' WITH GRANT OPTION;
# 然后刷新权限
flush privileges;