Linux MySQL5.7 rpm离线安装

妖狐艹你老母 2023-06-10 10:23 224阅读 0赞

## 前言 ##

使用到的环境是 MySQL 5.7 版本

## 演示 ##

[官网下载][Link 1]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMwODg5Mzcz_size_16_color_FFFFFF_t_70]

下载软件包，拷贝到 /root/vagrant/ 目录

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar

解压

tar xvf mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar

安装依赖的程序包

yum install -y perl net-tools

卸载mariadb程序包

*  Centos 捆绑了 mariadb-libs，所以必须先卸载

rpm -qa|grep mariadb
    rpm -e mariadb-libs-5.5.60-1.el7_5.x86_64 --nodeps

or 使用这个方法

yum -y remove mari*

安装MySQL程序包

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-client-5.7.28-1.el7.x86_64.rpm
    rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm

如果出现以下问题，可以查找安装

error: Failed dependencies:
    	libaio.so.1()(64bit) is needed by mysql-community-server-5.7.28-1.el7.x86_64
    	libaio.so.1(LIBAIO_0.1)(64bit) is needed by mysql-community-server-5.7.28-1.el7.x86_64
    	libaio.so.1(LIBAIO_0.4)(64bit) is needed by mysql-community-server-5.7.28-1.el7.x86_64

yum search libaio

yum install -y libaio.x86_64

yum install -y libaio-devel.x86_64

修改MySQL目录权限

chmod -R 777 /var/lib/mysql/

初始化MySQL

mysqld --initialize
    chmod -R 777 /var/lib/mysql/*

## 操作 ##

启动服务

systemctl start mysqld

停止服务

systemctl stop mysqld

查看mysql状态

systemctl status mysqld

设置为开机启动

systemctl enable mysqld

重载所有修改过的配置文件

systemctl daemon-reload

查看默认密码

我这里密码是 `>uUMt-C8.uwj`

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

[Note] A temporary password is generated for root@localhost: >uUMt-C8.uwj

修改默认密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Abc778899!';

允许远程使用root帐户

UPDATE user SET host = '%' WHERE user ='root';
    FLUSH PRIVILEGES;

允许远程访问MySQL数据库（/etc/my.cnf）

character_set_server = utf8
    bind-address = 0.0.0.0

开启防火墙3360端口

`如果你是阿里云的主机，或者其他的线上主机，请自行去账号处设置安全组`

firewall-cmd --zone=public --add-port=3306/tcp --permanent
    firewall-cmd --reload

[Link 1]: https://dev.mysql.com/downloads/mysql/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMwODg5Mzcz_size_16_color_FFFFFF_t_70]: /images/20230531/8f1fe151c5f54fd49b99702f7b2230e1.png