MySQL离线安装 Linux安装MySQL最新版8.0 centos7离线安装mysql8.0 rpm包安装MySQL8.0

最新推荐文章于 2024-08-02 17:10:54 发布

狼宇

最新推荐文章于 2024-08-02 17:10:54 发布

阅读量1.6k

点赞数 1

文章标签： mysql 数据库 mariadb java linux

本文链接：https://blog.csdn.net/weixin_43947620/article/details/107086764

版权

1、首先准备需要用到的MySQL压缩包

这里我给大家提供了百度云链接，我的版本是8.0.17，你也可以自己在官网下载想要的rpm版本

链接：https://pan.baidu.com/s/1GGZPNRaRL6Rl3b948tv7jQ
提取码：ggwh

还有CSDN下载地址：
https://download.csdn.net/download/weixin_43947620/12572481

2、检查是否有旧版本的mysql包，有的centos镜像会默认携带

rpm -qa | grep mariadb

[root@DTS mysql]#  rpm -qa | grep mariadb
mariadb-libs-5.5.65-1.el7.x86_64

有的话要删除，没有的话就可以跳过下面的步骤了。

[root@DTS mysql]# rpm -e mariadb-libs-5.5.65-1.el7.x86_64 --nodeps

再次查看是否删除成功

[root@DTS mysql]# rpm -qa | grep mariadb
[root@DTS mysql]#

3、建立mysql文件夹并上传刚刚准备好的rpm压缩文件

[root@DTS /]# cd /usr/local/
[root@DTS local]# cd mysql/
[root@DTS mysql]#

接下来是上传文件，这里有很多种上传的方式，你可以用xshell的上传，也可以用xftp或者FileZilla client，总之选择你方便的方式，这里就不做详细讲解了。
上传好后查看如下：

[root@DTS mysql]# ls
mysql-8.0.17-1.el7.x86_64.rpm-bundle.tar

4、解压文件

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

[root@DTS mysql]# tar -xvf mysql-8.0.17-1.el7.x86_64.rpm-bundle.tar 
mysql-community-test-8.0.17-1.el7.x86_64.rpm
mysql-community-server-8.0.17-1.el7.x86_64.rpm
mysql-community-embedded-compat-8.0.17-1.el7.x86_64.rpm
mysql-community-client-8.0.17-1.el7.x86_64.rpm
mysql-community-devel-8.0.17-1.el7.x86_64.rpm
mysql-community-common-8.0.17-1.el7.x86_64.rpm
mysql-community-libs-compat-8.0.17-1.el7.x86_64.rpm
mysql-community-libs-8.0.17-1.el7.x86_64.rpm

5、安装common

rpm -ivh mysql-community-common-8.0.17-1.el7.x86_64.rpm --nodeps --force

[root@DTS mysql]# rpm -ivh mysql-community-common-8.0.17-1.el7.x86_64.rpm --nodeps --force
警告：mysql-community-common-8.0.17-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
准备中...                          ################################# [100%]
正在升级/安装...
   1:mysql-community-common-8.0.17-1.e################################# [100%]

6、安装libs

rpm -ivh mysql-community-libs-8.0.17-1.el7.x86_64.rpm --nodeps --force

[root@DTS mysql]# rpm -ivh mysql-community-libs-8.0.17-1.el7.x86_64.rpm --nodeps --force
警告：mysql-community-libs-8.0.17-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
准备中...                          ################################# [100%]
正在升级/安装...
   1:mysql-community-libs-8.0.17-1.el7################################# [100%]

7、安装client

rpm -ivh mysql-community-client-8.0.17-1.el7.x86_64.rpm --nodeps –

[root@DTS mysql]# rpm -ivh mysql-community-client-8.0.17-1.el7.x86_64.rpm --nodeps --force
警告：mysql-community-client-8.0.17-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
准备中...                          ################################# [100%]
正在升级/安装...
   1:mysql-community-client-8.0.17-1.e################################# [100%]

8、安装server

rpm -ivh mysql-community-server-8.0.17-1.el7.x86_64.rpm --nodeps --force

[root@DTS mysql]# rpm -ivh mysql-community-server-8.0.17-1.el7.x86_64.rpm --nodeps --force
警告：mysql-community-server-8.0.17-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
准备中...                          ################################# [100%]
正在升级/安装...
   1:mysql-community-server-8.0.17-1.e################################# [100%]

9、查看已安装的mysql安装包

rpm -qa | grep mysql

[root@DTS mysql]# rpm -qa | grep mysql
mysql-community-libs-8.0.17-1.el7.x86_64
mysql-community-common-8.0.17-1.el7.x86_64
mysql-community-server-8.0.17-1.el7.x86_64
mysql-community-client-8.0.17-1.el7.x86_64

