Xshell 7 (Build 0073)
Copyright (c) 2020 NetSarang Computer, Inc. All rights reserved.
Type `help' to learn how to use Xshell prompt.
[D:\~]$
Connecting to 39.101.186.205:22...
Connection established.
To escape to local shell, press 'Ctrl+Alt+]'.
WARNING! The remote SSH server rejected X11 forwarding request.
Welcome to Alibaba Cloud Elastic Compute Service !
Activate the web console with: systemctl enable --now cockpit.socket
Last login: Wed Jul 14 20:55:43 2021 from 118.31.243.6
[root@iZ8vb41uiu8xvw4d5dzodbZ ~]# systemctl list-dependencies mysqld
mysqld.service
● ├─-.mount
● ├─system.slice
● └─sysinit.target
● ├─dev-hugepages.mount
● ├─dev-mqueue.mount
● ├─dracut-shutdown.service
● ├─import-state.service
● ├─kmod-static-nodes.service
● ├─ldconfig.service
● ├─loadmodules.service
● ├─lvm2-lvmpolld.socket
● ├─lvm2-monitor.service
● ├─nis-domainname.service
● ├─plymouth-read-write.service
● ├─plymouth-start.service
● ├─proc-sys-fs-binfmt_misc.automount
● ├─rngd.service
● ├─selinux-autorelabel-mark.service
● ├─sys-fs-fuse-connections.mount
● ├─sys-kernel-config.mount
● ├─sys-kernel-debug.mount
● ├─systemd-ask-password-console.path
● ├─systemd-binfmt.service
● ├─systemd-firstboot.service
● ├─systemd-hwdb-update.service
● ├─systemd-journal-catalog-update.service
● ├─systemd-journal-flush.service
● ├─systemd-journald.service
● ├─systemd-machine-id-commit.service
● ├─systemd-modules-load.service
● ├─systemd-random-seed.service
● ├─systemd-sysctl.service
● ├─systemd-sysusers.service
● ├─systemd-tmpfiles-setup-dev.service
● ├─systemd-tmpfiles-setup.service
● ├─systemd-udev-trigger.service
● ├─systemd-udevd.service
● ├─systemd-update-done.service
● ├─systemd-update-utmp.service
● ├─cryptsetup.target
● ├─local-fs.target
● │ ├─-.mount
● │ └─systemd-remount-fs.service
● └─swap.target
[root@iZ8vb41uiu8xvw4d5dzodbZ ~]# rpm -qa|grep mariadb
mariadb-common-10.3.28-1.module_el8.3.0+757+d382997d.x86_64
mariadb-gssapi-server-10.3.28-1.module_el8.3.0+757+d382997d.x86_64
mariadb-connector-c-config-3.1.11-2.el8_3.noarch
mariadb-server-10.3.28-1.module_el8.3.0+757+d382997d.x86_64
mariadb-backup-10.3.28-1.module_el8.3.0+757+d382997d.x86_64
mariadb-10.3.28-1.module_el8.3.0+757+d382997d.x86_64
mariadb-errmsg-10.3.28-1.module_el8.3.0+757+d382997d.x86_64
mariadb-server-utils-10.3.28-1.module_el8.3.0+757+d382997d.x86_64
mariadb-connector-c-3.1.11-2.el8_3.x86_64
[root@iZ8vb41uiu8xvw4d5dzodbZ ~]# cd /cd usr/localmkdir mysql
-bash: cd: too many arguments
[root@iZ8vb41uiu8xvw4d5dzodbZ ~]# cd /usr
[root@iZ8vb41uiu8xvw4d5dzodbZ usr]# cd/mysql
-bash: cd/mysql: No such file or directory
[root@iZ8vb41uiu8xvw4d5dzodbZ usr]# cd /usr/mysql
-bash: cd: /usr/mysql: No such file or directory
[root@iZ8vb41uiu8xvw4d5dzodbZ usr]# cd /usr /mysql
-bash: cd: too many arguments
[root@iZ8vb41uiu8xvw4d5dzodbZ usr]# cd /usr/local/mysql
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar
--2021-07-15 07:38:34-- https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar
Resolving dev.mysql.com (dev.mysql.com)... 137.254.60.11
Connecting to dev.mysql.com (dev.mysql.com)|137.254.60.11|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://cdn.mysql.com//archives/mysql-8.0/mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar [following]
--2021-07-15 07:38:36-- https://cdn.mysql.com//archives/mysql-8.0/mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar
Resolving cdn.mysql.com (cdn.mysql.com)... 96.16.112.74
Connecting to cdn.mysql.com (cdn.mysql.com)|96.16.112.74|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 607068160 (579M) [application/x-tar]
Saving to: ‘mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar’
mysql-8.0.16-2.el7.x86_64.rp 100%[===========================================>] 578.95M 3.53MB/s in 2m 43s
2021-07-15 07:41:20 (3.54 MB/s) - ‘mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar’ saved [607068160/607068160]
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# tar -xvf mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar
mysql-community-libs-8.0.16-2.el7.x86_64.rpm
mysql-community-embedded-compat-8.0.16-2.el7.x86_64.rpm
mysql-community-devel-8.0.16-2.el7.x86_64.rpm
mysql-community-server-8.0.16-2.el7.x86_64.rpm
mysql-community-libs-compat-8.0.16-2.el7.x86_64.rpm
mysql-community-client-8.0.16-2.el7.x86_64.rpm
mysql-community-common-8.0.16-2.el7.x86_64.rpm
mysql-community-test-8.0.16-2.el7.x86_64.rpm
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# rpm -ivh mysql-community-common-8.0.16-2.el7.x86_64.rpm --nodeps --force
warning: mysql-community-common-8.0.16-2.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-common-8.0.16-2.e################################# [100%]
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# rpm -ivh mysql-community-libs-8.0.16-2.el7.x86_64.rpm --nodeps --force
warning: mysql-community-libs-8.0.16-2.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-libs-8.0.16-2.el7################################# [100%]
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# rpm -ivh mysql-community-client-8.0.16-2.el7.x86_64.rpm --nodeps --force
warning: mysql-community-client-8.0.16-2.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-client-8.0.16-2.e################################# [100%]
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# rpm -ivh mysql-community-server-8.0.16-2.el7.x86_64.rpm --nodeps --force
warning: mysql-community-server-8.0.16-2.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-server-8.0.16-2.e################################# [100%]
/usr/bin/my_print_defaults: error while loading shared libraries: libssl.so.10: cannot open shared object file: No such file or directory
[/usr/lib/tmpfiles.d/mysql.conf:23] Line references path below legacy directory /var/run/, updating /var/run/mysqld → /run/mysqld; please update the tmpfiles.d/ drop-in file accordingly.
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# rpm -ga | grep mysql
rpm: one type of query/verify may be performed at a time
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# rpm -qa | grep mysql
mysql-community-server-8.0.16-2.el7.x86_64
mysql-community-libs-8.0.16-2.el7.x86_64
mysql-community-client-8.0.16-2.el7.x86_64
mysql-community-common-8.0.16-2.el7.x86_64
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# mysqld --initialize
mysqld: error while loading shared libraries: libssl.so.10: cannot open shared object file: No such file or directory
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# yum install -y libaio
Last metadata expiration check: 0:40:57 ago on Thu 15 Jul 2021 07:05:27 AM CST.
Package libaio-0.3.112-1.el8.x86_64 is already installed.
Dependencies resolved.
Nothing to do.
Complete!
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# mysqld --initialize
mysqld: error while loading shared libraries: libssl.so.10: cannot open shared object file: No such file or directory
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# find data
find: ‘data’: No such file or directory
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# find /data
find: ‘/data’: No such file or directory
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# rpm -qa|grep libaio
libaio-0.3.112-1.el8.x86_64
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# mysqld --initialize
mysqld: error while loading shared libraries: libssl.so.10: cannot open shared object file: No such file or directory
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# find libssl.so.10
find: ‘libssl.so.10’: No such file or directory
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# find / -name libssl.so.10
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# find /-name libssl.so.10
find: ‘/-name’: No such file or directory
find: ‘libssl.so.10’: No such file or directory
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# find wget http://mirror.centos.org/centos/8/AppStream/x86_64/os/Packages/compat-openssl10-1.0.2o-3.el8.x86_64.rpm
find: ‘wget’: No such file or directory
find: ‘http://mirror.centos.org/centos/8/AppStream/x86_64/os/Packages/compat-openssl10-1.0.2o-3.el8.x86_64.rpm’: No such file or directory
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# wget http://mirror.centos.org/centos/8/AppStream/x86_64/os/Packages/compat-openssl10-1.0.2o-3.el8.x86_64.rpm
--2021-07-15 07:59:47-- http://mirror.centos.org/centos/8/AppStream/x86_64/os/Packages/compat-openssl10-1.0.2o-3.el8.x86_64.rpm
Resolving mirror.centos.org (mirror.centos.org)... 147.75.93.107, 2406:da14:d02:6501:83d:3d3c:fc36:b359
Connecting to mirror.centos.org (mirror.centos.org)|147.75.93.107|:80... failed: Connection refused.
Connecting to mirror.centos.org (mirror.centos.org)|2406:da14:d02:6501:83d:3d3c:fc36:b359|:80... failed: Network is unreachable.
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# wget http://mirror.centos.org/centos/8/AppStream/x86_64/os/Packages/compat-openssl10-1.0.2o-3.el8.x86_64.rpm
--2021-07-15 08:00:25-- http://mirror.centos.org/centos/8/AppStream/x86_64/os/Packages/compat-openssl10-1.0.2o-3.el8.x86_64.rpm
Resolving mirror.centos.org (mirror.centos.org)... 147.75.93.107, 2406:da14:d02:6501:83d:3d3c:fc36:b359
Connecting to mirror.centos.org (mirror.centos.org)|147.75.93.107|:80... failed: Connection refused.
Connecting to mirror.centos.org (mirror.centos.org)|2406:da14:d02:6501:83d:3d3c:fc36:b359|:80... failed: Network is unreachable.
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# openssl version -a
OpenSSL 1.1.1g FIPS 21 Apr 2020
built on: Tue Mar 30 14:31:20 2021 UTC
platform: linux-x86_64
options: bn(64,64) md2(char) rc4(16x,int) des(int) idea(int) blowfish(ptr)
compiler: gcc -fPIC -pthread -m64 -Wa,--noexecstack -Wall -O3 -O2 -g -pipe -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2 -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong -grecord-gcc-switches -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1 -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtune=generic -fasynchronous-unwind-tables -fstack-clash-protection -fcf-protection -Wa,--noexecstack -Wa,--generate-missing-build-notes=yes -specs=/usr/lib/rpm/redhat/redhat-hardened-ld -DOPENSSL_USE_NODELETE -DL_ENDIAN -DOPENSSL_PIC -DOPENSSL_CPUID_OBJ -DOPENSSL_IA32_SSE2 -DOPENSSL_BN_ASM_MONT -DOPENSSL_BN_ASM_MONT5 -DOPENSSL_BN_ASM_GF2m -DSHA1_ASM -DSHA256_ASM -DSHA512_ASM -DKECCAK1600_ASM -DRC4_ASM -DMD5_ASM -DAESNI_ASM -DVPAES_ASM -DGHASH_ASM -DECP_NISTZ256_ASM -DX25519_ASM -DPOLY1305_ASM -DZLIB -DNDEBUG -DPURIFY -DDEVRANDOM="\"/dev/urandom\"" -DSYSTEM_CIPHERS_FILE="/etc/crypto-policies/back-ends/openssl.config"
OPENSSLDIR: "/etc/pki/tls"
ENGINESDIR: "/usr/lib64/engines-1.1"
Seeding source: os-specific
engines: rdrand dynamic
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# wget http://mirror.centos.org/centos/8/AppStream/x86_64/os/Packages/compat-openssl10-1.0.2o-3.el8.x86_64.rpm
--2021-07-15 08:06:11-- http://mirror.centos.org/centos/8/AppStream/x86_64/os/Packages/compat-openssl10-1.0.2o-3.el8.x86_64.rpm
Resolving mirror.centos.org (mirror.centos.org)... 54.169.224.98, 2406:da1a:fcb:2f01:b6e2:c6:795:b503
Connecting to mirror.centos.org (mirror.centos.org)|54.169.224.98|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1186088 (1.1M) [application/x-rpm]
Saving to: ‘compat-openssl10-1.0.2o-3.el8.x86_64.rpm’
compat-openssl10-1.0.2o-3.el 100%[===========================================>] 1.13M 1.69MB/s in 0.7s
2021-07-15 08:06:12 (1.69 MB/s) - ‘compat-openssl10-1.0.2o-3.el8.x86_64.rpm’ saved [1186088/1186088]
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# rpm -i compat-openssl10-1.0.2o-3.el8.x86_64.rpm
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# mysqld --initialize
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# chown mysql:mysql /var/lib/mysql -R
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# systemctl start mysqld.service;systemctl enable mysqld
Failed to enable unit: Refusing to operate on linked unit file mysqld.service
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# systemctl start mysqld.service;
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]# cat /var/log/mysqld.log | grep password
2021-07-15T00:06:54.993047Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: <1I,wb:oqh8B
[root@iZ8vb41uiu8xvw4d5dzodbZ mysql]#
bug记录草稿
最新推荐文章于 2024-06-10 22:30:21 发布