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