【无标题】

---

title: “离线安装mysql”
createTime: 2021-07-01T11:37:32+08:00
updateTime: 2021-07-01T11:37:32+08:00
draft: false
author: “name”
tags: [“install”,“DB”]
categories: [“linux”]
description: “测试的”

离线安装mysql

1.查看是否安装

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

2.如果已安装则卸载rpm

rpm -e --nodeps

–nodeps:由于安装包的依赖问题，需要强制删除

3.下载rpm包

rpm包
mysql-community-client
mysql-community-devel
mysql-community-libs
mysql-community-server
mysql-community-libs
mysql-community-common

4.将rpm包通过xftp等方式放入linux服务器

5.根据rpm安装

到rpm包目录下使用命令

rpm -ivh --force mysql-community-common-5.7.24-1.el7.x86_64.rpm mysql-community-libs-5.7.24-1.el7.x86_64.rpm mysql-community-client-5.7.24-1.el7.x86_64.rpm mysql-community-server-5.7.24-1.el7.x86_64.rpm mysql-community-devel-5.7.24-1.el7.x86_64.rpm mysql-community-libs-compat-5.7.24-1.el7.x86_64.rpm

6.启动mysql

service mysqld start

7.获取初始化密码

grep 'temporary password' /var/log/mysqld.log

如果没有显示，可能原因是上次安装的残留没有删除干净，使用命令删除

rm -rf /var/lib/mysql

然后重启mysql后再去获取初始化密码

service mysqld restart
grep 'temporary password' /var/log/mysqld.log

如果还是没有。。。那就打开mysqld.log找一下

tail -n 100 /var/log/mysqld.log

8.登录mysql

mysql -u root -p

9.修改密码（注意mysql5.0版本与8.0版本的方式不同，可面向搜索引擎查找）

SET PASSWORD = PASSWORD('密码');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
flush privileges;