MySQL:飞腾2000+Centos7.6 aarch64 部署MySQL8.0.36

目录

1.硬件环境

2.MySQL选择 Bundle版本【全部文件】​编辑

3.下载并安装

4.安装完成后检查mysql 

5.初始化MySQL

6.那就问了,都初始化了啥?

7.尝试启动MySQL

8.给mysql文件授权

 9.再次尝试启动正常

10.mysql初始化目录出现了mysql.sock

11.找到MySQL初始化时的密码

12.测试PC客户端连接工具

13. 关闭SSL连接成功

 14.另外如果用的时navicat版本较低连接会报错

 15.请选用版本较高的navicat连接工具

16.新版本的navicat获取方式


1.硬件环境

cpu信息

OS信息 

MySQL选择

地址: MySQL :: Download MySQL Community Server

2.MySQL选择 Bundle版本【全部文件】

3.下载并安装

[root@localhost ~]# wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.36-1.el7.aarch64.rpm-bundle.tar
total 1092968
[root@localhost ~]# tar -xvf mysql-8.0.36-1.el7.aarch64.rpm-bundle.tar -C mysql-rpm
-rw-r--r-- 1 7155 31415  16142028 Dec 14 14:42 mysql-community-client-8.0.36-1.el7.aarch64.rpm
-rw-r--r-- 1 7155 31415   3552480 Dec 14 14:42 mysql-community-client-plugins-8.0.36-1.el7.aarch64.rpm
-rw-r--r-- 1 7155 31415    681252 Dec 14 14:42 mysql-community-common-8.0.36-1.el7.aarch64.rpm
-rw-r--r-- 1 7155 31415 622144264 Dec 14 14:43 mysql-community-debuginfo-8.0.36-1.el7.aarch64.rpm
-rw-r--r-- 1 7155 31415   1906476 Dec 14 14:44 mysql-community-devel-8.0.36-1.el7.aarch64.rpm
-rw-r--r-- 1 7155 31415   3948036 Dec 14 14:44 mysql-community-embedded-compat-8.0.36-1.el7.aarch64.rpm
-rw-r--r-- 1 7155 31415   2344460 Dec 14 14:44 mysql-community-icu-data-files-8.0.36-1.el7.aarch64.rpm
-rw-r--r-- 1 7155 31415   1505692 Dec 14 14:44 mysql-community-libs-8.0.36-1.el7.aarch64.rpm
-rw-r--r-- 1 7155 31415    666500 Dec 14 14:44 mysql-community-libs-compat-8.0.36-1.el7.aarch64.rpm
-rw-r--r-- 1 root root       6140 Nov 12  2015 mysql-community-release-el7-5.noarch.rpm
-rw-r--r-- 1 7155 31415  65412028 Dec 14 14:44 mysql-community-server-8.0.36-1.el7.aarch64.rpm
-rw-r--r-- 1 7155 31415  24484504 Dec 14 14:45 mysql-community-server-debug-8.0.36-1.el7.aarch64.rpm
-rw-r--r-- 1 7155 31415 376376388 Dec 14 14:46 mysql-community-test-8.0.36-1.el7.aarch64.rpm
[root@localhost mysql-rpm]# yum install -y ./*
Loaded plugins: fastestmirror
Examining ./mysql-community-client-8.0.36-1.el7.aarch64.rpm: mysql-community-client-8.0.36-1.el7.aarch64
./mysql-community-client-8.0.36-1.el7.aarch64.rpm: does not update installed package.
Examining ./mysql-community-client-plugins-8.0.36-1.el7.aarch64.rpm: mysql-community-client-plugins-8.0.36-1.el7.aarch64
./mysql-community-client-plugins-8.0.36-1.el7.aarch64.rpm: does not update installed package.
Examining ./mysql-community-common-8.0.36-1.el7.aarch64.rpm: mysql-community-common-8.0.36-1.el7.aarch64
./mysql-community-common-8.0.36-1.el7.aarch64.rpm: does not update installed package.
Examining ./mysql-community-debuginfo-8.0.36-1.el7.aarch64.rpm: mysql-community-debuginfo-8.0.36-1.el7.aarch64
Marking ./mysql-community-debuginfo-8.0.36-1.el7.aarch64.rpm to be installed
Examining ./mysql-community-devel-8.0.36-1.el7.aarch64.rpm: mysql-community-devel-8.0.36-1.el7.aarch64
Marking ./mysql-community-devel-8.0.36-1.el7.aarch64.rpm to be installed
Examining ./mysql-community-embedded-compat-8.0.36-1.el7.aarch64.rpm: mysql-community-embedded-compat-8.0.36-1.el7.aarch64
Marking ./mysql-community-embedded-compat-8.0.36-1.el7.aarch64.rpm to be installed
Examining ./mysql-community-icu-data-files-8.0.36-1.el7.aarch64.rpm: mysql-community-icu-data-files-8.0.36-1.el7.aarch64
./mysql-community-icu-data-files-8.0.36-1.el7.aarch64.rpm: does not update installed package.
Examining ./mysql-community-libs-8.0.36-1.el7.aarch64.rpm: mysql-community-libs-8.0.36-1.el7.aarch64
./mysql-community-libs-8.0.36-1.el7.aarch64.rpm: does not update installed package.
Examining ./mysql-community-libs-compat-8.0.36-1.el7.aarch64.rpm: mysql-community-libs-compat-8.0.36-1.el7.aarch64
Marking ./mysql-community-libs-compat-8.0.36-1.el7.aarch64.rpm to be installed
Examining ./mysql-community-release-el7-5.noarch.rpm: mysql-community-release-el7-5.noarch
Marking ./mysql-community-release-el7-5.noarch.rpm to be installed
Examining ./mysql-community-server-8.0.36-1.el7.aarch64.rpm: mysql-community-server-8.0.36-1.el7.aarch64
Marking ./mysql-community-server-8.0.36-1.el7.aarch64.rpm to be installed
Examining ./mysql-community-server-debug-8.0.36-1.el7.aarch64.rpm: mysql-community-server-debug-8.0.36-1.el7.aarch64
Marking ./mysql-community-server-debug-8.0.36-1.el7.aarch64.rpm to be installed
Examining ./mysql-community-test-8.0.36-1.el7.aarch64.rpm: mysql-community-test-8.0.36-1.el7.aarch64
Marking ./mysql-community-test-8.0.36-1.el7.aarch64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-debuginfo.aarch64 0:8.0.36-1.el7 will be installed
---> Package mysql-community-devel.aarch64 0:8.0.36-1.el7 will be installed
---> Package mysql-community-embedded-compat.aarch64 0:8.0.36-1.el7 will be installed
---> Package mysql-community-libs-compat.aarch64 0:8.0.36-1.el7 will be installed
---> Package mysql-community-release.noarch 0:el7-5 will be installed
---> Package mysql-community-server.aarch64 0:8.0.36-1.el7 will be installed
--> Processing Dependency: /usr/bin/perl for package: mysql-community-server-8.0.36-1.el7.aarch64
Loading mirror speeds from cached hostfile* base: mirrors.huaweicloud.com* extras: mirrors.huaweicloud.com* updates: mirrors.huaweicloud.com
base                                                                                                                                                                                                        | 3.6 kB  00:00:00
extras                                                                                                                                                                                                      | 2.9 kB  00:00:00
updates                                                                                                                                                                                                     | 2.9 kB  00:00:00
--> Processing Dependency: net-tools for package: mysql-community-server-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(Getopt::Long) for package: mysql-community-server-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(strict) for package: mysql-community-server-8.0.36-1.el7.aarch64
---> Package mysql-community-server-debug.aarch64 0:8.0.36-1.el7 will be installed
---> Package mysql-community-test.aarch64 0:8.0.36-1.el7 will be installed
--> Processing Dependency: perl(Carp) for package: mysql-community-test-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(Carp) for package: mysql-community-test-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(Cwd) for package: mysql-community-test-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(Cwd) for package: mysql-community-test-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(Data::Dumper) for package: mysql-community-test-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(Data::Dumper) for package: mysql-community-test-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(Exporter) for package: mysql-community-test-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(Exporter) for package: mysql-community-test-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(File::Path) for package: mysql-community-test-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(File::Path) for package: mysql-community-test-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(File::Spec) for package: mysql-community-test-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(File::Spec) for package: mysql-community-test-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(File::Spec::Functions) for package: mysql-community-test-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(File::Spec::Functions) for package: mysql-community-test-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(File::Temp) for package: mysql-community-test-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(File::Temp) for package: mysql-community-test-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(JSON) for package: mysql-community-test-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(JSON) for package: mysql-community-test-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(Test::More) for package: mysql-community-test-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(Time::HiRes) for package: mysql-community-test-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(Time::HiRes) for package: mysql-community-test-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(constant) for package: mysql-community-test-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(threads) for package: mysql-community-test-8.0.36-1.el7.aarch64
--> Processing Dependency: perl(threads::shared) for package: mysql-community-test-8.0.36-1.el7.aarch64
--> Running transaction check
---> Package net-tools.aarch64 0:2.0-0.25.20131004git.el7 will be installed
---> Package perl.aarch64 4:5.16.3-299.el7_9 will be installed
--> Processing Dependency: perl-libs = 4:5.16.3-299.el7_9 for package: 4:perl-5.16.3-299.el7_9.aarch64
--> Processing Dependency: perl(Socket) >= 1.3 for package: 4:perl-5.16.3-299.el7_9.aarch64
--> Processing Dependency: perl(Scalar::Util) >= 1.10 for package: 4:perl-5.16.3-299.el7_9.aarch64
--> Processing Dependency: perl-macros for package: 4:perl-5.16.3-299.el7_9.aarch64
--> Processing Dependency: perl-libs for package: 4:perl-5.16.3-299.el7_9.aarch64
--> Processing Dependency: perl(Time::Local) for package: 4:perl-5.16.3-299.el7_9.aarch64
--> Processing Dependency: perl(Storable) for package: 4:perl-5.16.3-299.el7_9.aarch64
--> Processing Dependency: perl(Socket) for package: 4:perl-5.16.3-299.el7_9.aarch64
--> Processing Dependency: perl(Scalar::Util) for package: 4:perl-5.16.3-299.el7_9.aarch64
--> Processing Dependency: perl(Pod::Simple::XHTML) for package: 4:perl-5.16.3-299.el7_9.aarch64
--> Processing Dependency: perl(Pod::Simple::Search) for package: 4:perl-5.16.3-299.el7_9.aarch64
--> Processing Dependency: perl(Filter::Util::Call) for package: 4:perl-5.16.3-299.el7_9.aarch64
--> Processing Dependency: libperl.so()(64bit) for package: 4:perl-5.16.3-299.el7_9.aarch64
---> Package perl-Carp.noarch 0:1.26-244.el7 will be installed
---> Package perl-Data-Dumper.aarch64 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-File-Temp.noarch 0:0.23.01-3.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
--> Processing Dependency: perl(Text::ParseWords) for package: perl-Getopt-Long-2.40-3.el7.noarch
---> Package perl-JSON.noarch 0:2.59-2.el7 will be installed
---> Package perl-PathTools.aarch64 0:3.40-5.el7 will be installed
---> Package perl-Test-Simple.noarch 0:0.98-243.el7 will be installed
--> Processing Dependency: perl(Test::Harness) >= 2.03 for package: perl-Test-Simple-0.98-243.el7.noarch
---> Package perl-Time-HiRes.aarch64 4:1.9725-3.el7 will be installed
---> Package perl-constant.noarch 0:1.27-2.el7 will be installed
---> Package perl-threads.aarch64 0:1.87-4.el7 will be installed
---> Package perl-threads-shared.aarch64 0:1.43-6.el7 will be installed
--> Running transaction check
---> Package perl-Filter.aarch64 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.aarch64 0:1.27-248.el7 will be installed
---> Package perl-Socket.aarch64 0:2.010-5.el7 will be installed
---> Package perl-Storable.aarch64 0:2.45-3.el7 will be installed
---> Package perl-Test-Harness.noarch 0:3.28-3.el7 will be installed
---> Package perl-Text-ParseWords.noarch 0:3.29-4.el7 will be installed
---> Package perl-Time-Local.noarch 0:1.2300-2.el7 will be installed
---> Package perl-libs.aarch64 4:5.16.3-299.el7_9 will be installed
---> Package perl-macros.aarch64 4:5.16.3-299.el7_9 will be installed
--> Running transaction check
---> Package perl-Encode.aarch64 0:2.51-7.el7 will be installed
---> Package perl-Pod-Escapes.noarch 1:1.04-299.el7_9 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:mysql-community-debuginfo                                aarch64                          8.0.36-1.el7                                       /mysql-community-debuginfo-8.0.36-1.el7.aarch64                                2.8 Gmysql-community-devel                                    aarch64                          8.0.36-1.el7                                       /mysql-community-devel-8.0.36-1.el7.aarch64                                    9.9 Mmysql-community-embedded-compat                          aarch64                          8.0.36-1.el7                                       /mysql-community-embedded-compat-8.0.36-1.el7.aarch64                           17 Mmysql-community-libs-compat                              aarch64                          8.0.36-1.el7                                       /mysql-community-libs-compat-8.0.36-1.el7.aarch64                              3.6 Mmysql-community-release                                  noarch                           el7-5                                              /mysql-community-release-el7-5.noarch                                          4.3 kmysql-community-server                                   aarch64                          8.0.36-1.el7                                       /mysql-community-server-8.0.36-1.el7.aarch64                                   292 Mmysql-community-server-debug                             aarch64                          8.0.36-1.el7                                       /mysql-community-server-debug-8.0.36-1.el7.aarch64                             123 Mmysql-community-test                                     aarch64                          8.0.36-1.el7                                       /mysql-community-test-8.0.36-1.el7.aarch64                                     760 M
Installing for dependencies:net-tools                                                aarch64                          2.0-0.25.20131004git.el7                           base                                                                           309 kperl                                                     aarch64                          4:5.16.3-299.el7_9                                 updates                                                                        7.9 Mperl-Carp                                                noarch                           1.26-244.el7                                       base                                                                            19 kperl-Data-Dumper                                         aarch64                          2.145-3.el7                                        base                                                                            46 kperl-Encode                                              aarch64                          2.51-7.el7                                         base                                                                           1.1 Mperl-Exporter                                            noarch                           5.68-3.el7                                         base                                                                            28 kperl-File-Path                                           noarch                           2.09-2.el7                                         base                                                                            26 kperl-File-Temp                                           noarch                           0.23.01-3.el7                                      base                                                                            56 kperl-Filter                                              aarch64                          1.49-3.el7                                         base                                                                            76 kperl-Getopt-Long                                         noarch                           2.40-3.el7                                         base                                                                            56 kperl-HTTP-Tiny                                           noarch                           0.033-3.el7                                        base                                                                            38 kperl-JSON                                                noarch                           2.59-2.el7                                         base                                                                            96 kperl-PathTools                                           aarch64                          3.40-5.el7                                         base                                                                            82 kperl-Pod-Escapes                                         noarch                           1:1.04-299.el7_9                                   updates                                                                         52 kperl-Pod-Perldoc                                         noarch                           3.20-4.el7                                         base                                                                            87 kperl-Pod-Simple                                          noarch                           1:3.28-4.el7                                       base                                                                           216 kperl-Pod-Usage                                           noarch                           1.63-3.el7                                         base                                                                            27 kperl-Scalar-List-Utils                                   aarch64                          1.27-248.el7                                       base                                                                            35 kperl-Socket                                              aarch64                          2.010-5.el7                                        base                                                                            48 kperl-Storable                                            aarch64                          2.45-3.el7                                         base                                                                            73 kperl-Test-Harness                                        noarch                           3.28-3.el7                                         base                                                                           302 kperl-Test-Simple                                         noarch                           0.98-243.el7                                       base                                                                           170 kperl-Text-ParseWords                                     noarch                           3.29-4.el7                                         base                                                                            14 kperl-Time-HiRes                                          aarch64                          4:1.9725-3.el7                                     base                                                                            45 kperl-Time-Local                                          noarch                           1.2300-2.el7                                       base                                                                            24 kperl-constant                                            noarch                           1.27-2.el7                                         base                                                                            19 kperl-libs                                                aarch64                          4:5.16.3-299.el7_9                                 updates                                                                        621 kperl-macros                                              aarch64                          4:5.16.3-299.el7_9                                 updates                                                                         44 kperl-parent                                              noarch                           1:0.225-244.el7                                    base                                                                            12 kperl-podlators                                           noarch                           2.5.1-3.el7                                        base                                                                           112 kperl-threads                                             aarch64                          1.87-4.el7                                         base                                                                            48 kperl-threads-shared                                      aarch64                          1.43-6.el7                                         base                                                                            37 kTransaction Summary
===================================================================================================================================================================================================================================
Install  8 Packages (+32 Dependent packages)Total size: 4.0 G
Total download size: 12 M
Installed size: 4.1 G
Downloading packages:
(1/32): perl-Carp-1.26-244.el7.noarch.rpm                                                                                                                                                                   |  19 kB  00:00:00
(2/32): perl-Data-Dumper-2.145-3.el7.aarch64.rpm                                                                                                                                                            |  46 kB  00:00:00
(3/32): net-tools-2.0-0.25.20131004git.el7.aarch64.rpm                                                                                                                                                      | 309 kB  00:00:00
(4/32): perl-Exporter-5.68-3.el7.noarch.rpm                                                                                                                                                                 |  28 kB  00:00:00
(5/32): perl-Encode-2.51-7.el7.aarch64.rpm                                                                                                                                                                  | 1.1 MB  00:00:00
(6/32): perl-File-Path-2.09-2.el7.noarch.rpm                                                                                                                                                                |  26 kB  00:00:00
(7/32): perl-File-Temp-0.23.01-3.el7.noarch.rpm                                                                                                                                                             |  56 kB  00:00:00
(8/32): perl-Filter-1.49-3.el7.aarch64.rpm                                                                                                                                                                  |  76 kB  00:00:00
(9/32): perl-Getopt-Long-2.40-3.el7.noarch.rpm                                                                                                                                                              |  56 kB  00:00:00
(10/32): perl-HTTP-Tiny-0.033-3.el7.noarch.rpm                                                                                                                                                              |  38 kB  00:00:00
(11/32): perl-JSON-2.59-2.el7.noarch.rpm                                                                                                                                                                    |  96 kB  00:00:00
(12/32): perl-5.16.3-299.el7_9.aarch64.rpm                                                                                                                                                                  | 7.9 MB  00:00:00
(13/32): perl-Pod-Escapes-1.04-299.el7_9.noarch.rpm                                                                                                                                                         |  52 kB  00:00:00
(14/32): perl-PathTools-3.40-5.el7.aarch64.rpm                                                                                                                                                              |  82 kB  00:00:00
(15/32): perl-Pod-Perldoc-3.20-4.el7.noarch.rpm                                                                                                                                                             |  87 kB  00:00:00
(16/32): perl-Pod-Usage-1.63-3.el7.noarch.rpm                                                                                                                                                               |  27 kB  00:00:00
(17/32): perl-Scalar-List-Utils-1.27-248.el7.aarch64.rpm                                                                                                                                                    |  35 kB  00:00:00
(18/32): perl-Socket-2.010-5.el7.aarch64.rpm                                                                                                                                                                |  48 kB  00:00:00
(19/32): perl-Storable-2.45-3.el7.aarch64.rpm                                                                                                                                                               |  73 kB  00:00:00
(20/32): perl-Pod-Simple-3.28-4.el7.noarch.rpm                                                                                                                                                              | 216 kB  00:00:00
(21/32): perl-Test-Harness-3.28-3.el7.noarch.rpm                                                                                                                                                            | 302 kB  00:00:00
(22/32): perl-Test-Simple-0.98-243.el7.noarch.rpm                                                                                                                                                           | 170 kB  00:00:00
(23/32): perl-Text-ParseWords-3.29-4.el7.noarch.rpm                                                                                                                                                         |  14 kB  00:00:00
(24/32): perl-Time-Local-1.2300-2.el7.noarch.rpm                                                                                                                                                            |  24 kB  00:00:00
(25/32): perl-Time-HiRes-1.9725-3.el7.aarch64.rpm                                                                                                                                                           |  45 kB  00:00:00
(26/32): perl-constant-1.27-2.el7.noarch.rpm                                                                                                                                                                |  19 kB  00:00:00
(27/32): perl-parent-0.225-244.el7.noarch.rpm                                                                                                                                                               |  12 kB  00:00:00
(28/32): perl-threads-1.87-4.el7.aarch64.rpm                                                                                                                                                                |  48 kB  00:00:00
(29/32): perl-threads-shared-1.43-6.el7.aarch64.rpm                                                                                                                                                         |  37 kB  00:00:00
(30/32): perl-macros-5.16.3-299.el7_9.aarch64.rpm                                                                                                                                                           |  44 kB  00:00:00
(31/32): perl-libs-5.16.3-299.el7_9.aarch64.rpm                                                                                                                                                             | 621 kB  00:00:00
(32/32): perl-podlators-2.5.1-3.el7.noarch.rpm                                                                                                                                                              | 112 kB  00:00:00
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                                                                               10 MB/s |  12 MB  00:00:01
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
** Found 2 pre-existing rpmdb problem(s), 'yum check' output follows:
2:postfix-2.10.1-7.el7.aarch64 has missing requires of libmysqlclient.so.18()(64bit)
2:postfix-2.10.1-7.el7.aarch64 has missing requires of libmysqlclient.so.18(libmysqlclient_18)(64bit)Installing : 1:perl-parent-0.225-244.el7.noarch                                                                                                                                                                             1/40Installing : perl-HTTP-Tiny-0.033-3.el7.noarch                                                                                                                                                                              2/40Installing : perl-podlators-2.5.1-3.el7.noarch                                                                                                                                                                              3/40Installing : perl-Pod-Perldoc-3.20-4.el7.noarch                                                                                                                                                                             4/40Installing : 1:perl-Pod-Escapes-1.04-299.el7_9.noarch                                                                                                                                                                       5/40Installing : perl-Encode-2.51-7.el7.aarch64                                                                                                                                                                                 6/40Installing : perl-Text-ParseWords-3.29-4.el7.noarch                                                                                                                                                                         7/40Installing : perl-Pod-Usage-1.63-3.el7.noarch                                                                                                                                                                               8/40Installing : perl-threads-1.87-4.el7.aarch64                                                                                                                                                                                9/40Installing : 4:perl-Time-HiRes-1.9725-3.el7.aarch64                                                                                                                                                                        10/40Installing : perl-Exporter-5.68-3.el7.noarch                                                                                                                                                                               11/40Installing : perl-constant-1.27-2.el7.noarch                                                                                                                                                                               12/40Installing : perl-Storable-2.45-3.el7.aarch64                                                                                                                                                                              13/40Installing : perl-Socket-2.010-5.el7.aarch64                                                                                                                                                                               14/40Installing : perl-Time-Local-1.2300-2.el7.noarch                                                                                                                                                                           15/40Installing : perl-Carp-1.26-244.el7.noarch                                                                                                                                                                                 16/40Installing : perl-threads-shared-1.43-6.el7.aarch64                                                                                                                                                                        17/40Installing : 1:perl-Pod-Simple-3.28-4.el7.noarch                                                                                                                                                                           18/40Installing : perl-File-Path-2.09-2.el7.noarch                                                                                                                                                                              19/40Installing : perl-PathTools-3.40-5.el7.aarch64                                                                                                                                                                             20/40Installing : perl-File-Temp-0.23.01-3.el7.noarch                                                                                                                                                                           21/40Installing : perl-Scalar-List-Utils-1.27-248.el7.aarch64                                                                                                                                                                   22/40Installing : 4:perl-libs-5.16.3-299.el7_9.aarch64                                                                                                                                                                          23/40Installing : 4:perl-macros-5.16.3-299.el7_9.aarch64                                                                                                                                                                        24/40Installing : perl-Filter-1.49-3.el7.aarch64                                                                                                                                                                                25/40Installing : perl-Getopt-Long-2.40-3.el7.noarch                                                                                                                                                                            26/40Installing : 4:perl-5.16.3-299.el7_9.aarch64                                                                                                                                                                               27/40Installing : perl-Data-Dumper-2.145-3.el7.aarch64                                                                                                                                                                          28/40Installing : perl-JSON-2.59-2.el7.noarch                                                                                                                                                                                   29/40Installing : perl-Test-Harness-3.28-3.el7.noarch                                                                                                                                                                           30/40Installing : perl-Test-Simple-0.98-243.el7.noarch                                                                                                                                                                          31/40Installing : net-tools-2.0-0.25.20131004git.el7.aarch64                                                                                                                                                                    32/40Installing : mysql-community-server-8.0.36-1.el7.aarch64                                                                                                                                                                   33/40Installing : mysql-community-server-debug-8.0.36-1.el7.aarch64                                                                                                                                                             34/40Installing : mysql-community-test-8.0.36-1.el7.aarch64                                                                                                                                                                     35/40Installing : mysql-community-embedded-compat-8.0.36-1.el7.aarch64                                                                                                                                                          36/40Installing : mysql-community-libs-compat-8.0.36-1.el7.aarch64                                                                                                                                                              37/40Installing : mysql-community-release-el7-5.noarch                                                                                                                                                                          38/40Installing : mysql-community-debuginfo-8.0.36-1.el7.aarch64                                                                                                                                                                39/40Installing : mysql-community-devel-8.0.36-1.el7.aarch64                                                                                                                                                                    40/40Verifying  : perl-HTTP-Tiny-0.033-3.el7.noarch                                                                                                                                                                              1/40Verifying  : perl-JSON-2.59-2.el7.noarch                                                                                                                                                                                    2/40Verifying  : perl-threads-1.87-4.el7.aarch64                                                                                                                                                                                3/40Verifying  : net-tools-2.0-0.25.20131004git.el7.aarch64                                                                                                                                                                     4/40Verifying  : 4:perl-Time-HiRes-1.9725-3.el7.aarch64                                                                                                                                                                         5/40Verifying  : perl-Exporter-5.68-3.el7.noarch                                                                                                                                                                                6/40Verifying  : perl-constant-1.27-2.el7.noarch                                                                                                                                                                                7/40Verifying  : perl-Storable-2.45-3.el7.aarch64                                                                                                                                                                               8/40Verifying  : mysql-community-devel-8.0.36-1.el7.aarch64                                                                                                                                                                     9/40Verifying  : perl-threads-shared-1.43-6.el7.aarch64                                                                                                                                                                        10/40Verifying  : perl-Test-Simple-0.98-243.el7.noarch                                                                                                                                                                          11/40Verifying  : perl-Socket-2.010-5.el7.aarch64                                                                                                                                                                               12/40Verifying  : perl-PathTools-3.40-5.el7.aarch64                                                                                                                                                                             13/40Verifying  : perl-Test-Harness-3.28-3.el7.noarch                                                                                                                                                                           14/40Verifying  : perl-File-Temp-0.23.01-3.el7.noarch                                                                                                                                                                           15/40Verifying  : 1:perl-Pod-Simple-3.28-4.el7.noarch                                                                                                                                                                           16/40Verifying  : perl-Encode-2.51-7.el7.aarch64                                                                                                                                                                                17/40Verifying  : perl-Time-Local-1.2300-2.el7.noarch                                                                                                                                                                           18/40Verifying  : mysql-community-debuginfo-8.0.36-1.el7.aarch64                                                                                                                                                                19/40Verifying  : 1:perl-Pod-Escapes-1.04-299.el7_9.noarch                                                                                                                                                                      20/40Verifying  : perl-Text-ParseWords-3.29-4.el7.noarch                                                                                                                                                                        21/40Verifying  : perl-Carp-1.26-244.el7.noarch                                                                                                                                                                                 22/40Verifying  : mysql-community-release-el7-5.noarch                                                                                                                                                                          23/40Verifying  : 1:perl-parent-0.225-244.el7.noarch                                                                                                                                                                            24/40Verifying  : mysql-community-libs-compat-8.0.36-1.el7.aarch64                                                                                                                                                              25/40Verifying  : mysql-community-server-debug-8.0.36-1.el7.aarch64                                                                                                                                                             26/40Verifying  : perl-Pod-Usage-1.63-3.el7.noarch                                                                                                                                                                              27/40Verifying  : perl-Pod-Perldoc-3.20-4.el7.noarch                                                                                                                                                                            28/40Verifying  : perl-podlators-2.5.1-3.el7.noarch                                                                                                                                                                             29/40Verifying  : mysql-community-server-8.0.36-1.el7.aarch64                                                                                                                                                                   30/40Verifying  : perl-File-Path-2.09-2.el7.noarch                                                                                                                                                                              31/40Verifying  : perl-Scalar-List-Utils-1.27-248.el7.aarch64                                                                                                                                                                   32/40Verifying  : 4:perl-5.16.3-299.el7_9.aarch64                                                                                                                                                                               33/40Verifying  : 4:perl-libs-5.16.3-299.el7_9.aarch64                                                                                                                                                                          34/40Verifying  : perl-Getopt-Long-2.40-3.el7.noarch                                                                                                                                                                            35/40Verifying  : 4:perl-macros-5.16.3-299.el7_9.aarch64                                                                                                                                                                        36/40Verifying  : perl-Filter-1.49-3.el7.aarch64                                                                                                                                                                                37/40Verifying  : mysql-community-test-8.0.36-1.el7.aarch64                                                                                                                                                                     38/40Verifying  : perl-Data-Dumper-2.145-3.el7.aarch64                                                                                                                                                                          39/40Verifying  : mysql-community-embedded-compat-8.0.36-1.el7.aarch64                                                                                                                                                          40/40Installed:mysql-community-debuginfo.aarch64 0:8.0.36-1.el7       mysql-community-devel.aarch64 0:8.0.36-1.el7        mysql-community-embedded-compat.aarch64 0:8.0.36-1.el7       mysql-community-libs-compat.aarch64 0:8.0.36-1.el7mysql-community-release.noarch 0:el7-5                 mysql-community-server.aarch64 0:8.0.36-1.el7       mysql-community-server-debug.aarch64 0:8.0.36-1.el7          mysql-community-test.aarch64 0:8.0.36-1.el7Dependency Installed:net-tools.aarch64 0:2.0-0.25.20131004git.el7    perl.aarch64 4:5.16.3-299.el7_9             perl-Carp.noarch 0:1.26-244.el7                  perl-Data-Dumper.aarch64 0:2.145-3.el7      perl-Encode.aarch64 0:2.51-7.el7perl-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.aarch64 0:1.49-3.el7            perl-Getopt-Long.noarch 0:2.40-3.el7perl-HTTP-Tiny.noarch 0:0.033-3.el7             perl-JSON.noarch 0:2.59-2.el7               perl-PathTools.aarch64 0:3.40-5.el7              perl-Pod-Escapes.noarch 1:1.04-299.el7_9    perl-Pod-Perldoc.noarch 0:3.20-4.el7perl-Pod-Simple.noarch 1:3.28-4.el7             perl-Pod-Usage.noarch 0:1.63-3.el7          perl-Scalar-List-Utils.aarch64 0:1.27-248.el7    perl-Socket.aarch64 0:2.010-5.el7           perl-Storable.aarch64 0:2.45-3.el7perl-Test-Harness.noarch 0:3.28-3.el7           perl-Test-Simple.noarch 0:0.98-243.el7      perl-Text-ParseWords.noarch 0:3.29-4.el7         perl-Time-HiRes.aarch64 4:1.9725-3.el7      perl-Time-Local.noarch 0:1.2300-2.el7perl-constant.noarch 0:1.27-2.el7               perl-libs.aarch64 4:5.16.3-299.el7_9        perl-macros.aarch64 4:5.16.3-299.el7_9           perl-parent.noarch 1:0.225-244.el7          perl-podlators.noarch 0:2.5.1-3.el7perl-threads.aarch64 0:1.87-4.el7               perl-threads-shared.aarch64 0:1.43-6.el7Complete!
[root@localhost mysql-rpm]#

