centos7下离线安装mysql8的详细安装图解

比眉伴天荒 2022-12-28 04:05 383阅读 0赞

1.下载 MySQL 所需要的安装包

网址：https://dev.mysql.com/downloads/mysql/

![35621a78138802003544e1e21fd9e562.png][]

2.Select Operating System: 选择 Red Hat ，CentOS 是基于红帽的，Select OS Version: 选择 linux 7

![e6ed46748980b89b3860dfe536bf8326.png][]

3.选择 RPM Bundle 点击 Download

![55fc7c2bca43dd13dc37533174fc79e2.png][]

4.点击 No thanks, just start my download. 进行下载

![5272a457fa691c394191b7c2846483a3.png][]

5.下载好了

![b3d8a3ca5a592ef7bb4bec5d3fb0cd0e.png][]

6.打开 VMware，选中要使用的虚拟机，点击开启此虚拟机

![290dae73f6ca0f9214da66111e995b30.png][]

7.最小化虚拟机，不用管他了

![418f11303e8268f4fdf50bb14648f499.png][]

8.打开 xshell，选择虚拟机 ip 所对应的会话，点击连接

![af59cb70ed49eb70086087633745c9f9.png][]

9.连接成功

![66347537e50708474d675d1408c71d62.png][]

10.通过 rpm -qa | grep mariadb 命令查看 mariadb 的安装包

![aef25dbc9b77a327a69aad2216bbcccc.png][]

11.通过 rpm -e mariadb-libs-5.5.56-2.el7.x86\_64 --nodeps 命令装卸 mariadb

![59f44ad172d594153128f6cd12fa151a.png][]

12.通过 rpm -qa | grep mariadb 命令再次查看 mariadb 的安装包

![1954bd1f7184b6fb4a884a197de0bded.png][]

13.通过 cd /usr/local/ 命令进入根目录下的usr目录下的local目录，这个目录是放一些本地的共享资源的

![53164229e7317dd5e3ff48c577c41ecb.png][]

14.通过 ll 命令查看一下当前目录下的目录结构

![ca3d8aa4bff2d3fe96a9c0230ca94907.png][]

15.通过 mkdir mysql 命令 在当前目录下创建一个名为 mysql 的目录

![2f01e7a8337410defb66ad7f2150cba5.png][]

16.通过 ll 命令查看一下当前目录下的目录结构，刚创建的 mysql 目录有了

![34c00dcba025bf7c5d5b711379891fca.png][]

17.通过 cd mysql 命令进入 mysql 目录

![751da962c6826c5c776e1bd6e4e3836f.png][]

18.通过 ll 命令查看一下当前目录下的目录结构

![aba256cc97e03d0b0b3d4edfdadf59be.png][]

19.点击 窗口 -->> 传输新建文件，通过 ftp 协议来把刚下载好的 mysql 安装包传输到 CentOS7 系统中

![5f199303687a9b950aa3794a36d086bb.png][]

20.在左边找到你 mysql 安装包的下载目录

![932e136ad23c9295a4a53808204f836c.png][]

21.在你想要传输的文件上单机右键，点击传输

![0e4f76e76e8a188512694443b0f3890f.png][]

22.上传成功后，关闭 ftp 传输工具

![a37fd1b575d359498b7664b8e56ebb7d.png][]

23.通过 ll 命令查看一下当前目录下的目录结构

![ab110c0fb25b6b31fd096f6b8b979103.png][]

24.通过 tar -xvf mysql-8.0.11-1.el7.x86\_64.rpm-bundle.tar 命令解压 tar 包

![c19b1adee335e3fa872db9fa832dcc9f.png][]

25.通过 clear 命令清一下屏

![b570ea321bf6d7ba83c599d085d46711.png][]

26.通过 rpm -ivh mysql-community-common-8.0.11-1.el7.x86\_64.rpm --nodeps --force 命令安装 common

![c331a192efdbbcaa95a293b94037bac8.png][]

27.通过 rpm -ivh mysql-community-libs-8.0.11-1.el7.x86\_64.rpm --nodeps --force 命令安装 libs

![c66968b4a516eacb5f16ebbe9762b41d.png][]

28.通过 rpm -ivh mysql-community-client-8.0.11-1.el7.x86\_64.rpm --nodeps --force 命令安装 client

![962345b364b7d8dcb2a345c7a3ee4e47.png][]

29.通过 rpm -ivh mysql-community-server-8.0.11-1.el7.x86\_64.rpm --nodeps --force 命令安装 server

