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. 事务操作的准备工…...
Debian系统简介
目录 Debian系统介绍 Debian版本介绍 Debian软件源介绍 软件包管理工具dpkg dpkg核心指令详解 安装软件包 卸载软件包 查询软件包状态 验证软件包完整性 手动处理依赖关系 dpkg vs apt Debian系统介绍 Debian 和 Ubuntu 都是基于 Debian内核 的 Linux 发行版ÿ…...
` 方法)
深入浅出：JavaScript 中的 `window.crypto.getRandomValues()` 方法
深入浅出：JavaScript 中的 window.crypto.getRandomValues() 方法 在现代 Web 开发中，随机数的生成看似简单，却隐藏着许多玄机。无论是生成密码、加密密钥，还是创建安全令牌，随机数的质量直接关系到系统的安全性。Jav…...
ETLCloud可能遇到的问题有哪些？常见坑位解析
数据集成平台ETLCloud，主要用于支持数据的抽取（Extract）、转换（Transform）和加载（Load）过程。提供了一个简洁直观的界面，以便用户可以在不同的数据源之间轻松地进行数据迁移和转换。…...
【Web 进阶篇】优雅的接口设计：统一响应、全局异常处理与参数校验
系列回顾： 在上一篇中，我们成功地为应用集成了数据库，并使用 Spring Data JPA 实现了基本的 CRUD API。我们的应用现在能“记忆”数据了！但是，如果你仔细审视那些 API，会发现它们还很“粗糙”：有…...
鱼香ros docker配置镜像报错：https://registry-1.docker.io/v2/
使用鱼香ros一件安装docker时的https://registry-1.docker.io/v2/问题 一键安装指令 wget http://fishros.com/install -O fishros && . fishros出现问题：docker pull 失败 网络不同，需要使用镜像源 按照如下步骤操作 sudo vi /etc/docker/dae…...
Java面试专项一-准备篇
一、企业简历筛选规则 一般企业的简历筛选流程：首先由HR先筛选一部分简历后，在将简历给到对应的项目负责人后再进行下一步的操作。 HR如何筛选简历 例如：Boss直聘（招聘方平台） 直接按照条件进行筛选 例如：…...
【HarmonyOS 5 开发速记】如何获取用户信息（头像/昵称/手机号）
1.获取 authorizationCode： 2.利用 authorizationCode 获取 accessToken：文档中心 3.获取手机：文档中心 4.获取昵称头像：文档中心 首先创建 request 若要获取手机号，scope必填 phone，permissions 必填 …...
基于SpringBoot在线拍卖系统的设计和实现
摘 要 随着社会的发展，社会的各行各业都在利用信息化时代的优势。计算机的优势和普及使得各种信息系统的开发成为必需。 在线拍卖系统，主要的模块包括管理员；首页、个人中心、用户管理、商品类型管理、拍卖商品管理、历史竞拍管理、竞拍订单…...
Linux系统部署KES
1、安装准备 1.版本说明V008R006C009B0014 V008：是version产品的大版本。 R006：是release产品特性版本。 C009：是通用版 B0014：是build开发过程中的构建版本2.硬件要求 #安全版和企业版 内存：1GB 以上 硬盘…...
OD 算法题 B卷【正整数到Excel编号之间的转换】
文章目录 正整数到Excel编号之间的转换 正整数到Excel编号之间的转换 excel的列编号是这样的：a b c … z aa ab ac… az ba bb bc…yz za zb zc …zz aaa aab aac…; 分别代表以下的编号1 2 3 … 26 27 28 29… 52 53 54 55… 676 677 678 679 … 702 703 704 705;…...