无网络linux下安装mysql5.7

1、查询服务器内预安装的mysql文件并清除
查包名：rpm -qa|grep -i mysql
删除命令：rpm -e –nodeps 包名

2、下载下面需要的rpm包
mysql-community-common-5.7.28-1.el7.x86_64.rpm
mysql-community-libs-5.7.28-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm
mysql-community-client-5.7.28-1.el7.x86_64.rpm
mysql-community-server-5.7.28-1.el7.x86_64.rpm

3、将上述的rpm包上传至服务器并安装
rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm

4、启动mysql数据库
启动：systemctl start mysql\service mysqld start
查看状态：systemctl status mysqld\service mysqld status
重启：systemctl restart mysqld\service mysqld restart

5、查看数据库密码
grep “password” /var/log/mysqld.log
A temporary password is generated for root@localhost: hilX0U!9i3_6
6、进入数据库并更新密码，root密码：hilX0U!9i3_6
7、设置新密码
SET PASSWORD = PASSWORD(‘密码’);
ALTER USER ‘root’@‘localhost’ PASSWORD EXPIRE NEVER;
flush privileges;
设置用户 root 可以在任意 IP 下被访问：
grant all privileges on . to root@“%” identified by “密码”;
设置用户 root 可以在本地被访问：
grant all privileges on . to root@“localhost” identified by “密码”;
刷新权限使之生效：
flush privileges;