![71dd5e37f33ed1b146a4d6157a832bfe.png][]

30.通过 rpm -qa | grep mysql 命令查看 mysql 的安装包

![1c518822ef801a6ec2dfa78d319391b3.png][]

31.通过以下命令，完成对 mysql 数据库的初始化和相关配置

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

![2e25cdcfe5e30fedb8591c0ac3807b7c.png][]

32.通过 cat /var/log/mysqld.log | grep password 命令查看数据库的密码

![43a232d2127b57291ada38a4458920d6.png][]

33.通过 mysql -uroot -p 敲回车键进入数据库登陆界面

![8cf6e4ff78aac024e8edab8c16e236d8.png][]

34.输入刚刚查到的密码，进行数据库的登陆，复制粘贴就行，MySQL 的登陆密码也是不显示的

![6d9c633dc44cb12a316d8a2bc8d12bd9.png][]

35.通过 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql\_native\_password BY 'root'; 命令来修改密码

![6f3d0a1c5b1d44696c32355e6a57fcb0.png][]

36.通过 exit; 命令退出 MySQL，然后通过新密码再次登陆

![e60f90c77039b9af1c529864e9428119.png][]

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

create user 'root'@'%' identified with mysql\_native\_password by 'root';  
grant all privileges on \*.\* to 'root'@'%' with grant option;  
flush privileges;

![eab075130f0daba9147682532ddcc9c3.png][]

38.通过 ALTER USER 'root'@'localhost' IDENTIFIED BY 'root' PASSWORD EXPIRE NEVER; 命令修改加密规则，MySql8.0 版本 和 5.0 的加密规则不一样，而现在的可视化工具只支持旧的加密方式。

![e520fddb34fdea161fcdc9c7a471aca4.png][]

39.通过 flush privileges; 命令刷新修该后的权限

![1c2b1bff95f1c4b156d4db09fe4c28d3.png][]

40.通过 exit; 命令退出 MySQL

![701f44a3c240c430e5dd7b5982e8b437.png][]

41.通过以下命令，关闭 firewall

systemctl stop firewalld.service;  
systemctl disable firewalld.service;  
systemctl mask firewalld.service;

![8048adeea5c5419a729ddebbd9374e37.png][]

42.通过 yum -y install iptables-services 命令安装 iptables 防火墙

![601420c0531f0061d96cd1347b652208.png][]

43.通过以下命令启动设置防火墙

systemctl enable iptables;  
systemctl start iptables;

![013cda4f131599c71220332ffc17849e.png][]

44.通过 vim /etc/sysconfig/iptables 命令编辑防火墙，添加端口

![8c797ccc42c76f5dbe075c6d800374c1.png][]

45.点击 i 键进入插入模式

![cacc47c90d2289c329fa16507212643d.png][]

46.在相关位置，写入以下内容

\-A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT  
\-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT  
\-A INPUT -m state --state NEW -m tcp -p tcp --dport 443 -j ACCEPT  
\-A INPUT -m state --state NEW -m tcp -p tcp --dport 8080 -j ACCEPT  
\-A INPUT -m state --state NEW -m tcp -p tcp --dport 8090 -j ACCEPT

![caa92df855393e7b3b047670edb62e06.png][]

47.点击 ESC 键退出插入模式

![95eb96a38f5113edd819c1d5099a3692.png][]

48.点击 : 键，输入 wq 敲回车键保存退出，: 为英文状态下的

![259b91cb492cbd7fac3f088d5a2d7131.png][]

49.通过 systemctl restart iptables.service 命令重启防火墙使配置生效

![5d87b3bb4caa6af2582803a355810897.png][]

50.通过 systemctl enable iptables.service 命令设置防火墙开机启动

![7568c54829747695881a2d941f225bda.png][]

51.通过 ifconfig 命令查看 ip

![3f68064cd24892785d9ed072c43174f4.png][]

52.新建 SQLyog 的连接

![ece2438fda7d7e0ef2df224f9d23f2e8.png][]

53.连接成功

![b17dea6eb118b1fb7b0fc58fcf86221b.png][]

