1-linux下mysql8.0.33安装
在互联网企业的日常工作/运维中，我们会经常用到mysql数据库，而linux下mysql的安装方式有三种：
1.mysql rpm安装
2.mysql二进制安装
3.mysql源码安装
今天就为大家讲讲linux下mysql8.0.33版本rpm方式的安装。
1.前提
1.1.系统版本
CentOS7.9.2009
命令：
cat /etc/redhat-release
[root@cent79-2 ~]# cat /etc/redhat-release
CentOS Linux release 7.9.2009 (Core)
[root@cent79-2 ~]#
1.2.系统基础配置
参考：
Linux常规基础配置_小黑要上天的博客-CSDN博客
1.3.预安装数据库版本
mysql8.0.33
1.4.环境初始化
# 清除系统原有的MySQL环境rm -rf /var/run/yum.pid && yum remove mysql* -y && yum remove mariadb* -y find / -name mysql -exec rm -rf {} \;
# 删除原有的MySQL包for i in `rpm -qa |grep mysql`dorpm -e --nodeps $idone 2.mysql8.0.33介质下载
2.1.官网地址
官网地址：
https://dev.mysql.com/downloads/mysql/
2.2.安装软件包
命令：
yum install wget tar lrzsz
[root@cent79-2 ~]# yum install wget tar lrzsz
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
CentOS7 | 3.6 kB 00:00:00
Package 2:tar-1.26-35.el7.x86_64 already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package lrzsz.x86_64 0:0.12.20-36.el7 will be installed
---> Package wget.x86_64 0:1.14-18.el7_6.1 will be installed
--> Finished Dependency ResolutionDependencies Resolved==============================================================================================Package Arch Version Repository Size
==============================================================================================
Installing:lrzsz x86_64 0.12.20-36.el7 CentOS7 78 kwget x86_64 1.14-18.el7_6.1 CentOS7 547 kTransaction Summary
==============================================================================================
Install 2 PackagesTotal download size: 625 k
Installed size: 2.1 M
Is this ok [y/d/N]: y
Downloading packages:
----------------------------------------------------------------------------------------------
Total 380 kB/s | 625 kB 00:00:01
Running transaction check
Running transaction test
Transaction test succeeded
Running transactionInstalling : wget-1.14-18.el7_6.1.x86_64 1/2 Installing : lrzsz-0.12.20-36.el7.x86_64 2/2 Verifying : lrzsz-0.12.20-36.el7.x86_64 1/2 Verifying : wget-1.14-18.el7_6.1.x86_64 2/2 Installed:lrzsz.x86_64 0:0.12.20-36.el7 wget.x86_64 0:1.14-18.el7_6.1 Complete!
[root@cent79-2 ~]#
命令：
yum install ncurses-devel libaio-devel gcc gcc-c++ numactl libaio glibc cmake autoconf libstdc++.x86_64 libstdc++.i686 bzip2 bison net-tools -y
[root@cent79-2 ~]# yum install ncurses-devel libaio-devel gcc gcc-c++ numactl libaio glibc cmake autoconf libstdc++.x86_64 libstdc++.i686 bzip2 bison net-tools -y
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Package libaio-0.3.109-13.el7.x86_64 already installed and latest version
Package glibc-2.17-317.el7.x86_64 already installed and latest version
Package libstdc++-4.8.5-44.el7.x86_64 already installed and latest version
No package libstdc++.i686 available.
Resolving Dependencies
--> Running transaction check
---> Package autoconf.noarch 0:2.69-11.el7 will be installed
--> Processing Dependency: perl >= 5.006 for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: m4 >= 1.4.14 for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: perl(warnings) for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: perl(vars) for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: perl(strict) for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: perl(constant) for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: perl(Text::ParseWords) for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: perl(POSIX) for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: perl(IO::File) for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: perl(Getopt::Long) for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: perl(File::stat) for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: perl(File::Spec) for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: perl(File::Path) for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: perl(File::Find) for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: perl(File::Copy) for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: perl(File::Compare) for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: perl(File::Basename) for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: perl(Exporter) for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: perl(Errno) for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: perl(DynaLoader) for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: perl(Data::Dumper) for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: perl(Cwd) for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: perl(Class::Struct) for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: perl(Carp) for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: /usr/bin/perl for package: autoconf-2.69-11.el7.noarch
---> Package bison.x86_64 0:3.0.4-2.el7 will be installed
---> Package bzip2.x86_64 0:1.0.6-13.el7 will be installed
---> Package cmake.x86_64 0:2.8.12.2-2.el7 will be installed
--> Processing Dependency: libarchive.so.13()(64bit) for package: cmake-2.8.12.2-2.el7.x86_64
---> Package gcc.x86_64 0:4.8.5-44.el7 will be installed
--> Processing Dependency: cpp = 4.8.5-44.el7 for package: gcc-4.8.5-44.el7.x86_64
--> Processing Dependency: glibc-devel >= 2.2.90-12 for package: gcc-4.8.5-44.el7.x86_64
--> Processing Dependency: libmpfr.so.4()(64bit) for package: gcc-4.8.5-44.el7.x86_64
--> Processing Dependency: libmpc.so.3()(64bit) for package: gcc-4.8.5-44.el7.x86_64
---> Package gcc-c++.x86_64 0:4.8.5-44.el7 will be installed
--> Processing Dependency: libstdc++-devel = 4.8.5-44.el7 for package: gcc-c++-4.8.5-44.el7.x86_64
---> Package libaio-devel.x86_64 0:0.3.109-13.el7 will be installed
---> Package ncurses-devel.x86_64 0:5.9-14.20130511.el7_4 will be installed
---> Package numactl.x86_64 0:2.0.12-5.el7 will be installed
--> Running transaction check
---> Package cpp.x86_64 0:4.8.5-44.el7 will be installed
---> Package glibc-devel.x86_64 0:2.17-317.el7 will be installed
--> Processing Dependency: glibc-headers = 2.17-317.el7 for package: glibc-devel-2.17-317.el7.x86_64
--> Processing Dependency: glibc-headers for package: glibc-devel-2.17-317.el7.x86_64
---> Package libarchive.x86_64 0:3.1.2-14.el7_7 will be installed
---> Package libmpc.x86_64 0:1.0.1-3.el7 will be installed
---> Package libstdc++-devel.x86_64 0:4.8.5-44.el7 will be installed
---> Package m4.x86_64 0:1.4.16-10.el7 will be installed
---> Package mpfr.x86_64 0:3.1.1-4.el7 will be installed
---> Package perl.x86_64 4:5.16.3-297.el7 will be installed
--> Processing Dependency: perl-libs = 4:5.16.3-297.el7 for package: 4:perl-5.16.3-297.el7.x86_64
--> Processing Dependency: perl(Socket) >= 1.3 for package: 4:perl-5.16.3-297.el7.x86_64
--> Processing Dependency: perl(Scalar::Util) >= 1.10 for package: 4:perl-5.16.3-297.el7.x86_64
--> Processing Dependency: perl-macros for package: 4:perl-5.16.3-297.el7.x86_64
--> Processing Dependency: perl-libs for package: 4:perl-5.16.3-297.el7.x86_64
--> Processing Dependency: perl(threads::shared) for package: 4:perl-5.16.3-297.el7.x86_64
--> Processing Dependency: perl(threads) for package: 4:perl-5.16.3-297.el7.x86_64
--> Processing Dependency: perl(Time::Local) for package: 4:perl-5.16.3-297.el7.x86_64
--> Processing Dependency: perl(Time::HiRes) for package: 4:perl-5.16.3-297.el7.x86_64
--> Processing Dependency: perl(Storable) for package: 4:perl-5.16.3-297.el7.x86_64
--> Processing Dependency: perl(Socket) for package: 4:perl-5.16.3-297.el7.x86_64
--> Processing Dependency: perl(Scalar::Util) for package: 4:perl-5.16.3-297.el7.x86_64
--> Processing Dependency: perl(Pod::Simple::XHTML) for package: 4:perl-5.16.3-297.el7.x86_64
--> Processing Dependency: perl(Pod::Simple::Search) for package: 4:perl-5.16.3-297.el7.x86_64
--> Processing Dependency: perl(Filter::Util::Call) for package: 4:perl-5.16.3-297.el7.x86_64
--> Processing Dependency: perl(File::Temp) for package: 4:perl-5.16.3-297.el7.x86_64
--> Processing Dependency: libperl.so()(64bit) for package: 4:perl-5.16.3-297.el7.x86_64
---> Package perl-Carp.noarch 0:1.26-244.el7 will be installed
---> Package perl-Data-Dumper.x86_64 0:2.145-3.el7 will be installed
---> Package perl-Exporter.noarch 0:5.68-3.el7 will be installed
---> Package perl-File-Path.noarch 0:2.09-2.el7 will be installed
---> Package perl-Getopt-Long.noarch 0:2.40-3.el7 will be installed
--> Processing Dependency: perl(Pod::Usage) >= 1.14 for package: perl-Getopt-Long-2.40-3.el7.noarch
---> Package perl-PathTools.x86_64 0:3.40-5.el7 will be installed
---> Package perl-Text-ParseWords.noarch 0:3.29-4.el7 will be installed
---> Package perl-constant.noarch 0:1.27-2.el7 will be installed
--> Running transaction check
---> Package glibc-headers.x86_64 0:2.17-317.el7 will be installed
--> Processing Dependency: kernel-headers >= 2.2.1 for package: glibc-headers-2.17-317.el7.x86_64
--> Processing Dependency: kernel-headers for package: glibc-headers-2.17-317.el7.x86_64
---> Package perl-File-Temp.noarch 0:0.23.01-3.el7 will be installed
---> Package perl-Filter.x86_64 0:1.49-3.el7 will be installed
---> Package perl-Pod-Simple.noarch 1:3.28-4.el7 will be installed
--> Processing Dependency: perl(Pod::Escapes) >= 1.04 for package: 1:perl-Pod-Simple-3.28-4.el7.noarch
--> Processing Dependency: perl(Encode) for package: 1:perl-Pod-Simple-3.28-4.el7.noarch
---> Package perl-Pod-Usage.noarch 0:1.63-3.el7 will be installed
--> Processing Dependency: perl(Pod::Text) >= 3.15 for package: perl-Pod-Usage-1.63-3.el7.noarch
--> Processing Dependency: perl-Pod-Perldoc for package: perl-Pod-Usage-1.63-3.el7.noarch
---> Package perl-Scalar-List-Utils.x86_64 0:1.27-248.el7 will be installed
---> Package perl-Socket.x86_64 0:2.010-5.el7 will be installed
---> Package perl-Storable.x86_64 0:2.45-3.el7 will be installed
---> Package perl-Time-HiRes.x86_64 4:1.9725-3.el7 will be installed
---> Package perl-Time-Local.noarch 0:1.2300-2.el7 will be installed
---> Package perl-libs.x86_64 4:5.16.3-297.el7 will be installed
---> Package perl-macros.x86_64 4:5.16.3-297.el7 will be installed
---> Package perl-threads.x86_64 0:1.87-4.el7 will be installed
---> Package perl-threads-shared.x86_64 0:1.43-6.el7 will be installed
--> Running transaction check
---> Package kernel-headers.x86_64 0:3.10.0-1160.el7 will be installed
---> Package perl-Encode.x86_64 0:2.51-7.el7 will be installed
---> Package perl-Pod-Escapes.noarch 1:1.04-297.el7 will be installed
---> Package perl-Pod-Perldoc.noarch 0:3.20-4.el7 will be installed
--> Processing Dependency: perl(parent) for package: perl-Pod-Perldoc-3.20-4.el7.noarch
--> Processing Dependency: perl(HTTP::Tiny) for package: perl-Pod-Perldoc-3.20-4.el7.noarch
---> Package perl-podlators.noarch 0:2.5.1-3.el7 will be installed
--> Running transaction check
---> Package perl-HTTP-Tiny.noarch 0:0.033-3.el7 will be installed
---> Package perl-parent.noarch 1:0.225-244.el7 will be installed
--> Finished Dependency ResolutionDependencies Resolved==============================================================================================Package Arch Version Repository Size
==============================================================================================
Installing:autoconf noarch 2.69-11.el7 CentOS7 701 kbison x86_64 3.0.4-2.el7 CentOS7 674 kbzip2 x86_64 1.0.6-13.el7 CentOS7 52 kcmake x86_64 2.8.12.2-2.el7 CentOS7 7.1 Mgcc x86_64 4.8.5-44.el7 CentOS7 16 Mgcc-c++ x86_64 4.8.5-44.el7 CentOS7 7.2 Mlibaio-devel x86_64 0.3.109-13.el7 CentOS7 13 kncurses-devel x86_64 5.9-14.20130511.el7_4 CentOS7 712 knumactl x86_64 2.0.12-5.el7 CentOS7 66 k
Installing for dependencies:cpp x86_64 4.8.5-44.el7 CentOS7 5.9 Mglibc-devel x86_64 2.17-317.el7 CentOS7 1.1 Mglibc-headers x86_64 2.17-317.el7 CentOS7 690 kkernel-headers x86_64 3.10.0-1160.el7 CentOS7 9.0 Mlibarchive x86_64 3.1.2-14.el7_7 CentOS7 319 klibmpc x86_64 1.0.1-3.el7 CentOS7 51 klibstdc++-devel x86_64 4.8.5-44.el7 CentOS7 1.5 Mm4 x86_64 1.4.16-10.el7 CentOS7 256 kmpfr x86_64 3.1.1-4.el7 CentOS7 203 kperl x86_64 4:5.16.3-297.el7 CentOS7 8.0 Mperl-Carp noarch 1.26-244.el7 CentOS7 19 kperl-Data-Dumper x86_64 2.145-3.el7 CentOS7 47 kperl-Encode x86_64 2.51-7.el7 CentOS7 1.5 Mperl-Exporter noarch 5.68-3.el7 CentOS7 28 kperl-File-Path noarch 2.09-2.el7 CentOS7 26 kperl-File-Temp noarch 0.23.01-3.el7 CentOS7 56 kperl-Filter x86_64 1.49-3.el7 CentOS7 76 kperl-Getopt-Long noarch 2.40-3.el7 CentOS7 56 kperl-HTTP-Tiny noarch 0.033-3.el7 CentOS7 38 kperl-PathTools x86_64 3.40-5.el7 CentOS7 82 kperl-Pod-Escapes noarch 1:1.04-297.el7 CentOS7 52 kperl-Pod-Perldoc noarch 3.20-4.el7 CentOS7 87 kperl-Pod-Simple noarch 1:3.28-4.el7 CentOS7 216 kperl-Pod-Usage noarch 1.63-3.el7 CentOS7 27 kperl-Scalar-List-Utils x86_64 1.27-248.el7 CentOS7 36 kperl-Socket x86_64 2.010-5.el7 CentOS7 49 kperl-Storable x86_64 2.45-3.el7 CentOS7 77 kperl-Text-ParseWords noarch 3.29-4.el7 CentOS7 14 kperl-Time-HiRes x86_64 4:1.9725-3.el7 CentOS7 45 kperl-Time-Local noarch 1.2300-2.el7 CentOS7 24 kperl-constant noarch 1.27-2.el7 CentOS7 19 kperl-libs x86_64 4:5.16.3-297.el7 CentOS7 689 kperl-macros x86_64 4:5.16.3-297.el7 CentOS7 44 kperl-parent noarch 1:0.225-244.el7 CentOS7 12 kperl-podlators noarch 2.5.1-3.el7 CentOS7 112 kperl-threads x86_64 1.87-4.el7 CentOS7 49 kperl-threads-shared x86_64 1.43-6.el7 CentOS7 39 kTransaction Summary
==============================================================================================
Install 9 Packages (+37 Dependent packages)Total download size: 63 M
Installed size: 155 M
Downloading packages:
----------------------------------------------------------------------------------------------
Total 21 MB/s | 63 MB 00:00:03
Running transaction check
Running transaction test
Transaction test succeeded
Running transactionInstalling : mpfr-3.1.1-4.el7.x86_64 1/46 Installing : libmpc-1.0.1-3.el7.x86_64 2/46 Installing : m4-1.4.16-10.el7.x86_64 3/46 Installing : cpp-4.8.5-44.el7.x86_64 4/46 Installing : 1:perl-parent-0.225-244.el7.noarch 5/46 Installing : perl-HTTP-Tiny-0.033-3.el7.noarch 6/46 Installing : perl-podlators-2.5.1-3.el7.noarch 7/46 Installing : perl-Pod-Perldoc-3.20-4.el7.noarch 8/46 Installing : 1:perl-Pod-Escapes-1.04-297.el7.noarch 9/46 Installing : perl-Encode-2.51-7.el7.x86_64 10/46 Installing : perl-Text-ParseWords-3.29-4.el7.noarch 11/46 Installing : perl-Pod-Usage-1.63-3.el7.noarch 12/46 Installing : 4:perl-libs-5.16.3-297.el7.x86_64 13/46 Installing : 4:perl-Time-HiRes-1.9725-3.el7.x86_64 14/46 Installing : perl-Exporter-5.68-3.el7.noarch 15/46 Installing : perl-constant-1.27-2.el7.noarch 16/46 Installing : perl-threads-1.87-4.el7.x86_64 17/46 Installing : perl-Socket-2.010-5.el7.x86_64 18/46 Installing : perl-Time-Local-1.2300-2.el7.noarch 19/46 Installing : perl-Carp-1.26-244.el7.noarch 20/46 Installing : perl-Storable-2.45-3.el7.x86_64 21/46 Installing : perl-threads-shared-1.43-6.el7.x86_64 22/46 Installing : perl-PathTools-3.40-5.el7.x86_64 23/46 Installing : perl-Scalar-List-Utils-1.27-248.el7.x86_64 24/46 Installing : 1:perl-Pod-Simple-3.28-4.el7.noarch 25/46 Installing : perl-File-Temp-0.23.01-3.el7.noarch 26/46 Installing : perl-File-Path-2.09-2.el7.noarch 27/46 Installing : perl-Filter-1.49-3.el7.x86_64 28/46 Installing : 4:perl-macros-5.16.3-297.el7.x86_64 29/46 Installing : perl-Getopt-Long-2.40-3.el7.noarch 30/46 Installing : 4:perl-5.16.3-297.el7.x86_64 31/46 Installing : perl-Data-Dumper-2.145-3.el7.x86_64 32/46 Installing : libarchive-3.1.2-14.el7_7.x86_64 33/46 Installing : libstdc++-devel-4.8.5-44.el7.x86_64 34/46 Installing : kernel-headers-3.10.0-1160.el7.x86_64 35/46 Installing : glibc-headers-2.17-317.el7.x86_64 36/46 Installing : glibc-devel-2.17-317.el7.x86_64 37/46 Installing : gcc-4.8.5-44.el7.x86_64 38/46 Installing : gcc-c++-4.8.5-44.el7.x86_64 39/46 Installing : cmake-2.8.12.2-2.el7.x86_64 40/46 Installing : autoconf-2.69-11.el7.noarch 41/46 Installing : bison-3.0.4-2.el7.x86_64 42/46 Installing : numactl-2.0.12-5.el7.x86_64 43/46 Installing : libaio-devel-0.3.109-13.el7.x86_64 44/46 Installing : ncurses-devel-5.9-14.20130511.el7_4.x86_64 45/46 Installing : bzip2-1.0.6-13.el7.x86_64 46/46 Verifying : perl-HTTP-Tiny-0.033-3.el7.noarch 1/46 Verifying : gcc-c++-4.8.5-44.el7.x86_64 2/46 Verifying : kernel-headers-3.10.0-1160.el7.x86_64 3/46 Verifying : perl-threads-shared-1.43-6.el7.x86_64 4/46 Verifying : 4:perl-Time-HiRes-1.9725-3.el7.x86_64 5/46 Verifying : 4:perl-libs-5.16.3-297.el7.x86_64 6/46 Verifying : mpfr-3.1.1-4.el7.x86_64 7/46 Verifying : perl-Exporter-5.68-3.el7.noarch 8/46 Verifying : perl-constant-1.27-2.el7.noarch 9/46 Verifying : perl-PathTools-3.40-5.el7.x86_64 10/46 Verifying : perl-threads-1.87-4.el7.x86_64 11/46 Verifying : m4-1.4.16-10.el7.x86_64 12/46 Verifying : perl-Socket-2.010-5.el7.x86_64 13/46 Verifying : 1:perl-parent-0.225-244.el7.noarch 14/46 Verifying : bzip2-1.0.6-13.el7.x86_64 15/46 Verifying : 1:perl-Pod-Escapes-1.04-297.el7.noarch 16/46 Verifying : ncurses-devel-5.9-14.20130511.el7_4.x86_64 17/46 Verifying : cpp-4.8.5-44.el7.x86_64 18/46 Verifying : 1:perl-Pod-Simple-3.28-4.el7.noarch 19/46 Verifying : perl-Time-Local-1.2300-2.el7.noarch 20/46 Verifying : libstdc++-devel-4.8.5-44.el7.x86_64 21/46 Verifying : perl-Carp-1.26-244.el7.noarch 22/46 Verifying : libarchive-3.1.2-14.el7_7.x86_64 23/46 Verifying : perl-Data-Dumper-2.145-3.el7.x86_64 24/46 Verifying : glibc-headers-2.17-317.el7.x86_64 25/46 Verifying : perl-Storable-2.45-3.el7.x86_64 26/46 Verifying : gcc-4.8.5-44.el7.x86_64 27/46 Verifying : perl-Scalar-List-Utils-1.27-248.el7.x86_64 28/46 Verifying : libaio-devel-0.3.109-13.el7.x86_64 29/46 Verifying : libmpc-1.0.1-3.el7.x86_64 30/46 Verifying : perl-File-Temp-0.23.01-3.el7.noarch 31/46 Verifying : numactl-2.0.12-5.el7.x86_64 32/46 Verifying : perl-Pod-Usage-1.63-3.el7.noarch 33/46 Verifying : perl-Encode-2.51-7.el7.x86_64 34/46 Verifying : glibc-devel-2.17-317.el7.x86_64 35/46 Verifying : bison-3.0.4-2.el7.x86_64 36/46 Verifying : perl-Pod-Perldoc-3.20-4.el7.noarch 37/46 Verifying : perl-podlators-2.5.1-3.el7.noarch 38/46 Verifying : autoconf-2.69-11.el7.noarch 39/46 Verifying : perl-File-Path-2.09-2.el7.noarch 40/46 Verifying : cmake-2.8.12.2-2.el7.x86_64 41/46 Verifying : perl-Filter-1.49-3.el7.x86_64 42/46 Verifying : perl-Getopt-Long-2.40-3.el7.noarch 43/46 Verifying : perl-Text-ParseWords-3.29-4.el7.noarch 44/46 Verifying : 4:perl-5.16.3-297.el7.x86_64 45/46 Verifying : 4:perl-macros-5.16.3-297.el7.x86_64 46/46 Installed:autoconf.noarch 0:2.69-11.el7 bison.x86_64 0:3.0.4-2.el7 bzip2.x86_64 0:1.0.6-13.el7 cmake.x86_64 0:2.8.12.2-2.el7 gcc.x86_64 0:4.8.5-44.el7 gcc-c++.x86_64 0:4.8.5-44.el7 libaio-devel.x86_64 0:0.3.109-13.el7 ncurses-devel.x86_64 0:5.9-14.20130511.el7_4 numactl.x86_64 0:2.0.12-5.el7 Dependency Installed:cpp.x86_64 0:4.8.5-44.el7 glibc-devel.x86_64 0:2.17-317.el7 glibc-headers.x86_64 0:2.17-317.el7 kernel-headers.x86_64 0:3.10.0-1160.el7 libarchive.x86_64 0:3.1.2-14.el7_7 libmpc.x86_64 0:1.0.1-3.el7 libstdc++-devel.x86_64 0:4.8.5-44.el7 m4.x86_64 0:1.4.16-10.el7 mpfr.x86_64 0:3.1.1-4.el7 perl.x86_64 4:5.16.3-297.el7 perl-Carp.noarch 0:1.26-244.el7 perl-Data-Dumper.x86_64 0:2.145-3.el7 perl-Encode.x86_64 0:2.51-7.el7 perl-Exporter.noarch 0:5.68-3.el7 perl-File-Path.noarch 0:2.09-2.el7 perl-File-Temp.noarch 0:0.23.01-3.el7 perl-Filter.x86_64 0:1.49-3.el7 perl-Getopt-Long.noarch 0:2.40-3.el7 perl-HTTP-Tiny.noarch 0:0.033-3.el7 perl-PathTools.x86_64 0:3.40-5.el7 perl-Pod-Escapes.noarch 1:1.04-297.el7 perl-Pod-Perldoc.noarch 0:3.20-4.el7 perl-Pod-Simple.noarch 1:3.28-4.el7 perl-Pod-Usage.noarch 0:1.63-3.el7 perl-Scalar-List-Utils.x86_64 0:1.27-248.el7 perl-Socket.x86_64 0:2.010-5.el7 perl-Storable.x86_64 0:2.45-3.el7 perl-Text-ParseWords.noarch 0:3.29-4.el7 perl-Time-HiRes.x86_64 4:1.9725-3.el7 perl-Time-Local.noarch 0:1.2300-2.el7 perl-constant.noarch 0:1.27-2.el7 perl-libs.x86_64 4:5.16.3-297.el7 perl-macros.x86_64 4:5.16.3-297.el7 perl-parent.noarch 1:0.225-244.el7 perl-podlators.noarch 0:2.5.1-3.el7 perl-threads.x86_64 0:1.87-4.el7 perl-threads-shared.x86_64 0:1.43-6.el7 Complete!
[root@cent79-2 ~]#
2.3.mysql8.0.33介质下载
命令：
cd /root
wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar
[root@cent79-2 ~]# cd /root
[root@cent79-2 ~]# wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar
--2023-07-11 15:12:14-- https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar
Resolving cdn.mysql.com (cdn.mysql.com)... 23.41.161.20
Connecting to cdn.mysql.com (cdn.mysql.com)|23.41.161.20|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1027983360 (980M) [application/x-tar]
Saving to: ‘mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar’0% [ ] 7,162,447 2.61MB/s
[root@cent79-2 ~]#
[root@cent79-2 ~]# ls
anaconda-ks.cfg mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar
[root@cent79-2 ~]#
2.4.mysql8.0.33安装
2.4.1.解压mysql8.0.33介质
命令：
tar -xvf mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar
[root@cent79-2 ~]# tar -xvf mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar
mysql-community-client-8.0.33-1.el7.x86_64.rpm
mysql-community-client-plugins-8.0.33-1.el7.x86_64.rpm
mysql-community-common-8.0.33-1.el7.x86_64.rpm
mysql-community-debuginfo-8.0.33-1.el7.x86_64.rpm
mysql-community-devel-8.0.33-1.el7.x86_64.rpm
mysql-community-embedded-compat-8.0.33-1.el7.x86_64.rpm
mysql-community-icu-data-files-8.0.33-1.el7.x86_64.rpm
mysql-community-libs-8.0.33-1.el7.x86_64.rpm
mysql-community-libs-compat-8.0.33-1.el7.x86_64.rpm
mysql-community-server-8.0.33-1.el7.x86_64.rpm
mysql-community-server-debug-8.0.33-1.el7.x86_64.rpm
mysql-community-test-8.0.33-1.el7.x86_64.rpm
[root@cent79-2 ~]# ls
anaconda-ks.cfg
mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar
mysql-community-client-8.0.33-1.el7.x86_64.rpm
mysql-community-client-plugins-8.0.33-1.el7.x86_64.rpm
mysql-community-common-8.0.33-1.el7.x86_64.rpm
mysql-community-debuginfo-8.0.33-1.el7.x86_64.rpm
mysql-community-devel-8.0.33-1.el7.x86_64.rpm
mysql-community-embedded-compat-8.0.33-1.el7.x86_64.rpm
mysql-community-icu-data-files-8.0.33-1.el7.x86_64.rpm
mysql-community-libs-8.0.33-1.el7.x86_64.rpm
mysql-community-libs-compat-8.0.33-1.el7.x86_64.rpm
mysql-community-server-8.0.33-1.el7.x86_64.rpm
mysql-community-server-debug-8.0.33-1.el7.x86_64.rpm
mysql-community-test-8.0.33-1.el7.x86_64.rpm
[root@cent79-2 ~]#
2.4.2.mysql8.0.33安装
命令(安装顺序一定不能变)：
rpm -ivh --nodeps --force mysql-community-common-8.0.33-1.el7.x86_64.rpm
rpm -ivh --nodeps --force mysql-community-libs-8.0.33-1.el7.x86_64.rpm
rpm -ivh --nodeps --force mysql-community-client-8.0.33-1.el7.x86_64.rpm
rpm -ivh --nodeps --force mysql-community-server-8.0.33-1.el7.x86_64.rpm
[root@cent79-2 ~]# rpm -ivh --nodeps --force mysql-community-common-8.0.33-1.el7.x86_64.rpm
warning: mysql-community-common-8.0.33-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
Preparing... ################################# [100%]
Updating / installing...1:mysql-community-common-8.0.33-1.e################################# [100%]
[root@cent79-2 ~]# rpm -ivh --nodeps --force mysql-community-libs-8.0.33-1.el7.x86_64.rpm
warning: mysql-community-libs-8.0.33-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
Preparing... ################################# [100%]
Updating / installing...1:mysql-community-libs-8.0.33-1.el7################################# [100%]
[root@cent79-2 ~]# rpm -ivh --nodeps --force mysql-community-client-8.0.33-1.el7.x86_64.rpm
warning: mysql-community-client-8.0.33-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
Preparing... ################################# [100%]
Updating / installing...1:mysql-community-client-8.0.33-1.e################################# [100%]
[root@cent79-2 ~]# rpm -ivh --nodeps --force mysql-community-server-8.0.33-1.el7.x86_64.rpm
warning: mysql-community-server-8.0.33-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
Preparing... ################################# [100%]
Updating / installing...1:mysql-community-server-8.0.33-1.e################################# [100%]
[root@cent79-2 ~]#
[root@cent79-2 ~]#
2.4.3.mysql安装后确认
mysql8.0.33默认安装在/var/lib/mysql目录，且会默认创建mysql用户
rpm -qa |grep mysql
cd /var/lib
ls -ld mysql*
cat /etc/passwd |grep mysql
[root@cent79-2 mysql]# rpm -qa |grep mysql
mysql-community-libs-8.0.33-1.el7.x86_64
mysql-community-server-8.0.33-1.el7.x86_64
mysql-community-common-8.0.33-1.el7.x86_64
mysql-community-client-8.0.33-1.el7.x86_64
[root@cent79-2 mysql]#
[root@cent79-2 lib]# cd /var/lib/
[root@cent79-2 lib]# ls -ld mysql*
drwxr-x--x 2 mysql mysql 6 Mar 17 02:51 mysql
drwxr-x--- 2 mysql mysql 6 Mar 17 02:51 mysql-files
drwxr-x--- 2 mysql mysql 6 Mar 17 02:51 mysql-keyring
[root@cent79-2 lib]# cat /etc/passwd |grep mysql
mysql:x:27:27:MySQL Server:/var/lib/mysql:/bin/false
[root@cent79-2 lib]#
2.4.4.启动mysql
命令：
systemctl start mysqld
systemctl enable mysqld
systemctl status mysqld
cd /var/lib/mysql
ls -l
[root@cent79-2 lib]# systemctl start mysqld
[root@cent79-2 lib]# systemctl enable mysqld
[root@cent79-2 lib]# systemctl status mysqld
● mysqld.service - MySQL ServerLoaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)Active: active (running) since Tue 2023-07-11 15:29:51 CST; 10s agoDocs: man:mysqld(8)http://dev.mysql.com/doc/refman/en/using-systemd.htmlMain PID: 1966 (mysqld)Status: "Server is operational"CGroup: /system.slice/mysqld.service└─1966 /usr/sbin/mysqldJul 11 15:29:39 cent79-2 systemd[1]: Starting MySQL Server...
Jul 11 15:29:51 cent79-2 systemd[1]: Started MySQL Server.
[root@cent79-2 lib]# cd mysql
[root@cent79-2 mysql]# ls
auto.cnf client-cert.pem ibdata1 mysql.ibd public_key.pem undo_002
binlog.000001 client-key.pem ibtmp1 mysql.sock server-cert.pem
binlog.index #ib_16384_0.dblwr #innodb_redo mysql.sock.lock server-key.pem
ca-key.pem #ib_16384_1.dblwr #innodb_temp performance_schema sys
ca.pem ib_buffer_pool mysql private_key.pem undo_001
[root@cent79-2 mysql]# ls -l
total 90568
-rw-r----- 1 mysql mysql 56 Jul 11 15:29 auto.cnf
-rw-r----- 1 mysql mysql 157 Jul 11 15:29 binlog.000001
-rw-r----- 1 mysql mysql 16 Jul 11 15:29 binlog.index
-rw------- 1 mysql mysql 1676 Jul 11 15:29 ca-key.pem
-rw-r--r-- 1 mysql mysql 1112 Jul 11 15:29 ca.pem
-rw-r--r-- 1 mysql mysql 1112 Jul 11 15:29 client-cert.pem
-rw------- 1 mysql mysql 1676 Jul 11 15:29 client-key.pem
-rw-r----- 1 mysql mysql 196608 Jul 11 15:29 #ib_16384_0.dblwr
-rw-r----- 1 mysql mysql 8585216 Jul 11 15:29 #ib_16384_1.dblwr
-rw-r----- 1 mysql mysql 5985 Jul 11 15:29 ib_buffer_pool
-rw-r----- 1 mysql mysql 12582912 Jul 11 15:29 ibdata1
-rw-r----- 1 mysql mysql 12582912 Jul 11 15:29 ibtmp1
drwxr-x--- 2 mysql mysql 4096 Jul 11 15:29 #innodb_redo
drwxr-x--- 2 mysql mysql 187 Jul 11 15:29 #innodb_temp
drwxr-x--- 2 mysql mysql 143 Jul 11 15:29 mysql
-rw-r----- 1 mysql mysql 25165824 Jul 11 15:29 mysql.ibd
srwxrwxrwx 1 mysql mysql 0 Jul 11 15:29 mysql.sock
-rw------- 1 mysql mysql 5 Jul 11 15:29 mysql.sock.lock
drwxr-x--- 2 mysql mysql 8192 Jul 11 15:29 performance_schema
-rw------- 1 mysql mysql 1676 Jul 11 15:29 private_key.pem
-rw-r--r-- 1 mysql mysql 452 Jul 11 15:29 public_key.pem
-rw-r--r-- 1 mysql mysql 1112 Jul 11 15:29 server-cert.pem
-rw------- 1 mysql mysql 1676 Jul 11 15:29 server-key.pem
drwxr-x--- 2 mysql mysql 28 Jul 11 15:29 sys
-rw-r----- 1 mysql mysql 16777216 Jul 11 15:29 undo_001
-rw-r----- 1 mysql mysql 16777216 Jul 11 15:29 undo_002
[root@cent79-2 mysql]#
2.4.5.修改mysql密码
命令：
grep "password" /var/log/mysqld.log --查找初始密码
/usr/bin/mysqladmin -uroot -p'${old_passwd}' password '${new_passwd}' --修改mysql密码
[root@cent79-2 log]# grep "password" /var/log/mysqld.log
2023-07-11T07:29:44.693012Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: J%LdHu9HRse4
[root@cent79-2 log]#
[root@cent79-2 log]# /usr/bin/mysqladmin -uroot -p'J%LdHu9HRse4' password 'Root2#admin'
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.
[root@cent79-2 log]#
2.4.6.mysql登录验证
命令：
mysql -uroot -pRoot2#admin
[root@cent79-2 log]# mysql -uroot -pRoot2#admin
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.33 MySQL Community Server - GPLCopyright (c) 2000, 2023, Oracle and/or its affiliates.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>
2.4.7.mysql用户root密码更改
命令：
show variables like '%valid%';
mysql> show variables like '%valid%';
+--------------------------------------+--------+
| Variable_name | Value |
+--------------------------------------+--------+
| innodb_validate_tablespace_paths | ON |
| validate_password.check_user_name | ON |
| validate_password.dictionary_file | |
| validate_password.length | 8 |
| validate_password.mixed_case_count | 1 |
| validate_password.number_count | 1 |
| validate_password.policy | MEDIUM |
| validate_password.special_char_count | 1 |
+--------------------------------------+--------+
8 rows in set (0.00 sec)
mysql>命令：
set global validate_password.check_user_name=OFF;
set global validate_password.policy=0;
set global validate_password.length=4;
flush privileges;
show variables like '%valid%';
mysql> set global validate_password.check_user_name=OFF;
Query OK, 0 rows affected (0.01 sec)mysql> set global validate_password.policy=0;
Query OK, 0 rows affected (0.00 sec)mysql> set global validate_password.length=4;
Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)mysql> show variables like '%valid%';
+--------------------------------------+-------+
| Variable_name | Value |
+--------------------------------------+-------+
| innodb_validate_tablespace_paths | ON |
| validate_password.check_user_name | OFF |
| validate_password.dictionary_file | |
| validate_password.length | 4 |
| validate_password.mixed_case_count | 1 |
| validate_password.number_count | 1 |
| validate_password.policy | LOW |
| validate_password.special_char_count | 1 |
+--------------------------------------+-------+
8 rows in set (0.00 sec)命令：
update user set authentication_string='' where user='root';
alter user 'root'@'localhost' identified with mysql_native_password by 'root';
flush privileges;
mysql> update user set authentication_string='' where user='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0mysql> alter user 'root'@'localhost' identified with mysql_native_password by 'root';
Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
退出验证：
命令：
exit
mysql -uroot -proot
mysql> exit
Bye
[root@cent79-2 log]# mysql -uroot -pRoot2#admin
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@cent79-2 log]# mysql -uroot -proot
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 8.0.33 MySQL Community Server - GPLCopyright (c) 2000, 2023, Oracle and/or its affiliates.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>
2.4.8.创建可登录的远程登录用户
命令：
create user 'root'@'%' identified with mysql_native_password by '${password}; --创建可登录的远程登录用户
grant all privileges on *.* to root@'%'; --授权
flush privileges; --刷新
select host,user,plugin,authentication_string from mysql.user;
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@'%';
Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)mysql> select host,user,plugin,authentication_string from mysql.user;
+-----------+------------------+-----------------------+------------------------------------------------------------------------+
| host | user | plugin | authentication_string |
+-----------+------------------+-----------------------+------------------------------------------------------------------------+
| % | root | mysql_native_password | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| localhost | mysql.infoschema | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| localhost | mysql.session | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| localhost | mysql.sys | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| localhost | root | mysql_native_password | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
+-----------+------------------+-----------------------+------------------------------------------------------------------------+
5 rows in set (0.00 sec)mysql>
Navicat远程连接验证：
至此，linux下mysql8.0.33安装已经完成。
相关文章：
1-linux下mysql8.0.33安装
在互联网企业的日常工作/运维中，我们会经常用到mysql数据库，而linux下mysql的安装方式有三种： 1.mysql rpm安装 2.mysql二进制安装 3.mysql源码安装 今天就为大家讲讲linux下mysql8.0.33版本rpm方式的安装。 1.前提 1.1.系统版本 Cent…...
golang反射获取结构体的值和修改值
功能：根据id和反射技术封装 创建和更新人的查询 一、代码二、演示 一、代码 package coryCommonimport ("context""errors""github.com/gogf/gf/v2/container/gvar""github.com/tiger1103/gfast/v3/internal/app/system/dao&qu…...
中文大模型评估数据集——C-Eval
C-EVAL: A Multi-Level Multi-Discipline Chinese Evaluation Suite for Foundation Models https://arxiv.org/pdf/2305.08322v1.pdfhttps://github.com/SJTU-LIT/cevalhttps://cevalbenchmark.com/static/leaderboard.html Part1 前言 怎么去评估一个大语言模型呢？ 在广泛…...
Unity 四元素
//-------------旋转------------ // //设置角度 (超过90或负数时，会设置-1结果是359这样的问题，可以使用下面旋转的方式) transform.rotate new Quaternion(0,0,0,0);//Quaternion四元数 transform.localEulerAngles new Vector3(0,0,0);//EulerA…...
如何入门python爬虫
对于初学者，想要入门python爬虫需要注意什么，如何快速入门呢？ 首先需要明白四点： 熟悉python编程了解HTML了解网络爬虫的基本原理学习使用python爬虫的一些库与框架python编程 如果你不懂python，那么需要先学习python这门非常easy的语言（相对其它语言而言）。 编程语言…...
深入学习 Redis - 基于 Jedis 通过 Java 客户端操作 Redis
目录 一、Jedis 依赖 二、Java 客户端操控 redis 2.1、准备工作（ssh 隧道） 2.2、概要 2.2、string 2.3、hash 2.4、list 2.5、set 2.5、zset 一、Jedis 依赖 自己去 中央仓库 上面找. 二、Java 客户端操控 redis 2.1、准备工作（ssh 隧…...
019 - STM32学习笔记 - Fatfs文件系统（一） - FatFs文件系统初识
019 - STM32学习笔记 - Fatfs文件系统（一） - FatFs文件系统初识 最近工作比较忙，没时间摸鱼学习，抽空学点就整理一点笔记。 1、文件系统 在之前学习Flash的时候，可以调用SPI_FLASH_BufferWrite函数，将数…...
Selenium开发环境搭建
1.下载Python https://www.python.org/downloads/ 下载下来选择自己创建的路径进行安装，然后配置环境变量 cmd命令框查看 2.安装selenium cmd命令框输入： pip install selenium3.下载pycharm https://www.jetbrains.com/pycharm/download/#sec…...
解决 The ‘more_itertools‘ package is required
在使用爬虫获取维基百科数据时看到了一个很好的项目： 博客：https://blog.51cto.com/u_15919249/5962100 项目地址：https://github.com/wjn1996/scrapy_for_zh_wiki 但在使用过程中遇到若干问题，记录一下： The more_it…...
手把手教你在云环境炼丹（部署Stable Diffusion WebUI）
前几天写了一篇《手把手教你在本机安装Stable Diffusion秋叶整合包》的文章，有些同学反映对硬件的要求太高，显卡太TM贵了。今天我再分享一个云服务器炼丹的方法，方便大家快速入门上手，这个云服务不需要特殊网络设置，能…...
pytorch-gpu 极简安装
1、进入pytoch官网：PyTorch 找到pytorch-gpu版本，看到CUDA11.8、11.7、CPU，这里我选择安装CUDA11.8 2、下载CUDA Toolkit：CUDA Toolkit 11.8 Downloads | NVIDIA Developer 3、下载CUDANN：cuDNN Download | NVIDIA D…...
有道云笔记迁移到自建服务器Joplin
当前有道云笔记各项业务开始逐渐向会员靠拢，如一开始不受限的多端同步现在非会员限制成了两个终端，估计以后会有越来越多的免费内容会逐渐的向会员转移，因此博主开始考虑自建服务器来搞一个云笔记服务端。 因博主已有黑群晖，并且有…...
qt源码--事件系统之QAbstractEventDispatcher
1、QAbstractEventDispatcher内容较少，其主要是定义了一些注册接口，如定时器事件、socket事件、注册本地事件、自定义事件等等。其源码如下： 其主要定义了大量的纯虚函数，具体的实现会根据不同的系统平台，实现对应的方…...
深入了解Python中的os.path.join函数
深入了解Python中的os.path.join函数 1. 引言 在Python中，处理文件和目录路径是常见的任务。为了简化路径的拼接和操作，Python提供了os.path模块，其中的join函数是一个非常重要且常用的函数。本文将深入介绍os.path.join函数的用法和注意事…...
Node.js：execSync执行一个shell命令
默认输出是Buffer对象 const { execSync } require(child_process)let out execSync("echo hi") console.log(out); // <Buffer 68 69 0a>需要转为字符串 const { execSync } require(child_process)let out execSync("echo hi") console.log(…...
《入门级-Cocos2d 4.0塔防游戏开发》---第二课：游戏加载界面开发
目录 一、开发环境介绍 二、开发内容 2.1 修改窗口的大小。 2.2 添加加载场景相关代码 2.3 添加资源 三、显示效果 四、知识点 4.1 Sprite 4.2 定时器 一、开发环境介绍 操作系统：UOS1060专业版本。 cocos2dx:版本 环境搭建教程： 统信UOS下配…...
打卡力扣题目十二
#左耳听风 ARST 打卡活动重启# 目录 一、问题 二、解题方法一 三、解题方法二 关于 ARTS 的释义 —— 每周完成一个 ARTS： ● Algorithm: 每周至少做一个 LeetCode 的算法题 ● Review: 阅读并点评至少一篇英文技术文章 ● Tips: 学习至少一个技术技巧 ● Share: …...
QT服务器练习
#include "widget.h" #include "ui_widget.h"Widget::Widget(QWidget *parent): QWidget(parent), ui(new Ui::Widget) {ui->setupUi(this);//给服务器指针实例化空间server new QTcpServer(this); }Widget::~Widget() {delete ui; }//启动服务器按钮对…...
Vcenter 创建 虚拟机配置 Thin Provision 模式 disk
介绍 在vCenter中选择虚拟磁盘格式通常也取决于您的需求和使用情况。 vSphere支持多种虚拟磁盘格式，以下是一些常见的格式： Thick Provision Lazy Zeroed：这是vSphere中的默认格式。它会预分配虚拟磁盘所需的存储空间，但只有在虚…...
初识mysql数据库之事务的概念及操作
目录 一、数据库多客户端访问问题 1. 数据库的CURD无限制带来的问题 2. 如何解决CURD导致的问题 二、事务的概念 1. 什么是事务 2. 事务的四个属性 3. mysql对事务的管理 4. 为什么会有事务 5. 事务的版本支持 三、事务的操作 1. 事务提交方式 2. 事务操作的准备工…...
TDengine 快速体验（Docker 镜像方式）
简介 TDengine 可以通过安装包、Docker 镜像 及云服务快速体验 TDengine 的功能，本节首先介绍如何通过 Docker 快速体验 TDengine，然后介绍如何在 Docker 环境下体验 TDengine 的写入和查询功能。如果你不熟悉 Docker，请使用 安装包的方式快…...
数据链路层的主要功能是什么
数据链路层（OSI模型第2层）的核心功能是在相邻网络节点（如交换机、主机）间提供可靠的数据帧传输服务，主要职责包括： 🔑 核心功能详解： 帧封装与解封装 封装： 将网络层下发…...
【Web 进阶篇】优雅的接口设计：统一响应、全局异常处理与参数校验
系列回顾： 在上一篇中，我们成功地为应用集成了数据库，并使用 Spring Data JPA 实现了基本的 CRUD API。我们的应用现在能“记忆”数据了！但是，如果你仔细审视那些 API，会发现它们还很“粗糙”：有…...
)
GitHub 趋势日报 (2025年06月08日)
📊 由 TrendForge 系统生成 | 🌐 https://trendforge.devlive.org/ 🌐 本日报中的项目描述已自动翻译为中文 📈 今日获星趋势图 今日获星趋势图 884 cognee 566 dify 414 HumanSystemOptimization 414 omni-tools 321 note-gen …...
Android15默认授权浮窗权限
我们经常有那种需求，客户需要定制的apk集成在ROM中，并且默认授予其【显示在其他应用的上层】权限，也就是我们常说的浮窗权限，那么我们就可以通过以下方法在wms、ams等系统服务的systemReady()方法中调用即可实现预置应用默认授权浮…...
DeepSeek源码深度解析 × 华为仓颉语言编程精粹——从MoE架构到全场景开发生态
前言 在人工智能技术飞速发展的今天，深度学习与大模型技术已成为推动行业变革的核心驱动力，而高效、灵活的开发工具与编程语言则为技术创新提供了重要支撑。本书以两大前沿技术领域为核心，系统性地呈现了两部深度技术著作的精华：…...
DAY 26 函数专题1
函数定义与参数知识点回顾：1. 函数的定义2. 变量作用域：局部变量和全局变量3. 函数的参数类型：位置参数、默认参数、不定参数4. 传递参数的手段：关键词参数5 题目1：计算圆的面积 任务： 编写一…...
sshd代码修改banner
sshd服务连接之后会收到字符串： SSH-2.0-OpenSSH_9.5 容易被hacker识别此服务为sshd服务。 是否可以通过修改此banner达到让人无法识别此服务的目的呢？ 不能。因为这是写的SSH的协议中的。 也就是协议规定了banner必须这么写。 SSH- 开头，…...
图解JavaScript原型：原型链及其分析 | JavaScript图解
忽略该图的细节（如内存地址值没有用二进制） 以下是对该图进一步的理解和总结 1. JS 对象概念的辨析 对象是什么：保存在堆中一块区域，同时在栈中有一块区域保存其在堆中的地址（也就是我们通常说的该变量指向谁&…...
土建施工员考试：建筑施工技术重点知识有哪些？
《管理实务》是土建施工员考试中侧重实操应用与管理能力的科目，核心考查施工组织、质量安全、进度成本等现场管理要点。以下是结合考试大纲与高频考点整理的重点内容，附学习方向和应试技巧： 一、施工组织与进度管理 核心目标： 规…...