CentOS7安装MySQL8.0图文教程

心已赠人 2023-09-25 12:07 30阅读 0赞

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

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

![5d69c2233a8b5f83e70284109f9030ce.png][]

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

![6b054b19b57d851b6110b4a8b5bb003a.png][]

3.选择 RPM Bundle 点击 Download

![60965b71c75b600047dc446937ea3dfa.png][]

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

![2f80b62f4736da89a9baf0128b251108.png][]

5.下载好了

![7312632352cb66f517b50e690c4dcced.png][]

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

![e4c5b8d08ee134eeed66017b579c0d61.png][]

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

![94d8c749b605aa059fbae41f5d6c3aca.png][]

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

![2fe0f99764e4203a837ecad25d6eaf62.png][]

9.连接成功

![b925822dfa2822e33c82f7c4d3225f9c.png][]

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

![3b5453565c19c769cb80fb175322af38.png][]

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

![a14ca329c022ebd56c2f609c446fd32b.png][]

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

![f6dcd4a58a85da6d4ed98a2a5cb23071.png][]

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

![11f9813d41c843764c109e9d37413717.png][]

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

![b3669d47d2e9e42aacee73e4a99253ac.png][]

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

![d58dd81375453ac869245e66277bcc75.png][]

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

![6f4464ff3d8c460dfa3cb6f724c70b41.png][]

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

![8ffd3a6e9580fa14e10eea9b3b8f2c56.png][]

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

![ec5a09500352a75c502633623f01967b.png][]

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

![7f3e3b1e748cc1dd1b905ba8eef19c1b.png][]

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

![1bffa9b9a8ce93f3c9dddf77beb95bc7.png][]

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

![0789d17441602f4d3383dcf972d9f55a.png][]

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

![749bc77efa1e476a7f198cd39ec6ae2e.png][]

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

![9843d0f10d0c6734a6b32e05c1b8bcce.png][]

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

![d19a206ed3c88488370733ca95ca492b.png][]

25.通过 clear 命令清一下屏

![804e56f138b4e50f7e071557eba6f1f8.png][]

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

![261bd059c744a58fc021240201e182dc.png][]

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

![b8c9f194232161fa717607efe6522aed.png][]

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

![023fcdf45640439c252571203c31d376.png][]

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

![935b696adf7b3940b2c92d749fcacd4c.png][]

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

![380a47a62ef1e64b82f8dcdad335d9d7.png][]

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

mysqld --initialize;

chown mysql:mysql /var/lib/mysql -R;

systemctl start mysqld.service;

systemctl enable mysqld;

![c0ddb01680ff9d2a65996d8d5910d7bd.png][]

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

![8c87944b91ab7d97d0ef13754c37e181.png][]

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

![61d01b989b68d0e0246e496f24a5a9ce.png][]

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

![24175dfce47360986425983a0f7f72df.png][]

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

![49df422e966aa10150989d5678f0314e.png][]

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

![92bd96061848e564c9354f5a5efb60ca.png][]

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

create user 'root'@'%' identified with mysql\_native\_password by 'root';

grant all privileges on \*.\* to 'root'@'%' with grant option;

flush privileges;

![42a7df8586db0b9715fa7d6409ae47c3.png][]

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

![306f6d5399d67c89a822b2620193d0e7.png][]

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

![cf0cb5d3b01343ad2e247d63e1ed9e95.png][]

40.通过 exit; 命令退出 MySQL

![9ec44da01f83268efd15d3eb237383d1.png][]

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

systemctl stop firewalld.service;

systemctl disable firewalld.service;

systemctl mask firewalld.service;

![4e3ebe94d53d326aaf66db9863b14f76.png][]

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

![87eb05993a5277709a0f404e58e3411a.png][]

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

systemctl enable iptables;

systemctl start iptables;

![be182d541a2aeac37a1269ab23811f0d.png][]

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

![32dab9a456f46cdc99d9cdcb1d0a3f2b.png][]

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