[35621a78138802003544e1e21fd9e562.png]: /images/20221120/e77765a97260435ebc3fa2e07ccb8e7c.png
[e6ed46748980b89b3860dfe536bf8326.png]: /images/20221120/2ce6f6378dbb4166a59aa9237480ed7c.png
[55fc7c2bca43dd13dc37533174fc79e2.png]: https://img-blog.csdnimg.cn/img_convert/55fc7c2bca43dd13dc37533174fc79e2.png
[5272a457fa691c394191b7c2846483a3.png]: https://img-blog.csdnimg.cn/img_convert/5272a457fa691c394191b7c2846483a3.png
[b3d8a3ca5a592ef7bb4bec5d3fb0cd0e.png]: https://img-blog.csdnimg.cn/img_convert/b3d8a3ca5a592ef7bb4bec5d3fb0cd0e.png
[290dae73f6ca0f9214da66111e995b30.png]: https://img-blog.csdnimg.cn/img_convert/290dae73f6ca0f9214da66111e995b30.png
[418f11303e8268f4fdf50bb14648f499.png]: https://img-blog.csdnimg.cn/img_convert/418f11303e8268f4fdf50bb14648f499.png
[af59cb70ed49eb70086087633745c9f9.png]: https://img-blog.csdnimg.cn/img_convert/af59cb70ed49eb70086087633745c9f9.png
[66347537e50708474d675d1408c71d62.png]: https://img-blog.csdnimg.cn/img_convert/66347537e50708474d675d1408c71d62.png
[aef25dbc9b77a327a69aad2216bbcccc.png]: https://img-blog.csdnimg.cn/img_convert/aef25dbc9b77a327a69aad2216bbcccc.png
[59f44ad172d594153128f6cd12fa151a.png]: https://img-blog.csdnimg.cn/img_convert/59f44ad172d594153128f6cd12fa151a.png
[1954bd1f7184b6fb4a884a197de0bded.png]: https://img-blog.csdnimg.cn/img_convert/1954bd1f7184b6fb4a884a197de0bded.png
[53164229e7317dd5e3ff48c577c41ecb.png]: https://img-blog.csdnimg.cn/img_convert/53164229e7317dd5e3ff48c577c41ecb.png
[ca3d8aa4bff2d3fe96a9c0230ca94907.png]: https://img-blog.csdnimg.cn/img_convert/ca3d8aa4bff2d3fe96a9c0230ca94907.png
[2f01e7a8337410defb66ad7f2150cba5.png]: https://img-blog.csdnimg.cn/img_convert/2f01e7a8337410defb66ad7f2150cba5.png
[34c00dcba025bf7c5d5b711379891fca.png]: https://img-blog.csdnimg.cn/img_convert/34c00dcba025bf7c5d5b711379891fca.png
[751da962c6826c5c776e1bd6e4e3836f.png]: https://img-blog.csdnimg.cn/img_convert/751da962c6826c5c776e1bd6e4e3836f.png
[aba256cc97e03d0b0b3d4edfdadf59be.png]: https://img-blog.csdnimg.cn/img_convert/aba256cc97e03d0b0b3d4edfdadf59be.png
[5f199303687a9b950aa3794a36d086bb.png]: https://img-blog.csdnimg.cn/img_convert/5f199303687a9b950aa3794a36d086bb.png
[932e136ad23c9295a4a53808204f836c.png]: https://img-blog.csdnimg.cn/img_convert/932e136ad23c9295a4a53808204f836c.png
[0e4f76e76e8a188512694443b0f3890f.png]: https://img-blog.csdnimg.cn/img_convert/0e4f76e76e8a188512694443b0f3890f.png
[a37fd1b575d359498b7664b8e56ebb7d.png]: https://img-blog.csdnimg.cn/img_convert/a37fd1b575d359498b7664b8e56ebb7d.png
[ab110c0fb25b6b31fd096f6b8b979103.png]: https://img-blog.csdnimg.cn/img_convert/ab110c0fb25b6b31fd096f6b8b979103.png
[c19b1adee335e3fa872db9fa832dcc9f.png]: https://img-blog.csdnimg.cn/img_convert/c19b1adee335e3fa872db9fa832dcc9f.png
[b570ea321bf6d7ba83c599d085d46711.png]: https://img-blog.csdnimg.cn/img_convert/b570ea321bf6d7ba83c599d085d46711.png
[c331a192efdbbcaa95a293b94037bac8.png]: https://img-blog.csdnimg.cn/img_convert/c331a192efdbbcaa95a293b94037bac8.png
[c66968b4a516eacb5f16ebbe9762b41d.png]: https://img-blog.csdnimg.cn/img_convert/c66968b4a516eacb5f16ebbe9762b41d.png
[962345b364b7d8dcb2a345c7a3ee4e47.png]: https://img-blog.csdnimg.cn/img_convert/962345b364b7d8dcb2a345c7a3ee4e47.png
[71dd5e37f33ed1b146a4d6157a832bfe.png]: https://img-blog.csdnimg.cn/img_convert/71dd5e37f33ed1b146a4d6157a832bfe.png
[1c518822ef801a6ec2dfa78d319391b3.png]: https://img-blog.csdnimg.cn/img_convert/1c518822ef801a6ec2dfa78d319391b3.png
[2e25cdcfe5e30fedb8591c0ac3807b7c.png]: https://img-blog.csdnimg.cn/img_convert/2e25cdcfe5e30fedb8591c0ac3807b7c.png
[43a232d2127b57291ada38a4458920d6.png]: https://img-blog.csdnimg.cn/img_convert/43a232d2127b57291ada38a4458920d6.png
[8cf6e4ff78aac024e8edab8c16e236d8.png]: https://img-blog.csdnimg.cn/img_convert/8cf6e4ff78aac024e8edab8c16e236d8.png
[6d9c633dc44cb12a316d8a2bc8d12bd9.png]: https://img-blog.csdnimg.cn/img_convert/6d9c633dc44cb12a316d8a2bc8d12bd9.png
[6f3d0a1c5b1d44696c32355e6a57fcb0.png]: https://img-blog.csdnimg.cn/img_convert/6f3d0a1c5b1d44696c32355e6a57fcb0.png
[e60f90c77039b9af1c529864e9428119.png]: https://img-blog.csdnimg.cn/img_convert/e60f90c77039b9af1c529864e9428119.png
[eab075130f0daba9147682532ddcc9c3.png]: https://img-blog.csdnimg.cn/img_convert/eab075130f0daba9147682532ddcc9c3.png
[e520fddb34fdea161fcdc9c7a471aca4.png]: https://img-blog.csdnimg.cn/img_convert/e520fddb34fdea161fcdc9c7a471aca4.png
[1c2b1bff95f1c4b156d4db09fe4c28d3.png]: https://img-blog.csdnimg.cn/img_convert/1c2b1bff95f1c4b156d4db09fe4c28d3.png
[701f44a3c240c430e5dd7b5982e8b437.png]: https://img-blog.csdnimg.cn/img_convert/701f44a3c240c430e5dd7b5982e8b437.png
[8048adeea5c5419a729ddebbd9374e37.png]: https://img-blog.csdnimg.cn/img_convert/8048adeea5c5419a729ddebbd9374e37.png
[601420c0531f0061d96cd1347b652208.png]: https://img-blog.csdnimg.cn/img_convert/601420c0531f0061d96cd1347b652208.png
[013cda4f131599c71220332ffc17849e.png]: https://img-blog.csdnimg.cn/img_convert/013cda4f131599c71220332ffc17849e.png
[8c797ccc42c76f5dbe075c6d800374c1.png]: https://img-blog.csdnimg.cn/img_convert/8c797ccc42c76f5dbe075c6d800374c1.png
[cacc47c90d2289c329fa16507212643d.png]: https://img-blog.csdnimg.cn/img_convert/cacc47c90d2289c329fa16507212643d.png
[caa92df855393e7b3b047670edb62e06.png]: https://img-blog.csdnimg.cn/img_convert/caa92df855393e7b3b047670edb62e06.png
[95eb96a38f5113edd819c1d5099a3692.png]: https://img-blog.csdnimg.cn/img_convert/95eb96a38f5113edd819c1d5099a3692.png
[259b91cb492cbd7fac3f088d5a2d7131.png]: https://img-blog.csdnimg.cn/img_convert/259b91cb492cbd7fac3f088d5a2d7131.png
[5d87b3bb4caa6af2582803a355810897.png]: https://img-blog.csdnimg.cn/img_convert/5d87b3bb4caa6af2582803a355810897.png
[7568c54829747695881a2d941f225bda.png]: https://img-blog.csdnimg.cn/img_convert/7568c54829747695881a2d941f225bda.png
[3f68064cd24892785d9ed072c43174f4.png]: https://img-blog.csdnimg.cn/img_convert/3f68064cd24892785d9ed072c43174f4.png
[ece2438fda7d7e0ef2df224f9d23f2e8.png]: https://img-blog.csdnimg.cn/img_convert/ece2438fda7d7e0ef2df224f9d23f2e8.png
[b17dea6eb118b1fb7b0fc58fcf86221b.png]: https://img-blog.csdnimg.cn/img_convert/b17dea6eb118b1fb7b0fc58fcf86221b.png