4.安装完成后检查mysql 

5.初始化MySQL

[root@localhost mysql-rpm]# mysqld --initialize

6.那就问了,都初始化了啥?

由上述时间可以看出,初始化是在创建一些列的文件

7.尝试启动MySQL

[root@localhost mysql]# systemctl start mysqld

 报错如下:Error: 13 (Permission denied)

8.给mysql文件授权

[root@localhost lib]# chmod -R 777 ./mysql

 9.再次尝试启动正常

10.mysql初始化目录出现了mysql.sock

这个mysql.sock应该是mysql的主机和客户机在同一host(物理服务器)上的时候,使用unix domain socket做为通讯协议的载体,它比tcp快 

11.找到MySQL初始化时的密码

利用密码:VdugGzt9dH%q登录MySQL并修改密码配置远程访问

mysql> ALTER USER USER() IDENTIFIED BY '1qaz1234';
Query OK, 0 rows affected (0.07 sec)
mysql>FLUSH PRIVILEGES;
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> update user set host='%';
Query OK, 4 rows affected (0.04 sec)
Rows matched: 4  Changed: 4  Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;
Query OK, 0 rows affected (0.04 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)
mysql>mysql> grant all privileges on *.* to 'root'@'%' ;
Query OK, 0 rows affected (0.02 sec)mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.02 sec)

