CentOS7离线安装MySql5.7

CentOS7离线安装MySql5.7

一、清除Mariadb

rpm -qa |grep mariadb |xargs yum remove -y

二、安装MySql

1. 下载MySql的相关rpm包

在dev.mysql.com/downloads/m… 选择Archives选项卡，产品版本选择5.7.36，操作系统选择Red Hat Enterprise Linux 7/Oracle Linux 7，把OS的版本选择为all，直接下载mysql-5.7.36-1.el7.x86_64.rpm-bundle.tar，所有的rpm包都在里面。可以通过下面的命令来下载rpm包：

wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.36-1.el7.x86_64.rpm-bundle.tar

2. 解压mysql-5.7.36-1.el7.x86_64.rpm-bundle.tar

将下载的mysql-5.7.36-1.el7.x86_64.rpm-bundle.tar放到/usr/local/mysql目录，解压缩安装包，命令如下：

tar axvf mysql-5.7.36-1.el7.x86_64.rpm-bundle.tar

3. 安装rpm包

切换到下载包目录下（cd 你的下载目录），然后对每个包进行一次安装； 安装可能会报libaio包不存在 使用如下命令安装

yum install -y libaio-devel

rpm -ivh mysql-community-common-5.7.36-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.36-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.36-1.el7.x86_64.rpm
rpm -ivh mysql-community-embedded-5.7.36-1.el7.x86_64.rpm
rpm -ivh mysql-community-embedded-compat-5.7.36-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.36-1.el7.x86_64.rpm
rpm -ivh mysql-community-embedded-devel-5.7.36-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.36-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.36-1.el7.x86_64.rpm

4. 初始化Mysql数据库

mysqld --initialize
chown mysql:mysql /var/lib/mysql -R
systemctl start mysqld.service
systemctl enable mysqld

三、启动MySql服务

1. MySql相关命令

# 启动 
systemctl start mysqld.service 
# 停止 
systemctl stop mysqld.service 
# 重启 
systemctl restart mysqld.service

2. 查看Mysql随机密码

cat /var/log/mysqld.log | grep password

3.登录Mysql 使用上述随机密码

mysql -u root -p

4.修改用户密码

# 修改用户密码
alter user user() identified by "123456"; 
# 刷新权限 
flush privileges;

5.设置root远程连接

# 授权 
grant all privileges on *.* to 'root'@'%' identified by '123456'; 
# 刷新权限 
flush privileges;

6.退出Mysql

exit;