Linux离线安装MySQL5.7.24

朱雀 2022-12-06 15:52 189阅读 0赞

**目录**

一、下载安装包

二、卸载mariadb

三、安装MySQL

四、配置MySQL

五、初始化数据库

六、修改密码策略

七、允许防火墙通行

八、设置开机自启

九、MySQL卸载

十、yum在线安装

--------------------

### 一、下载安装包 ###

安装依赖

yum -y install perl autoconf gcc gcc-c++ make cmake lrzsz net-tools libaio

官方地址：[https://downloads.mysql.com/archives/community/][https_downloads.mysql.com_archives_community]

mysql-5.7.24-1.el7.x86\_64.rpm-bundle.tar：[https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.24-1.el7.x86\_64.rpm-bundle.tar][https_cdn.mysql.com_archives_mysql-5.7_mysql-5.7.24-1.el7.x86_64.rpm-bundle.tar]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70][]

### 二、卸载mariadb ###

**1、查看mariadb数据库是否安装**

rpm -qa | grep mariadb
    which mysql
    whereis mysql

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 1][] **2、卸载mariadb**

rpm -e mariadb-server --nodeps
    rpm -e mariadb-* --nodeps
    rpm -e mariadb-devel --nodeps
    rpm -e mariadb-libs --nodeps

**3、重新查看**

rpm -qa | grep mariadb

**4、查看mysql是否有安装过**

rpm -qa | grep -i mysql

**5、查看mysql相关文件**

把所有相关的文件全部删除

find / -name mysql

### 三、安装MySQL ###

**1、解压缩包**

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

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 2][]

**2、安装依赖包和服务（按顺序安装）**

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

![202009141525089.png][]

**3、查看版本和运行状态**

mysql --version

service mysqld status

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 3][]

### 四、配置MySQL ###

**1、查看磁盘挂载空间**

df -h

可以看到，/home目录挂载的磁盘容量有2.7T，所以将MySQL的数据存储路径修改到 /home目录下

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 4][]

**2、配置MySQL存储目录**

cp /etc/my.cnf /etc/my.cnf.template
    vim /etc/my.cnf

**3、home目录下创建数据目录，使用软链接链接到默认目录**

mkdir -p /home/var/lib/mysql
    ln -s /home/var/lib/mysql /var/lib/mysql
    ll /var/lib/mysql

![2020091421020571.png][]

### 五、初始化数据库 ###

**1、启动MySQL**

service mysqld start

**2、查看状态**

service mysqld status

![20200914190346854.png][]

**3、查看临时密码**

grep password /var/log/mysqld.log

![20200914181234525.png][]**4、初始化数据库**

sudo /usr/bin/mysql_secure_installation

提示输入密码输入回车键，显示 Disallow root login remotely? \[Y/n\] 输入n键，其它输入 Y键

如果提示：... Failed! Error: Your password does not satisfy the current policy requirements

将刚刚查询的临时密码输入，作为正式密码

> Estimated strength of the password: 25  
> Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y
> 
> New password:
> 
> Re-enter new password:
> 
> Remove anonymous users? (Press y|Y for Yes, any other key for No) : y  
> Success.
> 
> Disallow root login remotely? (Press y|Y for Yes, any other key for No) : n
> 
> Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y
> 
> Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y
> 
> All done!

### 六、修改密码策略 ###

**1、查看密码策略**

show variables like '%validate_password_policy%';
    show variables like '%validate_password_length%';

**2、修改密码策略**

set global validate_password_policy=0;
    set global validate_password_length=1;

**3、修改密码为root**

set password=password('root');

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('root');

**4、 给root用户赋所有权限**

grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;
    flush privileges;

### 七、允许防火墙通行 ###

firewall-cmd --add-port=3306/tcp --permanent
    firewall-cmd --reload
    firewall-cmd --list-ports

### 八、设置开机自启 ###

systemctl enable mysqld

chkconfig --add mysqld

###  **九、MySQL卸载** ###

rpm -e mysql-community-server
    rpm -e mysql-community-client
    rpm -e mysql-community-devel
    rpm -e mysql-community-libs-compat --nodeps
    rpm -e mysql-community-libs  --nodeps
    rpm -e mysql-community-common

rpm -qa | grep -i mysql

rm -rf  /var/lib/mysql/*
    rm -rf  /var/log/mysql*
    rm -rf  /var/run/mysqld/*

### 十、yum在线安装 ###

wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
    
    yum -y localinstall mysql57-community-release-el7-11.noarch.rpm 
    
    yum -y install mysql-community-server
    
    mysql --version
    
    systemctl start mysqld

[https_downloads.mysql.com_archives_community]: https://downloads.mysql.com/archives/community/
[https_cdn.mysql.com_archives_mysql-5.7_mysql-5.7.24-1.el7.x86_64.rpm-bundle.tar]: https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.24-1.el7.x86_64.rpm-bundle.tar
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70]: /images/20221123/851fecb332f1416587bd74e950e5acc4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 1]: /images/20221123/fbae2216c59d444da7571b975003bcd7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 2]: /images/20221123/5878e1f1bb0d4877a37cb0680cd64f1b.png
[202009141525089.png]: /images/20221123/904ae404f8c247e8b1a7aac8fca115fb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 3]: /images/20221123/c5ed83a2f789456bac4489c452be9b60.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70 4]: /images/20221123/9f8ae43a3dc04b369f4d961defa9332a.png
[2020091421020571.png]: /images/20221123/76e4d42f3df44fa38a5f5a32503c60f3.png
[20200914190346854.png]: /images/20221123/415c35c6d54e44ecb67b0eb523bc0b75.png
[20200914181234525.png]: /images/20221123/2e8b42ed9a834dec9c3b21dea1971327.png