Linux离线安装MySQL5.7.24

目录

一、下载安装包

二、卸载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/

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

二、卸载mariadb

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

rpm -qa | grep mariadb
which mysql
whereis mysql

 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

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

3、查看版本和运行状态

mysql --version

service mysqld status

 

四、配置MySQL

1、查看磁盘挂载空间

df -h

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

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

五、初始化数据库

1、启动MySQL

service mysqld start 

2、查看状态

service mysqld status

3、查看临时密码

grep password /var/log/mysqld.log

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