centos7离线安装mysql

1: 下载安装包
直接下载mysql-5.7.21-1.el7.x86_64.rpm-bundle.tar，所有的rpm包都在里面

https://dev.mysql.com/downloads/mysql/

选择Red Hat Enterprise Linux 7 / Oracle Linux 7 ，把os的版本选择为all

安装之前先卸载自带的mysql
搜索mysql的rpm包

rpm -qa |grep -i mysql
rpm -qa |grep -i mariadb

删除mysql

rpm -e mariadb-libs-5.5.35-3.el7.x86_64 --nodeps
rpm -e mysql-xxx-5.5.35-3.el7.x86_64 --nodeps

再安装mysql需要的依赖包 libaio依赖 和 net-tools 依赖

yum -y install libaio
yum -y install net-tools

2 ： 解压安装包，依次安装一下rpm包

rpm -ivh mysql-community-common-5.7.21-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-5.7.21-1.el7.x86_64.rpm

rpm -ivh mysql-community-devel-5.7.21-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-compat-5.7.21-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-5.7.21-1.el7.x86_64.rpm

rpm -ivh mysql-community-server-5.7.21-1.el7.x86_64.rpm

3，
停止服务

service mysqld stop

编辑
vi /etc/my.cnf
添加

skip-grant-tables     #添加这句话，这时候登入mysql就不需要密码
symbolic-links=0

开启服务

service mysqld start

mysql> mysql -uroot -p

回车

刷新权限

mysql>flush privileges;

设置密码

mysql>set password for root@localhost = password('123456');

刷新权限

mysql>flush privileges

重启服务

service mysqld restart

设置开机启动

systemctl enable mysqld

3 : 开放mysql远端访问

select user,host from user;

update user set host='%' where user='root';

flush privileges;

4: 关闭防火墙

systemctl stop firewalld
systemctl disable firewalld