12.测试PC客户端连接工具

13. 关闭SSL连接成功

 14.另外如果用的时navicat版本较低连接会报错

 15.请选用版本较高的navicat连接工具

16.新版本的navicat获取方式

Navicat16安装和激活详细讲解(全网最简单且靠谱)-CSDN博客

本文来自互联网用户投稿,该文观点仅代表作者本人,不代表本站立场。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如若转载,请注明出处:http://www.rhkb.cn/news/319339.html

如若内容造成侵权/违法违规/事实不符,请联系长河编程网进行投诉反馈email:809451989@qq.com,一经查实,立即删除!

相关文章

buuctf-misc-30.被劫持的神秘礼物1

30.被劫持的神秘礼物1 题目:http数据流追踪,MD5哈希一下账户名和密码 MD5在线加密/解密/破解—MD5在线 (sojson.com)

C语言 | Leetcode C语言题解之第61题旋转链表

题目: 题解: struct ListNode* rotateRight(struct ListNode* head, int k) {if (k 0 || head NULL || head->next NULL) {return head;}int n 1;struct ListNode* iter head;while (iter->next ! NULL) {iter iter->next;n;}int add n…

NASA数据集——NOAA 气溶胶和海洋科学考察数据(AEROSE)

Saharan Dust AERosols and Ocean Science Expeditions 简介 NOAA 气溶胶和海洋科学考察(AEROSE)是一种基于测量的综合方法,用于了解热带海洋上空气溶胶长程飘移的影响(Morris 等人,2006 年;Nalli 等人&a…

GitHub显示无法在此仓库中合并不相关的历史记录

你好,我是Qiuner. 为记录自己编程学习过程和帮助别人少走弯路而写博客 这是我的 github gitee 如果本篇文章帮到了你 不妨点个赞吧~ 我会很高兴的 😄 (^ ~ ^) 想看更多 那就点个关注吧 我会尽力带来有趣的内容 GitHub显示无法在此仓库中合并不相关的历史记录 场景&…

C++初阶之模板初阶

一、泛型编程 如何实现一个通用的交换函数呢? void Swap(int& left, int& right) {int temp left;left right;right temp; } void Swap(double& left, double& right) {double temp left;left right;right temp; } void Swap(char& left,…

分类规则挖掘(一)

目录 一、分类问题概述(一)分类规则挖掘(二)分类规则评估(三)分类规则应用 二、k-最近邻分类法 一、分类问题概述 动物分类:设有动物学家陪小朋友林中散步,若有动物突然从小朋友身边…

详解SDRAM基本原理以及FPGA实现读写控制(一)

文章目录 一、SDRAM简介二、SDRAM存取结构以及原理2.1 BANK以及存储单元结构2.2 功能框图2.3 SDRAM速度等级以及容量计算 三、SDRAM操作命令3.1 禁止命令: 4b1xxx3.2 空操作命令:4b01113.3 激活命令:4b00113.4 读命令:4b01013.5 写…

llama_index微调BGE模型

微调模型是为了让模型在特殊领域表现良好,帮助其学习到专业术语等。 本文采用llama_index框架微调BGE模型,跑通整个流程,并学习模型微调的方法。 已开源:https://github.com/stay-leave/enhance_llm 一、环境准备 Linux环境,GPU L20 48G,Python3.8.10。 pip该库即可。…

新型直膨式光伏光热热泵/动力热管复合循环系统

太阳能光伏光热热泵(即PVT热泵)技术是建筑领域内实现碳中和的有效技术手段,该技术具有优越的热电冷联产能力。然而,现有的PVT热泵在良好的室外工况下能耗较高。为了解决这一问题,本文提出了一种新型的DX-PVT热泵/动力热…

【c++】模板编程解密:C++中的特化、实例化和分离编译

🔥个人主页:Quitecoder 🔥专栏:c笔记仓 朋友们大家好,本篇文章我们来学习模版的进阶部分 目录 1.非类型模版参数按需实例化 2.模版的特化函数模版特化函数模版的特化类模版全特化偏特化 3.分离编译模版分离编译 1.非类…

ubuntu搭建kms服务器

1.下载kms开源包(如果提示找不到wget命令的话:apt install wget): wget https://github.com/Wind4/vlmcsd/releases/download/svn1111/binaries.tar.gz2.解压: tar -xzvf binaries.tar.gz接着cd 进入 Linux/intel/static/ 文件夹下: 3.选择对应的文件,这里我们选…

力扣每日一题104:二叉树的最大深度

题目 给定一个二叉树 root ,返回其最大深度。 二叉树的 最大深度 是指从根节点到最远叶子节点的最长路径上的节点数。 示例 1: 输入:root [3,9,20,null,null,15,7] 输出:3示例 2: 输入:root [1,null,2…

OpenCV(二)—— 车牌定位

从本篇文章开始我们进入 OpenCV 的 Demo 实战。首先,我们会用接下来的三篇文章介绍车牌识别 Demo。 1、概述 识别图片中的车牌号码需要经过三步: 车牌定位:从整张图片中识别出牌照,主要操作包括对原图进行预处理、把车牌从整图…

飞书API(7):MySQL 入库通用版本

一、引入 在上一篇介绍了如何使用 pandas 处理飞书接口返回的数据,并将处理好的数据入库。最终的代码拓展性太差,本篇来探讨下如何使得上一篇的最终代码拓展性更好!为什么上一篇的代码拓展性太差呢?我总结了几点: 列…

Ubuntu编译安装MariaDB并进行初始化配置

Ubuntu编译安装MariaDB并进行初始化配置 1. 编译安装MariaDB2. 配置MariaDB3. Docker安装MariaDB 1. 编译安装MariaDB MariaDB官方安装文档:https://mariadb.com/kb/en/Build_Environment_Setup_for_Linux/    下载MariaDB源码:https://mariadb.org/ma…

022、Python+fastapi,第一个Python项目走向第22步:ubuntu 24.04 docker 安装mysql8集群、redis集群(三)

这次来安装mysql8了,以前安装不是docker安装,这个我也是第一次,人人都有第一次嚒 前言 前面的redis安装还是花了点时间的,主要是网上教程,各有各的好,大家千万别取其长处,个人觉得这个环境影响…

【C语言】分支和循环(上)

【C语言】分支和循环(上) 1、if语句1.2 else1.3分支中包含多条语句1.4嵌套if1.5悬空else问题 2、关系操作符3、条件操作符4、逻辑操作符:与、或、非(取反)(&&,||,&#xff0…

深入理解网络原理3----TCP核心特性介绍(上)【面试高频考点】

文章目录 前言TCP协议段格式一、确认应答【保证可靠性传输的机制】二、超时重传【保证可靠性传输的机制】三、连接管理机制【保证可靠性传输的机制】3.1建立连接(TCP三次握手)---经典面试题3.2断开连接(四次挥手)3.3TCP状态转换 四…

「 网络安全常用术语解读 」通用漏洞报告框架CVRF详解

1. 背景 ICASI在推进多供应商协调漏洞披露方面处于领先地位,引入了通用漏洞报告框架(Common Vulnerability Reporting Format,CVRF)标准,制定了统一安全事件响应计划(USIRP)的原则,…

JSP与JavaBean

目录 一、JavaBean是什么 二、创建JavaBean 三、在JSP中使用JavaBean 1、按照Java语法直接使用 2、<jsp:useBean>动作 Bean的加载原理 scope属性的不同取值 3、<jsp:setProperty>动作 设置为一个表达式的值或字符序列 通过表单的参数的值来设置Bean的相应…