到这就安装完毕了，接下来就是对mysql数据库的一些配置

10、对 mysql 数据库进行初始化和相关配置

mysqld --initialize; 初始化mysql
chown mysql:mysql /var/lib/mysql -R; 对操作文件赋予权限
systemctl start mysqld.service; 启动mysql服务
systemctl enable mysqld; 设置开机自启

[root@DTS mysql]# mysqld --initialize;
[root@DTS mysql]# chown mysql:mysql /var/lib/mysql -R;
[root@DTS mysql]# systemctl start mysqld.service;
[root@DTS mysql]# systemctl  enable mysqld;

11、查看生成的默认密码

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

[root@DTS mysql]# cat /var/log/mysqld.log | grep password
2020-07-02T06:44:39.579110Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: K+e9eX>=>IjQ

在这里插入图片描述这里就是密码

12、使用刚才查询到的密码登陆mysql并修改密码

[root@DTS mysql]# mysql -uroot -p
这里要输入刚才查到的密码，复制粘贴就好，这里输入密码时是不显示明文的。

[root@DTS mysql]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.17

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

然后输入
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘root’;
修改密码为root，你也可以改成别的，即更换BY后面引号内的内容，之后输入exit退出登录

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root'; 
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

13、重新登录mysql，进行远程访问授权

输入mysql -uroot -p，然后输入刚才修改的密码root

[root@DTS mysql]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.17 MySQL Community Server - GPL

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

通过以下命令，进行远程访问的授权

1、create user ‘root’@’%’ identified with mysql_native_password by ‘root’;
2、grant all privileges on . to ‘root’@’%’ with grant option;
3、flush privileges;
修改后退出MySQL

mysql> create user 'root'@'%' identified with mysql_native_password by 'root';
Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'root'@'%' with grant option;
Query OK, 0 rows affected (0.01 sec)

mysql> 
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

到这里MySQL就安装完毕了，但是通常这时候远程访问还是访问不到的，因为系统防火墙还没有关闭，下面这个步骤可选，如果工作环境不允许关闭防火墙就需要单独为MySQL开启远程端口，将MySQL端口添加到防火墙白名单，我图省事，直接把防火墙关了

14、关闭防火墙（可选步骤）

systemctl stop firewalld.service 停止防火墙
systemctl disable firewalld.service 禁用防火墙
systemctl mask firewalld.service 禁止开机自启

[root@DTS mysql]# systemctl stop firewalld.service;
[root@DTS mysql]# systemctl disable firewalld.service;
Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
[root@DTS mysql]# systemctl mask firewalld.service;
Created symlink from /etc/systemd/system/firewalld.service to /dev/null.

查看防火墙状态
systemctl status firewalld.service

[root@DTS mysql]# systemctl status firewalld.service;
● firewalld.service
   Loaded: masked (/dev/null; bad)
   Active: inactive (dead) since 四 2020-07-02 14:48:38 CST; 20s ago
 Main PID: 72326 (code=exited, status=0/SUCCESS)

7月 02 14:04:49 DTS firewalld[72326]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -t filter -X DOCKER' failed: iptables: No cha...at name.
7月 02 14:04:49 DTS firewalld[72326]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -t filter -F DOCKER-ISOLATION-STAGE-1' failed...at name.
7月 02 14:04:49 DTS firewalld[72326]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -t filter -X DOCKER-ISOLATION-STAGE-1' failed...at name.
7月 02 14:04:49 DTS firewalld[72326]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -t filter -F DOCKER-ISOLATION-STAGE-2' failed...at name.
7月 02 14:04:49 DTS firewalld[72326]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -t filter -X DOCKER-ISOLATION-STAGE-2' failed...at name.
7月 02 14:04:49 DTS firewalld[72326]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -t filter -F DOCKER-ISOLATION' failed: iptabl...at name.
7月 02 14:04:49 DTS firewalld[72326]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -t filter -X DOCKER-ISOLATION' failed: iptabl...at name.
7月 02 14:04:49 DTS firewalld[72326]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -D FORWARD -i docker0 -o docker0 -j DROP' fai...chain?).
7月 02 14:48:37 DTS systemd[1]: Stopping firewalld - dynamic firewall daemon...
7月 02 14:48:38 DTS systemd[1]: Stopped firewalld - dynamic firewall daemon.
Hint: Some lines were ellipsized, use -l to show in full.

OK！

这篇文章我参考了以下大神的思路，我是在这个基础之上做了简化和优化讲解，如果你是小白的话建议看下面这个，从零开始，如果有一定基础的话看我这个就够啦！

参考资料：
https://blog.csdn.net/weixin_42266606/article/details/80879571

狼宇

关注

1
点赞
踩
9

收藏

觉得还不错? 一键收藏
打赏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