![686a86aaf55d8c4bea24d08eac86582b.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

![090a6aa6f315d1004333ac0f63c7e6f1.png][]

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

![816d54af070e6f1566b6f6fc8f4f67ed.png][]

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

![38919cb1aca041263b3a7e04c67f4c0a.png][]

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

![af15ad7070e82dca17ab0a2fb10c3644.png][]

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

![e921440cdc2bda55b6d6b6176e4c1f95.png][]

51.通过 ifconfig 命令查看 ip

![39c214155771dd684f8745c62666fea6.png][]

52.新建 SQLyog 的连接

![e8acf723117ed161751ad015c97a4dce.png][]

53.连接成功

![d9da8e319ca053c4e087917f690b4766.png][]

[5d69c2233a8b5f83e70284109f9030ce.png]: https://img-blog.csdnimg.cn/img_convert/5d69c2233a8b5f83e70284109f9030ce.png
[6b054b19b57d851b6110b4a8b5bb003a.png]: https://img-blog.csdnimg.cn/img_convert/6b054b19b57d851b6110b4a8b5bb003a.png
[60965b71c75b600047dc446937ea3dfa.png]: https://img-blog.csdnimg.cn/img_convert/60965b71c75b600047dc446937ea3dfa.png
[2f80b62f4736da89a9baf0128b251108.png]: https://img-blog.csdnimg.cn/img_convert/2f80b62f4736da89a9baf0128b251108.png
[7312632352cb66f517b50e690c4dcced.png]: https://img-blog.csdnimg.cn/img_convert/7312632352cb66f517b50e690c4dcced.png
[e4c5b8d08ee134eeed66017b579c0d61.png]: https://img-blog.csdnimg.cn/img_convert/e4c5b8d08ee134eeed66017b579c0d61.png
[94d8c749b605aa059fbae41f5d6c3aca.png]: https://img-blog.csdnimg.cn/img_convert/94d8c749b605aa059fbae41f5d6c3aca.png
[2fe0f99764e4203a837ecad25d6eaf62.png]: https://img-blog.csdnimg.cn/img_convert/2fe0f99764e4203a837ecad25d6eaf62.png
[b925822dfa2822e33c82f7c4d3225f9c.png]: https://img-blog.csdnimg.cn/img_convert/b925822dfa2822e33c82f7c4d3225f9c.png
[3b5453565c19c769cb80fb175322af38.png]: https://img-blog.csdnimg.cn/img_convert/3b5453565c19c769cb80fb175322af38.png
[a14ca329c022ebd56c2f609c446fd32b.png]: https://img-blog.csdnimg.cn/img_convert/a14ca329c022ebd56c2f609c446fd32b.png
[f6dcd4a58a85da6d4ed98a2a5cb23071.png]: https://img-blog.csdnimg.cn/img_convert/f6dcd4a58a85da6d4ed98a2a5cb23071.png
[11f9813d41c843764c109e9d37413717.png]: https://img-blog.csdnimg.cn/img_convert/11f9813d41c843764c109e9d37413717.png
[b3669d47d2e9e42aacee73e4a99253ac.png]: https://img-blog.csdnimg.cn/img_convert/b3669d47d2e9e42aacee73e4a99253ac.png
[d58dd81375453ac869245e66277bcc75.png]: https://img-blog.csdnimg.cn/img_convert/d58dd81375453ac869245e66277bcc75.png
[6f4464ff3d8c460dfa3cb6f724c70b41.png]: https://img-blog.csdnimg.cn/img_convert/6f4464ff3d8c460dfa3cb6f724c70b41.png
[8ffd3a6e9580fa14e10eea9b3b8f2c56.png]: https://img-blog.csdnimg.cn/img_convert/8ffd3a6e9580fa14e10eea9b3b8f2c56.png
[ec5a09500352a75c502633623f01967b.png]: https://img-blog.csdnimg.cn/img_convert/ec5a09500352a75c502633623f01967b.png
[7f3e3b1e748cc1dd1b905ba8eef19c1b.png]: https://img-blog.csdnimg.cn/img_convert/7f3e3b1e748cc1dd1b905ba8eef19c1b.png
[1bffa9b9a8ce93f3c9dddf77beb95bc7.png]: https://img-blog.csdnimg.cn/img_convert/1bffa9b9a8ce93f3c9dddf77beb95bc7.png
[0789d17441602f4d3383dcf972d9f55a.png]: https://img-blog.csdnimg.cn/img_convert/0789d17441602f4d3383dcf972d9f55a.png
[749bc77efa1e476a7f198cd39ec6ae2e.png]: https://img-blog.csdnimg.cn/img_convert/749bc77efa1e476a7f198cd39ec6ae2e.png
[9843d0f10d0c6734a6b32e05c1b8bcce.png]: https://img-blog.csdnimg.cn/img_convert/9843d0f10d0c6734a6b32e05c1b8bcce.png
[d19a206ed3c88488370733ca95ca492b.png]: https://img-blog.csdnimg.cn/img_convert/d19a206ed3c88488370733ca95ca492b.png
[804e56f138b4e50f7e071557eba6f1f8.png]: https://img-blog.csdnimg.cn/img_convert/804e56f138b4e50f7e071557eba6f1f8.png
[261bd059c744a58fc021240201e182dc.png]: https://img-blog.csdnimg.cn/img_convert/261bd059c744a58fc021240201e182dc.png
[b8c9f194232161fa717607efe6522aed.png]: https://img-blog.csdnimg.cn/img_convert/b8c9f194232161fa717607efe6522aed.png
[023fcdf45640439c252571203c31d376.png]: https://img-blog.csdnimg.cn/img_convert/023fcdf45640439c252571203c31d376.png
[935b696adf7b3940b2c92d749fcacd4c.png]: https://img-blog.csdnimg.cn/img_convert/935b696adf7b3940b2c92d749fcacd4c.png
[380a47a62ef1e64b82f8dcdad335d9d7.png]: https://img-blog.csdnimg.cn/img_convert/380a47a62ef1e64b82f8dcdad335d9d7.png
[c0ddb01680ff9d2a65996d8d5910d7bd.png]: https://img-blog.csdnimg.cn/img_convert/c0ddb01680ff9d2a65996d8d5910d7bd.png
[8c87944b91ab7d97d0ef13754c37e181.png]: https://img-blog.csdnimg.cn/img_convert/8c87944b91ab7d97d0ef13754c37e181.png
[61d01b989b68d0e0246e496f24a5a9ce.png]: https://img-blog.csdnimg.cn/img_convert/61d01b989b68d0e0246e496f24a5a9ce.png
[24175dfce47360986425983a0f7f72df.png]: https://img-blog.csdnimg.cn/img_convert/24175dfce47360986425983a0f7f72df.png
[49df422e966aa10150989d5678f0314e.png]: https://img-blog.csdnimg.cn/img_convert/49df422e966aa10150989d5678f0314e.png
[92bd96061848e564c9354f5a5efb60ca.png]: https://img-blog.csdnimg.cn/img_convert/92bd96061848e564c9354f5a5efb60ca.png
[42a7df8586db0b9715fa7d6409ae47c3.png]: https://img-blog.csdnimg.cn/img_convert/42a7df8586db0b9715fa7d6409ae47c3.png
[306f6d5399d67c89a822b2620193d0e7.png]: https://img-blog.csdnimg.cn/img_convert/306f6d5399d67c89a822b2620193d0e7.png
[cf0cb5d3b01343ad2e247d63e1ed9e95.png]: https://img-blog.csdnimg.cn/img_convert/cf0cb5d3b01343ad2e247d63e1ed9e95.png
[9ec44da01f83268efd15d3eb237383d1.png]: https://img-blog.csdnimg.cn/img_convert/9ec44da01f83268efd15d3eb237383d1.png
[4e3ebe94d53d326aaf66db9863b14f76.png]: https://img-blog.csdnimg.cn/img_convert/4e3ebe94d53d326aaf66db9863b14f76.png
[87eb05993a5277709a0f404e58e3411a.png]: https://img-blog.csdnimg.cn/img_convert/87eb05993a5277709a0f404e58e3411a.png
[be182d541a2aeac37a1269ab23811f0d.png]: https://img-blog.csdnimg.cn/img_convert/be182d541a2aeac37a1269ab23811f0d.png
[32dab9a456f46cdc99d9cdcb1d0a3f2b.png]: https://img-blog.csdnimg.cn/img_convert/32dab9a456f46cdc99d9cdcb1d0a3f2b.png
[686a86aaf55d8c4bea24d08eac86582b.png]: https://img-blog.csdnimg.cn/img_convert/686a86aaf55d8c4bea24d08eac86582b.png
[090a6aa6f315d1004333ac0f63c7e6f1.png]: https://img-blog.csdnimg.cn/img_convert/090a6aa6f315d1004333ac0f63c7e6f1.png
[816d54af070e6f1566b6f6fc8f4f67ed.png]: https://img-blog.csdnimg.cn/img_convert/816d54af070e6f1566b6f6fc8f4f67ed.png
[38919cb1aca041263b3a7e04c67f4c0a.png]: https://img-blog.csdnimg.cn/img_convert/38919cb1aca041263b3a7e04c67f4c0a.png
[af15ad7070e82dca17ab0a2fb10c3644.png]: https://img-blog.csdnimg.cn/img_convert/af15ad7070e82dca17ab0a2fb10c3644.png
[e921440cdc2bda55b6d6b6176e4c1f95.png]: https://img-blog.csdnimg.cn/img_convert/e921440cdc2bda55b6d6b6176e4c1f95.png
[39c214155771dd684f8745c62666fea6.png]: https://img-blog.csdnimg.cn/img_convert/39c214155771dd684f8745c62666fea6.png
[e8acf723117ed161751ad015c97a4dce.png]: https://img-blog.csdnimg.cn/img_convert/e8acf723117ed161751ad015c97a4dce.png
[d9da8e319ca053c4e087917f690b4766.png]: https://img-blog.csdnimg.cn/img_convert/d9da8e319ca053c4e087917f690b4766.png