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. 事务操作的准备工…...
MPL-2.0（Mozilla Public License 2.0）
MPL-2.0（Mozilla Public License 2.0）是一种开源软件许可证，由 Mozilla 组织于2012年发布，用于授权开源项目。MPL-2.0 是 MPL-1.1 许可证的继任版本，旨在更好地适应现代开源软件的发展和使用。 MPL-2.0 许可证的主要特…...
Qt+OpenCV+VTK在VS2017中配置路径
QtOpenCVVTK在VS2017中配置路径 《Qt环境配置》《OpenCV环境配置》《VTK环境配置》 《Qt环境配置》 包含目录： D:\Qt\Qt5.12.11\5.12.11\msvc2017_64\include D:\Qt\Qt5.12.11\5.12.11\msvc2017_64\include\QtWidgets D:\Qt\Qt5.12.11\5.12.11\msvc2017_64\include…...
线性代数(应用篇)：第五章:特征值与特征向量、第六章:二次型
文章目录 第5章 特征值与特征向量、相似矩阵(一) 特征值与特征向量1.定义2.性质3.求解(1)具体型矩阵试根法、多项式带余除法：三阶多项式分解因式 (2)抽象型矩阵 (二) 相似1.矩阵相似(1)定义(2)性质 2.相似对角化(1)定义(2)相似对角化的条件（n阶矩阵A可相…...
Java8实战-总结9
Java8实战-总结9 Lambda表达式把Lambda付诸实践：环绕执行模式第1步：记得行为参数化第2步：使用函数式接口来传递行为第3步：执行一个行为第4步：传递Lambda 使用函数式接口PredicateConsumerFunction原始类型特化 Lambda表…...
大数据开发面试必问：Hive调优技巧系列一
Hive必问调优 Hive 调优拆解:Hive SQL 几乎是每一位互联网分析师的必备技能，相信很多小伙伴都有被面试官问到 Hive 优化问题的经历。所以掌握扎实的 HQL 基础尤为重要，hive优化也是小伙伴应该掌握的一项技能，本篇文章具体从hive建表优化、HQ…...
Jupyter Notebook 7重磅发布，新增多个特性！
本文分享Jupyter Notebook大版本v7.0.0更新亮点，及简单测试！ 近日，Jupyter Notebook大版本v7.0.0更新，Jupyter Notebook 7基于JupyterLab，因此它包含了过去几年JupyterLab中添加的许多新功能和改进，部分亮…...
linux V4L2子系统——v4l2架构（1）之整体架构
概述 V4L（Video for Linux）是Linux内核中关于视频设备的API接口，涉及视频设备的音频和视频信息采集及处理、视频设备的控制。V4L出现于Linux内核2.1版本，经过修改bug和添加功能，Linux内核2.5版本推出了V4L2（…...
Qt信号与槽机制的本质
引入 对象与对象之间的通信有多个方式，如果我们要提供一种对象之间的通信机制。这种机制，要能够给两个不同对象中的函数建立映射关系，前者被调用时后者也能被自动调用。 再深入一些，两个对象如果都互相不知道对方的存在ÿ…...
Linux：入门学习知识及常见指令
文章目录 入门介绍操作系统的概念Linux机器的使用Linux上的指令 对文件知识的补充文件的定义和一些含义文件和目录的存储绝对路径和相对路径 ls指令pwd指令cd指令touch指令mkdir指令rmdir指令rm指令man指令cp指令mv指令cat指令more指令echo指令输出重定向 less指令find指令grep…...
K8s：Kubernetes 故障排除方法论
写在前面 博文内容为节译整理文中提到的工具大部分是商业软件，不是开源的，作为了解理解不足小伙伴帮忙指正 对每个人而言，真正的职责只有一个：找到自我。然后在心中坚守其一生，全心全意，永不停息。所有其它…...